Step by step Oracle Installation

Step by step Oracle Installation

Database Version :- Oracle 11G on Windows.

Let’s try to install the oracle database. Before installing oracle database let’s discuss about what are the prerequisites to install oracle database.

Make sure below list is available on windows operating system:-

        1)       Oracle database setup files (32 bit / 64 bit)

        2)       Physical memory (RAM) minimum 1 GB

        3)       Disk space 5.22 GB minimum.

Installation Type	TEMP Space	SYSTEM_DRIVE:\ Program Files\Oracle	Oracle Home	Data Files *	Total
Basic Installation	125 MB	2 MB	3.1 GB	2.0 GB	5.22 GB
Advanced Installation	125 MB	2 MB	3.1 GB **	2.0 GB **	5.22 GB **

Verifying Hardware Requirements

To ensure that the system meets these requirements, follow these steps:

1. Determine the physical RAM size. For example, on a Windows 2003 computer, double-click System in the Windows Control Panel and click the General tab. If the size of the physical RAM installed in the system is less than the required size, then you must install more memory before continuing.
2. Determine the size of the configured virtual memory (also known as paging file size). For example, on a Windows 2003 computer, double-click System, click the advanced tab, and click Settings in the Performance section. Then click the advanced tab. The virtual memory is listed in the Virtual Memory section.
3. Determine the amount of free disk space on the system. For example, on a Windows 2003 computer, double-click My Computer, right-click the drive where the Oracle software is to be installed, and select Properties.
4. Determine the amount of disk space available in the temp directory. This is equivalent to the total amount of free disk space, minus what will be needed for the Oracle software to be installed.

On Windows 32-Bit, if there is less than 200 MB of disk space available in the temp directory, then delete all unnecessary files. If the temp disk space is still less than 200 MB, then set the TEMP or TMP environment variable to point to a different hard drive location.

On Windows x64, if there is less than 125 MB of disk space available in the temp directory, then delete all unnecessary files. If the temp disk space is still less than 125 MB, then set the TEMP or TMP environment variable to point to a different hard drive location.

For example, to change the environment variables on a Windows 2003 computer, double-click System, click the advanced tab, and click Environment Variables.

So let’s start to install oracle database. I have downloaded oracle 11G R2 of 64 bit for my 64 bit windows operating system.

Below are the hardware and software I have:-

         1)       Windows operating system 64 bit

         2)       Oracle 11G R2 database setup for 64 bit

         3)       8 GB RAM

         4)       60 GB hard disc

   Now follow the below steps to install oracle database:-

       1)       Unzip the downloaded oracle setup files on same folder:-

       

     2)       Now fix the oracle bug.

A)       Open second folder and copy all the folders from win64_11gR2_database_2of2\database\stage\Components  location and paste the copied files to win64_11gR2_database_1of2\database\stage\Components (First Folder). 

      3)       Execute the setup file from the first folder (win64_11gR2_database_1of2\database\stage\Components):-

      

      4)       Once you double click on the setup file you would see below shown screen:-

     

        5)       Above command prompt will launch the oracle universal installer as shown below:-

       6)       Click on Next. Oracle will prompt you for Email address. If you want to provide any Email address then             you can otherwise click on Yes button and go further. I am not providing Email address:-

       

    Click on Yes button.

     

     7)  After clicking on Yes button choose installation option. Check click and configure a database and click  Next button

          

        8)       Choose which system class that you need to install. There two option Desktop and Server class. Check         on Desktop class (as we are installing it on Desktop) and click next button:-

        

         9)  Specify the Oracle Base and Oracle Home path. Also you can specify the oracle database file location:-

     

        

        10)   Provide the database edition that you need to install. I have chosen Enterprise Edition.

                

     

        11)    Choose a character set. I have chosen default character set:-

        

     12)    Specify the Oracle database name and administrator password and click Next button:-

         

          13)   If everything is fine then oracle will perform prerequisite check:-

        14)   After prerequisite check, Oracle will show you installation summary. Verify the summary and click on               Finish:-

   

     15)   Once you click on Finish, Oracle will start to install the Oracle software and configure a database that you have specified:-

       

       

      16)    In the installation process, Oracle first will prepare for installation, copy the Oracle files and setup that files. After performing setup, Oracle will configure listener and:-

        

      

      17)    After configuring oracle Listener, Oracle will configure the database by using oracle database                         configuration assistant:-  

          

       18)  After configuring Oracle database, it will show you detail check list of the oracle database:-

       

     19)  You can click on password management button and verify the Oracle Default account information. After            verification click on OK button:-

        

         20)   Finally, you will see “INSTALLATION IS SUCCESSFUL”.  Click on Close button:-

          

       In the above scenario, we have installed oracle 11G R2 on windows operating system successfully. Our database name is ORCL and password is ORACLE9i. Check out whether we can able to connect to oracle database or not:-

       

    NOTE: - Database is in NOARCHIVELOG mode.