15 Apply PSU 11.2.0.4.3 to REPOS
Overview
I patched REPOS to 11.2.0.4.3.
References
Procedure
Download PSU
Downloaded patch 18522509 for Linux-x86 to /opt/oracle/software.
cd /opt/oracle/software unzip -qo p18522509_112040_LINUX.zip
Verify OPatch Version
Use the following command to check the version of opatch:
opatch version
The output is:
OPatch Version: 11.2.0.3.6 OPatch succeeded.
This is the minimum version required, so there is no need to upgrade opatch.
Environment Checks
which make ar id nm
All of the required programs were found:
/usr/bin/make /usr/bin/ar /usr/bin/id /usr/bin/nm
Check for Patch Conflicts
In order to check for possible conflicts with existing patches, I ran the following commands:
cd /opt/oracle/software/18522509 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-07-26_19-02-33PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.
The good news is that there is no conflicts.
Stop Listener
The Database Listener is stopped as follows:
lsnrctl stop
The output is as follows:
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 26-JUL-2014 19:04:40 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) The command completed successfully
Stop Database Instance
Used SQL*Plus to stop the database instance as follows:
sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sat Jul 26 19:04:57 2014 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
Apply the PSU
Used the following commands to apply the PSU:
cd /opt/oracle/software/18522509 opatch apply
The output is as follows:
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/opatch2014-07-26_19-06-22PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 18522509 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 '18522509' to OH '/opt/oracle/app/OracleHomes/db11g' Patching component oracle.rdbms.rsf, 11.2.0.4.0... Patching component oracle.rdbms, 11.2.0.4.0... Patching component oracle.precomp.common, 11.2.0.4.0... Patching component oracle.rdbms.rman, 11.2.0.4.0... Patching component oracle.rdbms.dbscripts, 11.2.0.4.0... Patching component oracle.rdbms.deconfig, 11.2.0.4.0... Verifying the update... Composite patch 18522509 successfully applied. Log file location: /opt/oracle/app/OracleHomes/db11g/cfgtoollogs/opatch/opatch2014-07-26_19-06-22PM_1.log OPatch succeeded.
Startup Database Instance and Perform the Post-Patch Activity
The database instance is started up as follows, and applied the post-patch script:
[oracle@gridctrl 18522509]$ cd ${ORACLE_HOME}/rdbms/admin [oracle@gridctrl admin]$ sqlplus /nolog SQL*Plus: Release 11.2.0.4.0 Production on Sat Jul 26 19:10:17 2014 Copyright (c) 1982, 2013, Oracle. All rights reserved. SQL> CONNECT / AS SYSDBA Connected to an idle instance. SQL> STARTUP ORACLE instance started. Total System Global Area 2142679040 bytes Fixed Size 1365828 bytes Variable Size 805308604 bytes Database Buffers 1325400064 bytes Redo Buffers 10604544 bytes Database mounted. Database opened. SQL> @catbundle.sql psu apply
The output is stored in the following files:
/opt/oracle/app/cfgtoollogs/catbundle/catbundle_PSU_REPOS_GENERATE_2014Jul26_19_11_57.log/opt/oracle/app/cfgtoollogs/catbundle/catbundle_PSU_REPOS_APPLY_2014Jul26_19_12_02.log