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.
Used SQL*Plus to shut down the database cleanly.
Used lsnrctl stop to stop the Oracle listener.
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
Used the following command to put opatch into the path:
export PATH=${ORACLE_HOME}/OPatch:${PATH}
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.
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.
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
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.
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.
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:
/opt/oracle/app/cfgtoollogs/catbundle/catbundle_PSU_REPOS_GENERATE_2014Apr16_19_12_12.log/opt/oracle/app/cfgtoollogs/catbundle/catbundle_PSU_REPOS_APPLY_2014Apr16_19_12_15.logThere were no errors in either file.