Oracle 패치작업 12.2.0.1.190416

====================================================================
2019.5월 7일 작성

패치작업 12.2.0.1.190416 (GI PSU 29301687 )


DB RU    : 12.2.0.1.190416 (29314339)
OCW RU   : 12.2.0.1.190416 (29314424)
ACFS RU  : 12.2.0.1.190416 (29301676)
DBWLM    : 12.2.0.1.170913 (26839277)
TOMCAT   : 12.2.0.1.0      (28566910)


Oracle Grid Infrastructure Patch Set Update 12.2.0.1.190416 (Includes Database PSU 12.2.0.1.190416) 
-------------------------------------
GRID_HOME, ORACLE_HOME 을 개별로 각각 할때

- grid 
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1
$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /29301687/29314339
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /29301687/29314424
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /29301687/29301676
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /29301687/26839277
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /29301687/28566910

- oracle 
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /29301687/29314339
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /29301687/29314424

- oracle 
$/bin/srvctl stop home -o  -s  -n 

(root)
export GRID_HOME=/u01/app/12.2.0.1/grid
$GRID_HOME/crs/install/rootcrs.sh -prepatch 

$GRID_HOME/crs/install/rootcrs.sh -prepatch -nonrolling (롤링으로 하고자 할때)

(grid)
export OPATCH_DEBUG=true

export GRID_HOME=/u01/app/12.2.0.1/grid
cd /home/oracle


$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./29301687/29314424 -silent
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./29301687/29301676 -silent
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./29301687/26839277 -silent
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./29301687/29314339 -silent
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./29301687/28566910 -silent  


(oracle)
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1
cd 

./29301687/29314424/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./29301687/29314424 -silent
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./29301687/29314339 -silent
./29301687/29314424/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME 


(root)
export GRID_HOME=/u01/app/12.2.0.1/grid
$GRID_HOME/rdbms/install/rootadd_rdbms.sh
$GRID_HOME/crs/install/rootcrs.sh -postpatch 

$GRID_HOME/crs/install/rootcrs.sh -postpatch -nonrolling (롤링으로 하고자 할때)

(oracle)
$ /bin/srvctl start home -o  -s  -n 

- Loading Modified SQL Files into the Database

sqlplus /nolog
SQL> conect / as sysdba
SQL> startup
SQL> quit
cd $ORACLE_HOME/OPatch
./datapatch -verbose

-----------------------------

### [롤백하는 경우] ###########

(oracle)
$ /bin/srvctl stop home -o  -s  -n 

(root)
export GRID_HOME=/u01/app/12.2.0.1/grid
$GRID_HOME/crs/install/rootcrs.sh -prepatch -rollback

(grid)
export GRID_HOME=/u01/app/12.2.0.1/grid
$GRID_HOME/OPatch/opatch nrollback -local -id 29314424,29301676,29314339,26839277,28566910 -oh $GRID_HOME


(oracle)
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1
cd 
./29301687 /29314424/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME 
$ORACLE_HOME/OPatch/opatch nrollback -local -id  29314424,29314339 -oh /oracle/product/12.2.0.1/dbhome_1
./29301687 /29314424/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME 

Run post script
(root)
export GRID_HOME=/u01/app/12.2.0.1/grid
$GRID_HOME/rdbms/install/rootadd_rdbms.sh
$GRID_HOME/crs/install/rootcrs.sh -postpatch -rollback

(oracle)
$ /bin/srvctl start home -o  -s  -n 

sqlplus /nolog
SQL> conect / as sysdba
SQL> startup
SQL> quit
cd $ORACLE_HOME/OPatch
./datapatch -verbose