2018. 2. 1. 12:41 오라클
패치작업 11.2.0.4.180116
패치작업 11.2.0.4.180116 (GI PSU 27107360)
Database Patch Set Update : 11.2.0.4.180116 (26925576)
OCW Patch Set Update : 11.2.0.4.170814 (26609929)
ACFS PATCH SET UPDATE : 11.2.0.4.160419 (22502505)
Oracle Grid Infrastructure Patch Set Update 11.2.0.4.180116 (Includes Database PSU 11.2.0.4.180116)
-------------------------------------
GRID_HOME, ORACLE_HOME 을 개별로 각각 할때
(root 유저)
$GRID_HOME/crs/install/rootcrs.pl -unlock (CRS 가 떠 있으면 script로 자동으로 내려버림)
(grid 유저)
export GRID_HOME=/oragrid/product/11.2.0.4
cd <UNZIPPED_PATCH_LOCATION>
$GRID_HOME/OPatch/opatch napply -oh $GRID_HOME -local ./27107360/26609929
$GRID_HOME/OPatch/opatch napply -oh $GRID_HOME -local ./27107360/22502505
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./27107360/26925576
(oracle 유저)
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4
cd <UNZIPPED_PATCH_LOCATION>
./27107360/23054319/custom/server/23054319/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME (권한체크)
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local ./27107360/26609929/custom/server/26609929
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./27107360/26925576
./27107360/23054319/custom/server/23054319/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME (권한체크)
(root 유저)
$GRID_HOME/rdbms/install/rootadd_rdbms.sh
$GRID_HOME/crs/install/rootcrs.pl -patch (script로 자동으로 CRS를 올려 버림)
### [롤백하는 경우] ###########
GI Home
(root로)
$GRID_HOME/crs/install/rootcrs.pl -unlock
(grid 유저로)
$GRID_HOME/OPatch/opatch rollback -local -id 26609929 -oh $GRID_HOME
$GRID_HOME/OPatch/opatch rollback -local -id 22502505 -oh $GRID_HOME
$GRID_HOME/OPatch/opatch rollback -local -id 26925576 -oh $GRID_HOME
(oracle 유저로)
cd <UNZIPPED_PATCH_LOCATION>
./27107360/26609929/custom/server/26609929/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME (권한체크)
$ORACLE_HOME/OPatch/opatch rollback -local -id 26609929 -oh /oracle/product/11.2.0.4
$ORACLE_HOME/OPatch/opatch rollback -local -id 26925576 -oh /oracle/product/11.2.0.4
./27107360/26609929/custom/server/26609929/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME (권한체크)
Run post script
(root로)
$GRID_HOME/rdbms/install/rootadd_rdbms.sh
$GRID_HOME/crs/install/rootcrs.pl -patch