Oracle Critical Patch Apply Steps－DanBrother的部落格

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;