Applying PSU 11.2.0.4.4 to Grid Infrastructure and DB Home

Applying PSU 11.2.0.4.4 is a pretty simple task. This article explain the steps on how to patch Oracle 11g r2 RAC  installation. 

Please note, the GI PSU patch includes updates for both the Clusterware home and Database home that can be applied in a rolling fashion.

OS Version: CentOS release 6.6 (Final)

DB Version: 11.2.0.4.0 - 64bit

1. Download and install the latest version of OPatch utility in all the Oracle RAC database homes and the GI homes on all nodes that are being patched. Patch # 6880880.

unzip p6880880_112000_Linux-x86-64.zip cp -pr OPatch $ORACLE_HOME/

2. Create OCM response file. See My Oracle Support Document 966023.1

cd $ORACLE_HOME/OPatch/ocm/bin/ [oracle@rac1 bin]$ ./emocmrsp   -no_banner 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 The OCM configuration response file (ocm.rsp) was successfully created.

3. Stop EM Agent Processes Prior to Patching and Prior to Rolling Back the Patch.

# As the Oracle RAC database home owner execute: $ $ORACLE_HOME/bin/emctl stop dbconsole

4. Stop database instance before patching each node. Opatch will automatically re-start it.

# For example, when patching node 1, stop db instance 1: srvctl stop instance -d bkisdb -i bkisdb1

5. Apply patch 19380115 - GI Home and the Database Homes that are not shared and ACFS file system is not configured.

# Run this command as root from one node at a time: /oragrid/11.2.0.4/grid/OPatch/opatch auto /home/oracle/19380115 -ocmrf /home/oracle/ocm.rsp

6. Run catbundle.sql for each database running from DB home only once from one node only.

For each database instance running on the Oracle home being patched, connect to the database using SQL*Plus. Connect as SYSDBA and run the catbundle.sql script as follows: cd $ORACLE_HOME/rdbms/admin sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> STARTUP SQL> @catbundle.sql psu apply SQL> QUIT

I hope this helps.

Please feel free to leave your questions or suggest improvements to this section.