Friday, January 11, 2013

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 :


 Thank you 
Osama Mustafa

2 comments:

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

    ReplyDelete
    Replies
    1. your welcome , you can install Any CPU patch From
      http://www.oracle.com/technetwork/topics/security/alerts-086861.html

      Choose 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 .

      Delete