16 Apply PSU 11.2.0.4.5 to REPOS
Overview
Apply PSU 11.2.0.4.5 to REPOS. Missed out on PSU 11.2.0.4.4.
Procedure
Download Patch
Download PSU 11.2.0.4.5 for Linux-x86.
Zip file is uploaded to /opt/oracle/software and unzipped there. The installation directory becomes /opt/oracle/software/19769489.
Check Version of OPatch
The README says that OPatch 11.2.0.3.6 or later is required:
[oracle@gridctrl 19769489]$ ${ORACLE_HOME}/OPatch/opatch version
OPatch Version: 11.2.0.3.6
OPatch succeeded.
Environment Checks
[oracle@gridctrl 19769489]$ which make ar ld nm
/usr/bin/make
/usr/bin/ar
/usr/bin/ld
/usr/bin/nm
Check for Patch Conflict
[oracle@gridctrl 19769489]$ ${ORACLE_HOME}/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ 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-02-21_22-40-02PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.
Shutdown Database Instance and Listener
[oracle@gridctrl 19769489]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sat Feb 21 22:44:09 2015 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production With the Partitioning option SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production With the Partitioning option [oracle@gridctrl 19769489]$ lsnrctl stop LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 21-FEB-2015 22:44:42 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) The command completed successfully
Apply PSU
[oracle@gridctrl 19769489]$ ${ORACLE_HOME}/OPatch/opatch apply 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-02-21_22-44-57PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 19121551 19769489 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 '19121551' to OH '/opt/oracle/app/OracleHomes/db11g' Patching component oracle.precomp.common, 11.2.0.4.0... Patching component oracle.sysman.console.db, 11.2.0.4.0... Patching component oracle.rdbms.rsf, 11.2.0.4.0... Patching component oracle.rdbms.rman, 11.2.0.4.0... Patching component oracle.rdbms, 11.2.0.4.0... Patching component oracle.rdbms.dbscripts, 11.2.0.4.0... Patching component oracle.ordim.client, 11.2.0.4.0... Patching component oracle.ordim.jai, 11.2.0.4.0... Verifying the update... Applying sub-patch '19769489' to OH '/opt/oracle/app/OracleHomes/db11g' ApplySession: Optional component(s) [ oracle.sysman.agent, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.precomp.common, 11.2.0.4.0... Patching component oracle.ovm, 11.2.0.4.0... Patching component oracle.xdk, 11.2.0.4.0... Patching component oracle.rdbms.util, 11.2.0.4.0... 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.oraolap, 11.2.0.4.0... Patching component oracle.rdbms.rsf, 11.2.0.4.0... Patching component oracle.xdk.rsf, 11.2.0.4.0... 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 19769489 successfully applied. Log file location: /opt/oracle/app/OracleHomes/db11g/cfgtoollogs/opatch/opatch2015-02-21_22-44-57PM_1.log OPatch succeeded.
Load Modified SQL Files into Database
cd $ORACLE_HOME/rdbms/admin sqlplus /nolog CONNECT / AS SYSDBA STARTUP @catbundle.sql psu apply QUIT
No errors were encountered.