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.