Applying PSU to Grid Infrastructure and DB Home

Applying PSU is pretty simple and straighforward task. I am documenting this as easy reference for people looking for steps. These steps have been tried on Base software on RHEL5.6 on Linux x86-64.

1) We must use OPatch utility version or later to apply this patch. For my base install, opatch version is

[oracle@devdb-005]~% $ORACLE_HOME/OPatch/opatch version
Invoking OPatch

OPatch Version:

OPatch succeeded.

So we need to first download patch 6880880

I used following wget command to directly download the patch to my server.

read username
read -s h_passwd
wget --http-user="$username" --http-password="$h_passwd" --output-document="" ""

The new opatch utility should be updated in all the Oracle RAC database homes and the GI home that are being patched.
unzip the patch and then copy to both nodes

[oracle@devdb-005]/oracle/product/ mv OPatch OPatch.old
[oracle@devdb-005]/oracle/product/ cp -pr /home/oracle/OPatch .

Similarly for Grid home but this time as root

[root@devdb-005 ~]# cd /oragrid/
[root@devdb-005 grid]# mv OPatch/ OPatch.old
[root@devdb-005 grid]# cp -pr /home/oracle/OPatch .

Repeat for other nodes in cluster. Since this is 2 node RAC, I repeated steps on devdb-006.

Verify Opatch version

[oracle@devdb-005]~% $ORACLE_HOME/OPatch/opatch version    
OPatch Version:

OPatch succeeded.

[oracle@devdb-005]~% $ORACLE_GRID/OPatch/opatch version
OPatch Version:

OPatch succeeded.

2)Opatch requires ocm.rsp file. Note 966023.1 describes How To Create An OCM Response File For Opatch Silent Installation
Let’s create one for our setup in current directory. I didn’t specify my MOS credentials

[oracle@devdb-005]~% $ORACLE_HOME/OPatch/ocm/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 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) Oracle recommends to run following command to verify consistency of all homes being patched.

$ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME

In case there is some issue with inventory , it will report error. In that case you should first fix the error before proceeding with patching.
This will also give the list of currently applied patches.

4)In case you have configured DB Console for RAC, it should be stopped before patching

As the Oracle RAC database home owner execute:

$ $ORACLE_HOME/bin/emctl stop dbconsole


read username
read -s h_passwd
wget --http-user="$username" --http-password="$h_passwd" --output-document="" ""

6) Finally we come to patching step. If you are not using shared homes and ACFS, then patching is straight forward i.e use opatch auto. In case you are using ACFS or Shared home, then refer to patch readme here
You need to run this command as root from one node at a time

#/oragrid/ auto /home/oracle/psupatch/ -ocmrf /home/oracle/ocm.rsp

This will shutdown instance followed by Clusterware shutdown. Finally it will patch both Grid home and database. You would see following output in end

patch /home/oracle/psupatch/15876003 apply successful for home /oragrid/
patch /home/oracle/psupatch/14727310 apply failed for home /oragrid/
CRS-4123: Oracle High Availability Services has been started.

7)Run catbundle.sql from each database running from DB home. In RAC this needs to be done only one node

@catbundle.sql psu apply

Check the following log files in $ORACLE_BASE/cfgtoollogs/catbundle for any errors:

catbundle_PSU_<database SID>_APPLY_<TIMESTAMP>.log
catbundle_PSU_<database SID>_GENERATE_<TIMESTAMP>.log

As you can see patching process is simplified as compared to 10.2 patch bundles when you needed to execute some scripts as root and then as oracle .

3 thoughts on “Applying PSU to Grid Infrastructure and DB Home”

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.