Apply Oracle RDBMS 11.2.0.3.3 Patchset (Incomplete)

Overview

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

This procedure was preceded by Install Oracle RDBMS 11.2.0.3.0 without Grid Infrastructure.

This procedure 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.3 to /tmp on GRIDCTRL:

/tmp/p13923374_112030_LINUX.zip

Create Directory

I created the following directories for the unzipped files:

mkdir /opt/oracle/software/p13923374

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/p13923374 /tmp/p13923374_112030_LINUX.zip

Patch 13923374 - 11.2.0.3.3 Patch Set Update

Patch Home

The patch has been unzipped into /opt/oracle/software/p13923374/13923374.

Checking OPatch Version

Used the following commands to check the version of OPatch:

cd /opt/oracle/app/OracleHomes/db11.2.0.3/OPatch ./opatch version

And got the following results:

Invoking OPatch 11.2.0.1.7 OPatch Version: 11.2.0.1.7 OPatch succeeded.

The README for the patch says I need version 11.2.0.3.0 or later. Looks like I have to patch this Oracle Home with 6880880.

Install Patch 6880880

The file was downloaded into:

/opt/oracle/software/p6880880_112000_LINUX.zip

I used the following commands to install the patch:

mv /opt/oracle/app/OracleHomes/db11.2.0.3/OPatch \ /opt/oracle/app/OracleHomes/db11.2.0.3/OPatch_11.2.0.1.7 unzip60_lnx -d /opt/oracle/app/OracleHomes/db11.2.0.3 \ /opt/oracle/software/p6880880_112000_LINUX.zip

Verified the installation of the patch as follows:

/opt/oracle/app/OracleHomes/db11.2.0.3/OPatch/opatch version

And got the following result:

OPatch Version: 11.2.0.3.0 OPatch succeeded.

Install Grid Infrastructure

The README for Patch 13923374 says that:

If you are installing the PSU to an environment that has a Grid Infrastructure home, note the following:

    • Grid Infrastructure PSU 11.2.0.3.3 <<Patch 13919095>> should be applied to the Grid Infrastructure home and Database home using the readme instructions provided with the patch.

Although I do not yet have Grid Infrastructure installed on GRIDCTRL, I thought this would be a good time to do. So, I proceeded with Install Grid Infrastructure 11.2.0.3.3 on GRIDCTRL.