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.its released on January, April, July &October.
Steps to Apply CPU:
Pre-Installation:
- Shutdown all the instance , and oracle services such as listener.
- ensure $PATH variable.
- Download Patchand unzip it.
- Use the Opatch like this : opatch napply -skip_subset -skip_duplicate.
- Startup databas.
Post-Installation :
- cd $ORACLE_HOME/rdbms/admin
- sqlplus / as sysdba
-
SQL> @catbundle.sql cpu apply
Note : For rac database nothing diffrenece unless you have to shutdown services node by node and patching ( you can patch one node then the other one).
Useful MOS notes :
Introduction To Oracle Database catbundle.sql [ID 605795.1]
Thank you
Osama Mustafa
Technology Geek 
Thank you osama i want test this but i dont have Critical Patch Updates where can I find cpu for testing propose?
LikeLike
your welcome , you can install Any CPU patch From http://www.oracle.com/technetwork/topics/security/alerts-086861.htmlChoose Your Patch and also its useful to check and read what this patch fix , And don't forget to be similar as your database version .
LikeLike
Hi Osama, Nice explanation, but i want to know that the pre-installation task you have to across all the nodes or from one node.Regards,Arya
LikeLike
…
LikeLike