close

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;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 DanBrother 的頭像
    DanBrother

    DanBrother的部落格

    DanBrother 發表在 痞客邦 留言(0) 人氣()