2015. 11. 4. 16:12 오라클
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
