pat98's always & forever

패치작업 12.2.0.1.220118 (GI PSU 33583921 )

DB RU    : 12.2.0.1.220118 (33587128)
OCW RU   : 12.2.0.1.220118 (33678030)
ACFS RU  : 12.2.0.1.210720 (33116894)
DBWLM    : 12.2.0.1.170913 (26839277)
TOMCAT   : 12.2.0.1.0      (33610989)

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

- grid 
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1
$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/33583921/33587128
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/33583921/33678030
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/33583921/33116894
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/33583921/26839277
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/33583921/33610989

- oracle 
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/33583921/33587128
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/33583921/33678030

- oracle 
$<ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name>

(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 (non 롤링으로 하고자 할때)

(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 ./33583921/33678030 -silent
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./33583921/33116894 -silent
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./33583921/26839277 -silent
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./33583921/33587128 -silent
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./33583921/33610989 -silent  

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

./33583921/33678030/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./33583921/33678030 -silent
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./33583921/33587128 -silent
./33583921/33678030/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 (non 롤링으로 하고자 할때)

(oracle)
$ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location> -n <node name>

- Loading Modified SQL Files into the Database

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