RAC Patch 작업

패치작업 11.2.0.4.8 (2015.10)

 

BUG 21523375- GRID INFRASTRUCTURE SYSTEM PATCH 11.2.0.4.8 contains

 

BUG 21352635  -DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOct2015)
BUG 21352649 - OCW PATCH SET UPDATE 11.2.0.4.8
BUG 21352642 - ACFS PATCH SET UPDATE 11.2.0.4.8

 

DB Patch Number : 21352635
OCW PATCH       : 21352649
ACFS PATCH      : 21352642

Oracle Grid Infrastructure Patch Set Update 11.2.0.4.8 (Includes Database PSU 11.2.0.4.8)
-------------------------------------

GRID_HOME, ORACLE_HOME 을 개별로 각각 할때

 

작업전 slibclean

(root 유저)
# /oragrid/product/11.2.0.4/crs/install/rootcrs.pl -unlock (CRS 가 떠 있으면 script로 자동으로 내려버림)

(grid 유저)
/oragrid/product/11.2.0.4/OPatch/opatch napply -oh /oragrid/product/11.2.0.4 -local /arch/21523375/21352649
/oragrid/product/11.2.0.4/OPatch/opatch napply -oh /oragrid/product/11.2.0.4 -local /arch/21523375/21352642
/oragrid/product/11.2.0.4/OPatch/opatch apply -oh /oragrid/product/11.2.0.4 -local /arch/21523375/21352635

 

(oracle 유저)
/arch/21523375/20831122/custom/server/20831122/custom/scripts/prepatch.sh -dbhome /oracle/product/11.2.0.4 (권한체크)
/oracle/product/11.2.0.4/OPatch/opatch napply -oh /oracle/product/11.2.0.4 -local /arch/21523375/21352649/custom/server/21352649
/oracle/product/11.2.0.4/OPatch/opatch apply -oh /oracle/product/11.2.0.4 -local /arch/21523375/21352635
/arch/21523375/20831122/custom/server/20831122/custom/scripts/postpatch.sh -dbhome /oracle/product/11.2.0.4 (권한체크)

 

(root 유저)
# /oragrid/product/11.2.0.4/rdbms/install/rootadd_rdbms.sh
# /oragrid/product/11.2.0.4/crs/install/rootcrs.pl -patch (script로 자동으로 CRS를 올려 버림)

[롤백하는 경우]

GI Home
(root로)
# /oragrid/product/11.2.0.4/crs/install/rootcrs.pl -unlock

 

(grid 유저로)
/oragrid/product/11.2.0.4/OPatch/opatch rollback -local -id 21352649 -oh /oragrid/product/11.2.0.4
/oragrid/product/11.2.0.4/OPatch/opatch rollback -local -id 21352642 -oh /oragrid/product/11.2.0.4 
/oragrid/product/11.2.0.4/OPatch/opatch rollback -local -id 21352635  -oh /oragrid/product/11.2.0.4

 

(oracle 유저로)
/arch/21523375/20831122/custom/server/20831122/custom/scripts/prepatch.sh -dbhome /oracle/product/11.2.0.4
/oracle/product/11.2.0.4/OPatch/opatch rollback -local -id 21352649 -oh /oracle/product/11.2.0.4
/oracle/product/11.2.0.4/OPatch/opatch rollback -local -id 21352635  -oh /oracle/product/11.2.0.4
/arch/21523375/20831122/custom/server/20831122/custom/scripts/postpatch.sh -dbhome /oracle/product/11.2.0.4

 

Run post script
(root로)
# /oragrid/product/11.2.0.4/rdbms/install/rootadd_rdbms.sh
# /oragrid/product/11.2.0.4/crs/install/rootcrs.pl -patch

 

사후작업

 

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT