Steps to apply CPUJan2014 patch

Here are the steps to apply CPUJan2014(17478415) patch

1) Set Environment
export PATH=$PATH:/usr/ccs/bin
export PATH=$PATH:/data/oracle/db/tech_st/11.2.0/OPatch
which opatch
/data/oracle/db/tech_st/11.2.0/OPatch

2) Download the CPU patch.Eg.,Download CPUJan2014 patch for 11.2.0.3

3) To apply CPUJan2014, OPatch utility version 11.2.0.1.0 or later to apply this patch. Oracle recommends that you use
the latest released OPatch 11.2, which is available for download from My Oracle Support patch 6880880 by selecting the 11.2.0.0.0 release

4) Shutdown the Application and Database

5) Backup the Database,Oracle Home,Inventory

6) Check Confliction
bash-3.2$ cd 17478415
bash-3.2$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./

7) Apply opatch
unzip p17478415_112030_<platform>.zip
cd 17478415
opatch napply -skip_subset -skip_duplicate

6) Post Installation
Loading Modified SQL Files into the Database
conn "/ as sysdba"
@?/rdbms/admin/catbundle.sql cpu apply

The catbundle.sql execution is reflected in the dba_registry_history view by a row associated with bundle series CPU.

8) Check the status from registry$history
select action,version,id,comments,bundle_series from registry$history where bundle_series like '%CPU%';

9) Compile Invalid objects by executing “utlrp.sql”

10) Check the following log files in $ORACLE_BASE/cfgtoollogs/catbundle for any errors:
catbundle_CPU_<database SID>_APPLY_<TIMESTAMP>.log
catbundle_CPU_<database SID>_GENERATE_<TIMESTAMP>.log