Oracle 패치작업 11.2.0.4.190416

=====================================================

2019.5.7일 작성

패치작업 11.2.0.4.190416 (GI PSU 29255947)

Database Patch Set Update : 11.2.0.4.190416 (29141056)
OCW Patch Set Update      : 11.2.0.4.190416 (29141201)
ACFS PATCH SET UPDATE     : 11.2.0.4.190115 (28729245)


Oracle Grid Infrastructure Patch Set Update 11.2.0.4.190416 (Includes Database PSU 11.2.0.4.190416) 
-------------------------------------
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 

$GRID_HOME/OPatch/opatch napply -oh $GRID_HOME -local ./29255947/29141201
$GRID_HOME/OPatch/opatch napply -oh $GRID_HOME -local ./29255947/28729245
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local  ./29255947/29141056

(oracle 유저)

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4
cd 

./29255947/23054319/custom/server/23054319/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME (권한체크)
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local ./29255947/29141201/custom/server/29141201
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./29255947/29141056
./29255947/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 29141201 -oh $GRID_HOME
$GRID_HOME/OPatch/opatch rollback -local -id 28729245 -oh $GRID_HOME
$GRID_HOME/OPatch/opatch rollback -local -id 29141056 -oh $GRID_HOME

(oracle 유저로)

cd 
./29255947/29141201/custom/server/29141201/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME (권한체크)
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local ./29255947/29141201/custom/server/29141201
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./29255947/29141056
./29255947/29141201/custom/server/29141201/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