Install Oracle RDBMS 11.2.0.3.0 without Grid Infrastructure

Overview

This procedure follows my attempt to install an Oracle RDBMS 11.2.0.3.0 home without Grid Infrastructure installed.

This procedure was followed by Apply Oracle RDBMS 11.2.0.3.3 Patchset which is incomplete because I decided to install Grid Infrastructure on GRIDCTRL.

Download the Patches

Using the locations described in Finding the 11.2.0.3.3 PSU, I transferred all of the files for Oracle RDBMS 11.2.0.3.0 and 11.2.0.3.3 to /tmp on GRIDCTRL:

/tmp/p10404530_112030_LINUX_1of7.zip /tmp/p10404530_112030_LINUX_2of7.zip /tmp/p10404530_112030_LINUX_3of7.zip /tmp/p10404530_112030_LINUX_4of7.zip /tmp/p10404530_112030_LINUX_5of7.zip /tmp/p10404530_112030_LINUX_6of7.zip /tmp/p10404530_112030_LINUX_7of7.zip

Create Directory

I created the following directories for the unzipped files:

mkdir /opt/oracle/software/p10404530

Unzip the Files

Following the advice I was given in Start of Upgrade to Cloud Control 12.1.0.2 (#em12cr2), I used the unzip60_lnx utility instead of unzip because the former is able to handle files greater than 2GB.

Used the following commands to unzip the archives:

unzip60_lnx -d /opt/oracle/software/p10404530 /tmp/p10404530_112030_LINUX_1of7.zip unzip60_lnx -d /opt/oracle/software/p10404530 /tmp/p10404530_112030_LINUX_2of7.zip unzip60_lnx -d /opt/oracle/software/p10404530 /tmp/p10404530_112030_LINUX_3of7.zip unzip60_lnx -d /opt/oracle/software/p10404530 /tmp/p10404530_112030_LINUX_4of7.zip unzip60_lnx -d /opt/oracle/software/p10404530 /tmp/p10404530_112030_LINUX_5of7.zip unzip60_lnx -d /opt/oracle/software/p10404530 /tmp/p10404530_112030_LINUX_6of7.zip unzip60_lnx -d /opt/oracle/software/p10404530 /tmp/p10404530_112030_LINUX_7of7.zip

Install the Oracle RDBMS 11.2.0.3.0 Software

On GRIDCTRL, start the installation as follow:

cd /opt/oracle/software/p10404530/database

./runInstaller

Step 1: Configure Security Updates

The following screen appears after the splash screen:

Filled in my details and clicked Next.

Step 2: Download Software Updates

Just clicked Next, and the following pop-up appeared:

Step 3: Installation Option

Selected Install database software only, and clicked Next.

Step 4: Grid Installation Option

Selected Single instance database installation, and clicked Next.

Step 5: Product Languages

Left English as the selected language, and clicked Next.

Step 6: Database Edition

Selected Enterprise Edition because it is the closest match to Personal Edition. Clicked Select Options....

The following dialogue appeared:

Only selected Oracle Partitioning because this option is required by Oracle Enterprise Manager. See Add Partitioning Option to REPOS for the problems I encountered in OEM 10.2.0.5 when I did not install the partitioning option.

Clicked OK and went back to the screen in Step 6, and then clicked Next.

Step 7: Installation Location

The Oracle Base was left as is. I changed the software location to /opt/oracle/app/OracleHomes/db11.2.0.3 which is neither 11.1 nor 11.2 format, but a hybrid. Clicked Next.

Step 8: Operating System Groups

Left the OSDBA group as dba, and changed the OSOPER group to dba as well. Clicked Next.

Step 9: Prerequisite Checks

Got some warnings. Clicked on Fix & Check Again. The following dialogue appearred:

Ran the following commands:

sudo su - /tmp/CVU_11.2.0.3.0_oracle/runfixup.sh

Got the following results:

Response file being used is :/tmp/CVU_11.2.0.3.0_oracle/fixup.response Enable file being used is :/tmp/CVU_11.2.0.3.0_oracle/fixup.enable Log file location: /tmp/CVU_11.2.0.3.0_oracle/orarun.log Setting Kernel Parameters... The value for shmmni in response file is not greater than value of shmmni for current session. Hence not changing it. fs.file-max = 6553600 fs.file-max = 6815744 net.ipv4.ip_local_port_range = 9000 65500 net.core.wmem_max = 262144 net.core.wmem_max = 1048576 fs.aio-max-nr = 1048576

Clicked OK. Got a clean bill of health on the step #9 screen. Clcked Next.

Step 10: Summary

Clicked Install.

Step 11: Install Product

After a while, the following dialogue appearred:

Ran the following commands:

sudo su - /opt/oracle/app/OracleHomes/db11.2.0.3/root.sh

Got the following results:

Performing root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /opt/oracle/app/OracleHomes/db11.2.0.3 Enter the full pathname of the local bin directory: [/usr/local/bin]: The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying dbhome to /usr/local/bin ... The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying oraenv to /usr/local/bin ... The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y 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.

Clicked OK on the dialogue window.

Step 12: Finish

Clicked Close. All done.