Overview
Applied PSU 11.2.0.4.6 to the REPOS database on GRIDCTRL .
References
- Patch 20299013 - Database Patch Set Update 11.2.0.4.6 (Includes CPUApr2015)
- Database 11.2.0.4.6 PSU Patch 20299013 for UNIX
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.