Pages

Sunday, October 30, 2016

Oracle : Oracle Database 11gR2 Win64 Installation

Oracle Database 11gR2 Windows 64-bit Installation Steps

  1. Download Oracle Database installation zip binaries from the Oracle website.
    1. Go to the Oracle website, database/enterprise-edition/downloads page. Or Click Here!
    2. Search for Oracle Database 11g Release 2, Microsoft Windows (x64).
    3. You will see 2 files, File1 and File2.
    4. Download both of them (approx 2.06 GB).
  2. Extract the below downloaded zip files into respective folders.
    1. win64_11gR2_database_1of2.zip
    2. win64_11gR2_database_2of2.zip
  3. Now copy and paste /(merge) the contents of second unzipped folder into the first unzipped folder.
  4. Is merging really necessary? Can't I give the location while installing when prompted?
    • No. you can't. It doesn't work like that, even if you merge the folders after the error prompt. The error msg won't disappear. So save yourself some time and perform this step in advance.
  5. Execute the “setup.exe” file which is located in the “/database” folder of the first extracted zip file.
    1. “Setup.exe”, right click, run as administrator.
      Fig 1.1 Oracle Database 11gR2 Win64 Installation - Setup
      Fig 1.1 Oracle Database 11gR2 Win64 Installation - Setup
    2. Click yes on the "User Account Control" screen.
      Fig 1.2 Oracle Database 11gR2 Win64 Installation - User Account Control
      Fig 1.2 Oracle Database 11gR2 Win64 Installation - User Account Control
    3. Wait for the setup to build and initialize.
      Fig 1.3 Oracle Database 11gR2 Win64 Installation - Building Flow
      Fig 1.3 Oracle Database 11gR2 Win64 Installation - Building Flow
  6. Installation Steps (Total 9 steps)
    1. Step 1 of 9 - Configure Security Updates
      1. Unselect “I wish to receive security update..” and click next.
        Fig 1.4 Oracle Database 11gR2 Win64 Installation - Configure Security Updates
        Fig 1.4 Oracle Database 11gR2 Win64 Installation - Configure Security Updates
      2. Click yes on the "Email Address Not Specified" screen.
        Fig 1.5 Oracle Database 11gR2 Win64 Installation - Email Address Not Specified
        Fig 1.5 Oracle Database 11gR2 Win64 Installation - Email Address Not Specified
    2. Step 2 of 9 - Select Installation Options
      1. Select “Create and configure a database”.
        Fig 1.6 Oracle Database 11gR2 Win64 Installation - Select Installation Option
        Fig 1.6 Oracle Database 11gR2 Win64 Installation - Select Installation Option
      2. After this step, Total steps will change to 8.
    3. Step 3 of 8 - System Class
      1. Select “Desktop Class”.
        Fig 1.7 Oracle Database 11gR2 Win64 Installation - System Class
        Fig 1.7 Oracle Database 11gR2 Win64 Installation - System Class
    4. Step 4 of 8 - Typical Installation Configuration
      1. Enter “orcldb1”(or any name) as the “Global Database Name” for the new database.
      2. Enter “sysAdmin1”(or any password) as “Administrative Password” for sys/system database privilege.
      3. Confirm the same password again.
        Fig 1.8 Oracle Database 11gR2 Win64 Installation - Typical Install Configuration
        Fig 1.8 Oracle Database 11gR2 Win64 Installation - Typical Install Configuration
    5. Step 5 of 8 - Perform Prerequisite Checks
      1. Installation will automatically checks if the prerequisites are met.
        Fig 1.9 Oracle Database 11gR2 Win64 Installation - Perform Prerequisite Checks
        Fig 1.9 Oracle Database 11gR2 Win64 Installation - Perform Prerequisite Checks
    6. Step 6 of 8 - Summary
      1. Verify the configuration.
        Fig 1.10 Oracle Database 11gR2 Win64 Installation - Summary
        Fig 1.10 Oracle Database 11gR2 Win64 Installation - Summary
    7. Step 7 of 8 - Install Product
      1. Wait for the installation to finish, grab a cup of coffee meanwhile (approx 12 mins).
        Fig 1.11 Oracle Database 11gR2 Win64 Installation - Install Product
        Fig 1.11 Oracle Database 11gR2 Win64 Installation - Install Product
      2. Click on “Allow access” button on Windows Security Alert screen (2 times) .
        Fig 1.12 Oracle Database 11gR2 Win64 Installation - Windows Security Alert
        Fig 1.12 Oracle Database 11gR2 Win64 Installation - Windows Security Alert
      3. Database Configuration Assistant will now create and start Oracle instance (approx 10 mins).
        Fig 1.13 Oracle Database 11gR2 Win64 Installation - Database Configuration Assistant
        Fig 1.13 Oracle Database 11gR2 Win64 Installation - Database Configuration Assistant
      4. Click on “OK” button on the Database Configuration Assistant Summary page.
        Fig 1.14 Oracle Database 11gR2 Win64 Installation - Database Configuration Assistant Summary
        Fig 1.14 Oracle Database 11gR2 Win64 Installation - Database Configuration Assistant Summary
    8. Step 7 of 8 - Finish
      1. Click on “Close” button to finish the installation.
        Fig 1.15 Oracle Database 11gR2 Win64 Installation - Finish
        Fig 1.15 Oracle Database 11gR2 Win64 Installation - Finish
  7. Verify your installation
    1. Open a new SQL session by clicking on “SQL Plus” from Start menu, Oracle - home, Application Development. (Or you can also open it from the command line by typing the command sqlplus)
      Fig 1.16 Oracle Database 11gR2 Win64 Installation - Verification
      Fig 1.16 Oracle Database 11gR2 Win64 Installation - Verification
    2. Enter “system” as username and enter the Administrative password you entered earlier during installation.
      Fig 1.17 Oracle Database 11gR2 Win64 Installation - Sql Cmd Prompt
      Fig 1.17 Oracle Database 11gR2 Win64 Installation - Sql Cmd Prompt
    3. Enter the script “select * from global_name;” on the “SQL>” prompt.
    4. Result “ORCLDB1” verifies the installation.
      Fig 1.18 Oracle Database 11gR2 Win64 Installation - Verified
      Fig 1.18 Oracle Database 11gR2 Win64 Installation - Verified

No comments:

Post a Comment