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
$PATHhas the following executables:
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 p
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.
- 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.sqlscript 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
catbundle.sqlexecution is reflected in the dba_registry_history view by a row associated with bundle series
Note: CPU patches are meant to be applied only for the Database Home& Not the Grid Infrastructure Home