✦

Technology Geek

18+ YEARS AMONG THE CLOUDS

✦ TRANSMISSION

Applying Critical Patch Updates (CPU).

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:

  1. Shutdown all the instance , and oracle services such as listener. 
  2. ensure $PATH variable.
  3. Download Patchand unzip it.
  4. Use the Opatch like this : opatch napply -skip_subset -skip_duplicate.
  5. Startup databas.

Post-Installation :

  1.  cd $ORACLE_HOME/rdbms/admin
  2. sqlplus / as sysdba
  3. 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

4 responses to “Applying Critical Patch Updates (CPU).”

  1. MESLI Abdelhadi

    Thank you osama i want test this but i dont have Critical Patch Updates where can I find cpu for testing propose?

    Like

    Reply
  2. Osama Mustafa

    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 .

    Like

    Reply
  3. Anonymous

    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

    Like

    Reply
  4. Anonymous

    …

    Like

    Reply

Leave a comment

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