Oracle Critical Patch Apply Steps (RAC DB on Linux):
1. (logon as oracle user)
# crsctl stop instance -d TESTDB1 -i TESTDB11 -o 'TRANSACTIONAL LOCAL'
# crsctl stop instance -d TESTDB2 -i TESTDB21 -o 'TRANSACTIONAL LOCAL'
2.
# unzip p13466801_112030_Linux-x86-64 .zip
# cd /Critical_Patch/p13466801/13466801
# $ORACLE_HOME/Opatch/opatch napply -skip_subset -skip_duplicate
ps. N-apply CPUs are cumulative patches
3.
# crsctl start instance -d TESTDB1 -i TESTDB11
# crsctl start instance -d TESTDB2 -i TESTDB21
4.
# for each database, apply the following SQL script:
# sqlplus / as sysdba
SQL> @?/rdbms/admin/catbundle.sql cpu apply
5.
SQL> select * from registry$history;
ps. $CRS_HOME needs not be applied
Oracle Critical Patch Apply Steps (Single DB on Windows):
1. shutdown listener & the Oracle database
2. rename oracle.opatch.classpath.jar to oracle.opatch.classpath.jar_
3. set ORACLE_HOME=C:\app\oracle\product\11.2.3\dbhome_1
4. cd C:\download\p14613223_112030_MSWIN-x86-64\14613223
%ORACLE_HOME%\Opatch\opatch apply
5. rename oracle.opatch.classpath.jar_ back to oracle.opatch.classpath.jar
6. start listener & the Oracle database
cd %ORACLE_HOME%\Bundle\patch11
sqlplus /nolog
CONNECT /@testdb as sysdba
SQL> @catwinbundle.sql
SQL> @?/rdbms/admin/utlrp
7.
set linesize 120
col action_time format a32
col action format a16
col namespace format a10
col version format a10
col comments format a24
col bundle_series format a10
select * from dba_registry_history order by 1;