220.127.116.11.9 What is CPU Patch and how do I apply it in a RAC Environment?
Operating System – RHEL/OEL 5.X
Oracle Version(s) – 11.2.0.X
What is CPU patch and how do I apply it?
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: make, ar, ld, and nm.
export PATH=$PATH:/usr/bin & Also Make sure that your ORACLE_HOME etc is set.
2a) Set your current directory to the directory where the patch is located and then run the OPatch utility by entering the following commands:
2b) unzip p13466801_112030_<platform>.zip
2c) cd 13466801
2d) opatch napply -skip_subset -skip_duplicate
3} Startup the instance using Srvctl commands
Repeat the above 3 steps in all the Nodes.
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.
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