17 Apply PSU 11.2.0.4.6 to REPOS

Overview

Applied PSU 11.2.0.4.6 to the REPOS database on GRIDCTRL.

References

Procedure

Download Patch

Downloaded the Database 11.2.0.4.6 PSU Patch 20299013 for UNIX into /home/oracle.

Check Version for OPatch

Used the following command to verify the version of OPatch:

${ORACLE_HOME}/OPatch/opatch version

The Patch README says that the minimum version of OPatch is 11.2.0.3.6 which is the same as the installed version:

OPatch Version: 11.2.0.3.6 OPatch succeeded.

Environment Checks

Used the following command to check the environment:

which make ar ld nm

The following output shows that the environment is correct:

/usr/bin/make /usr/bin/ar /usr/bin/ld /usr/bin/nm

One-off Patch Conflict Detection and Resolution

Used the following commands to check for patch conflicts:

cd unzip -q p20299013_112040_LINUX.zip cd 20299013/ ${ORACLE_HOME}/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

The following output shows that there are no patch conflicts:

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/opatch2015-04-24_19-56-41PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.

Shut Down Oracle Processes

Used the following commands to stop the listener and database instance:

lsnrctl stop sqlplus / as sysdba shutdown immediate exit

Apply Patch

Used the following commands to apply the patch:

cd ~/20299013 ${ORACLE_HOME}/OPatch/opatch apply

The apply log is:

Oracle Interim Patch Installer version 11.2.0.3.6 Copyright (c) 2013, Oracle Corporation. All rights reserved. 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/opatch2015-04-24_19-59-26PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 20299013 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. Provide your email address to be informed of security issues, install and initiate Oracle Configuration Manager. Easier for you if you use your My Oracle Support Email address/User Name. Visit http://www.oracle.com/support/policies.html for details. Email address/User Name: You have not provided an email address for notification of security issues. Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/opt/oracle/app/OracleHomes/db11g') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying sub-patch '20299013' to OH '/opt/oracle/app/OracleHomes/db11g' Patching component oracle.rdbms.dv, 11.2.0.4.0... Patching component oracle.rdbms.oci, 11.2.0.4.0... Patching component oracle.precomp.common, 11.2.0.4.0... Patching component oracle.sysman.agent, 10.2.0.4.5... Patching component oracle.xdk, 11.2.0.4.0... Patching component oracle.sysman.common, 10.2.0.4.5... Patching component oracle.rdbms, 11.2.0.4.0... Patching component oracle.rdbms.dbscripts, 11.2.0.4.0... Patching component oracle.xdk.parser.java, 11.2.0.4.0... Patching component oracle.sysman.console.db, 11.2.0.4.0... Patching component oracle.xdk.rsf, 11.2.0.4.0... Patching component oracle.rdbms.rsf, 11.2.0.4.0... Patching component oracle.sysman.common.core, 10.2.0.4.5... Patching component oracle.rdbms.rman, 11.2.0.4.0... Patching component oracle.rdbms.deconfig, 11.2.0.4.0... Verifying the update... Composite patch 20299013 successfully applied. Log file location: /opt/oracle/app/OracleHomes/db11g/cfgtoollogs/opatch/opatch2015-04-24_19-59-26PM_1.log OPatch succeeded.

Patch Post-Installation

Used the following commands to finish the PSU:

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

A lot of screen output is produced.

Check for Errors

I used the following command to list all of the errors found in the PSU apply log:

egrep "^ORA-" -B3 /opt/oracle/app/cfgtoollogs/catbundle/catbundle_PSU_REPOS_APPLY_2015Apr24_20_10_53.log

The error messages are:

create or replace type SYSTEM.LOGMNR$TAB_GG_REC wrapped * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents -- create or replace type SYSTEM.LOGMNR$COL_GG_REC wrapped * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents -- create or replace type SYSTEM.LOGMNR$SEQ_GG_REC wrapped * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents -- create or replace type SYSTEM.LOGMNR$KEY_GG_REC wrapped * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents -- CREATE TYPE SYSTEM.LOGMNR$TAB_GG_RECS AS TABLE OF SYSTEM.LOGMNR$TAB_GG_REC; * ERROR at line 1: ORA-00955: name is already used by an existing object -- CREATE TYPE SYSTEM.LOGMNR$COL_GG_RECS AS TABLE OF SYSTEM.LOGMNR$COL_GG_REC; * ERROR at line 1: ORA-00955: name is already used by an existing object -- CREATE TYPE SYSTEM.LOGMNR$SEQ_GG_RECS AS TABLE OF SYSTEM.LOGMNR$SEQ_GG_REC; * ERROR at line 1: ORA-00955: name is already used by an existing object -- CREATE TYPE SYSTEM.LOGMNR$KEY_GG_RECS AS TABLE OF SYSTEM.LOGMNR$KEY_GG_REC; * ERROR at line 1: ORA-00955: name is already used by an existing object

According to 5 Known Issues of Patch 20299013 - Database Patch Set Update 11.2.0.4.6 (Includes CPUApr2015), these are all ignorable errors.