Tuesday, 5 June 2012

Applying CPU patch in RAC


What is CPU patch?

A Critical Patch Update is a collection of patches for multiple security vulnerabilities. Critical Patch Update patches are usually cumulative but each advisory describes only the security fixes added since the previous Critical Patch Update advisory. Thus, prior Critical Patch Update advisories should be reviewed for information regarding earlier published security fixes.

When is CPU Patches Released?

CPU patches is released 4 times a year.
January, April, July &October.
Information about the latest CPU Patch can be found in the below link
Note: To download the latest CPU patch, one must have a valid oracle support login.

How to apply a Database CPU patch in a RAC Environment?

1) Shutdown the Database instance on Node 1
2) Ensure that the $PATH has the following executables: makearld, and nm.
    export PATH=$PATH:/usr/bin & Also Make sure that your ORACLE_HOME etc is set.
3) Set your current directory to the directory where the patch is located and then run the OPatch               
     utility by entering the following commands:
4) unzip p13466801_112030_<platform>.zip
5) cd 13466801
6) opatch napply -skip_subset -skip_duplicate
7) Startup the instance using Srvctl commands
 Repeat the above all steps in all the Nodes.

Patch Post-Installation Instructions

After installing the patch, load modified SQL files into the database
Loading Modified SQL Files into the Database
The following steps load modified SQL files into the database. For a RAC environment, perform these steps on only one node.
  1. 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:
2.      cd $ORACLE_HOME/rdbms/admin
3.      sqlplus /nolog
4.      SQL> CONNECT / AS SYSDBA
5.      SQL> STARTUP
6.      SQL> @catbundle.sql cpu apply
7.      SQL> QUIT
The catbundle.sql execution is reflected in the dba_registry_history view by a row associated with bundle series CPU.
Note: CPU patches are meant to be applied only for the Database Home& Not the Grid Infrastructure Home

No comments:

Post a Comment