12 Apply PSU 11.2.0.4.2 to REPOS
11 Fix REPOS For OMS Install
13 Install REPVFY

Contents

  1. 1 Overview
  2. 2 References
  3. 3 Procedure
    1. 3.1 Shutdown Database and Listener
    2. 3.2 Prepare Patch Directory
    3. 3.3 Put opatch in Path
    4. 3.4 Check OPatch Version
    5. 3.5 Download Latest Version of opatch
    6. 3.6 Environment Checks
    7. 3.7 Check for Patch Conflicts
    8. 3.8 Apply the Patch
    9. 3.9 Loading Modified SQL Files into the Database
  4. 4 File Downloads

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.