12 Apply PSU 11.2.0.4.2 to REPOS

Overview

Patch Set Update and Critical Patch Update April 2014 Availability Document (Doc ID 1618213.1) says that Patch 18031668: DATABASE PATCH SET UPDATE 11.2.0.4.2 (INCLUDES CPUAPR2014) is now available.

References

Procedure

Shutdown Database and Listener

Used SQL*Plus to shut down the database cleanly.

Used lsnrctl stop to stop the Oracle listener.

Prepare Patch Directory

Uploaded the zip file to /opt/oracle/software, and used the following commands to unzip it:

cd /opt/oracle/software unzip p18031668_112040_LINUX.zip

Put opatch in Path

Used the following command to put opatch into the path:

export PATH=${ORACLE_HOME}/OPatch:${PATH}

Check OPatch Version

To ensure that the opatch utility is 11.2.0.3.6 or later, I ran the following command:

opatch version

I had the wrong version as shown below:

OPatch Version: 11.2.0.3.4 OPatch succeeded.

Download Latest Version of opatch

I downloaded the latest version of opatch from Patch 6880880: OPatch patch of version 11.2.0.3.6 for Oracle software releases 11.2.0.x (DEC 2013).

I overwrote the existing opatch as follows:

[oracle@gridctrl 18031668]$ unzip -q "/opt/oracle/software/p6880880_112000_LINUX.zip" -d ${ORACLE_HOME} replace /opt/oracle/app/OracleHomes/db11g/OPatch/jlib/oracle.opatch.classpath.jar? [y]es, [n]o, [A]ll, [N]one, [r]ename: A [oracle@gridctrl 18031668]$ opatch version OPatch Version: 11.2.0.3.6 OPatch succeeded.

The opatch version is now correct.

Environment Checks

The environment was set up correctly as show below:

[oracle@gridctrl 18031668]$ which make ar ld nm /usr/bin/make /usr/bin/ar /usr/bin/ld /usr/bin/nm

Check for Patch Conflicts

As described in the patch README, I ran the following commands to verify that there were no patch conflicts with the PSU:

cd 18031668/ opatch prereq CheckConflictAgainstOHWithDetail -ph ./

The output is:

Oracle Interim Patch Installer version 11.2.0.3.6 Copyright (c) 2013, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /opt/oracle/app/OracleHomes/db11g Central Inventory : /opt/oracle/oraInventory from : /opt/oracle/app/OracleHomes/db11g/oraInst.loc OPatch version : 11.2.0.3.6 OUI version : 11.2.0.4.0 Log file location : /opt/oracle/app/OracleHomes/db11g/cfgtoollogs/opatch/opatch2014-04-16_18-13-51PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.

Apply the Patch

I applied the patch as follows:

opatch apply

There were two (2) warnings which the patch README says can be ignored (issue #2):

ins_emagent.mk:113: warning: overriding commands for target `nmosudo' ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'

The full log is attached as psu_11_2_0_4_2.log.

Loading Modified SQL Files into the Database

Used the following commands to load the modified SQL files into REPOS:

cd ${ORACLE_HOME}/rdbms/admin sqlplus /nolog connect / as sysdba startup @catbundle.sql psu apply exit

Two (2) log files were generated:

  1. /opt/oracle/app/cfgtoollogs/catbundle/catbundle_PSU_REPOS_GENERATE_2014Apr16_19_12_12.log
  2. /opt/oracle/app/cfgtoollogs/catbundle/catbundle_PSU_REPOS_APPLY_2014Apr16_19_12_15.log

There were no errors in either file.