Thursday, January 3, 2013

Installing Oracle Database 11g Release 2

There is a need for us to upgrade our Fusion benchmarks.  The first step required is to install Oracle Database 11g Release 2.  You can choose to either upgrade an existing Oracle or create a new one.  In our case, we have chosen to create a new one.

In this article, we have documented the details of installation process.


The following configurations are based on our own need--using Oracle in our Fusion benchmarks.  This may be different from a real production Oracle that you need.
  1. Configure Security Updates
    • You can check the option if you wish to receive security updates via My Oracle Support.
  2. Download Software Updates
    • You can choose the option to update software by providing your credentials or skip it.
  3. Installation Option
    • For my purpose, I have selected "Create and configure a database."
    • For upgrade, you can select "Upgrade an existing database" option.
  4. System Class
    • Depends on your system, you can select either 
      • Desktop Class--for a starter database, which allows minimal configuration
      • Server Class--for an advanced database, which allows more advanced configuration options.
  5. Grid Installation Options
    • You select the type of database installation you want to perform.  For instance, I've chosen "Single instance database installation" here.  Other options include:
      • Oracle Real Application Clusters database installation
      • Oracle RAC One Node database installation
  6. Install Type
    • Two options are available: 
      • Typical 
      • Advanced
  7. Typical Installation Configuration
    • See Figure 1 for details
    • Administrative password
      • This is the password for "SYS" and "SYSTEM" database accounts[4].  Note that it is case sensitive since Oracle Database 11g Release 1[10].
    • Global Database Name (GDN)
      • In a distributed database system, each database should have a unique global database name. Global database names uniquely identify a database in the system. 
      • For example, we have used as our GDN.  Note that "orcl" in the GDN will become system identifier (SID).
  8. Prerequisite Checks
    • We have seen three issues:
      • User with Same UID 
        • You can ignore this although it has some complications; see [2]
      • Swap Size
        • See [3] for how to fix it
      • OS Kernel Parameter shmmax
    • You should try to fix these issues based on suggestions.
  9. Summary
  10. Install Product
  11. Finish

At step 10, a "Data Configuration Assistant" window will be shown.  On it, there is a "Password Management" button.  At this moment, all database accounts except SYS[4]SYSTEM and DBSNMP are locked.  So, from the Password Management window, you can unlock all other accounts you want to use.

Then an information window "Execute Configuration Scripts" is shown to advise you to execute a script named "" as "root" user.

Here is the result from the execution of

# ./
Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /disk1/home/oracle/atg/OracleDB_11.2.0.3/product/11.2.0/dbhome_1

Enter the full pathname of the local bin directory: [/usr/local/bin]: /usr/local/bin
Creating /usr/local/bin directory...
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.

At step 11, you should finally see the following message:
  • The installtion of Oracle Database was successful.



Blogger said...

If you want your ex-girlfriend or ex-boyfriend to come crawling back to you on their knees (even if they're dating somebody else now) you must watch this video
right away...

(VIDEO) Why your ex will NEVER get back...

Blogger said...

BlueHost is ultimately one of the best web-hosting company with plans for all of your hosting requirements.