4.1.1.2.9 What is CPU Patch and how do I apply it in a RAC Environment?

Applies to:

Operating System – RHEL/OEL 5.X

Oracle Version(s) – 11.2.0.X

Author:

Carthik Annayan

Problem:

What is CPU patch and how do I apply it?

Solution:

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

http://www.oracle.com/technetwork/topics/security/alerts-086861.html

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.

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.

  1. 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.sql script 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

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