패치작업 19.8.0.0.200714 (GI PSU 31305339)

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

패치작업 19.8.0.0.200714 (GI PSU 31305339)

OCW Patch Set Update      : 19.8.0.0.200714 (31305087)

ACFS Patch Set Update      : 19.8.0.0.200714 (31304218)

Database Patch Set Update : 19.8.0.0.200714 (31281355)

Tomcat Release Update     :  19.0.0.0.0     (31335188)

Oracle Grid Infrastructure Patch Set Update 19.8.0.0.200714 

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

GRID_HOME, ORACLE_HOME 을 개별로 각각 할때

- grid 유저

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31305339/31305087

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31305339/31304218

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31305339/31281355

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31305339/31335188

- oracle 유저

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31305339/31305087

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31305339/31281355

(oracle)

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

(root 유저)

export GRID_HOME=/u01/app/19.3.0.0/grid

$GRID_HOME/crs/install/rootcrs.sh -prepatch -nonrolling

(grid 유저)

export GRID_HOME=/u01/grid/19.3.0.0

cd <UNZIPPED_PATCH_LOCATION>

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./31305339/31305087

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./31305339/31304218

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./31305339/31281355

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./31305339/31335188

(oracle 유저)

export ORACLE_HOME=$ORACLE_BASE/product/19.3.0.0

cd <UNZIPPED_PATCH_LOCATION>

./31305339/31305087/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./31305339/31305087

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./31305339/31281355

./31305339/31305087/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME 

(root 유저)

export GRID_HOME=/u01/grid/19.3.0.0

$GRID_HOME/rdbms/install/rootadd_rdbms.sh

$GRID_HOME/crs/install/rootcrs.sh -postpatch

(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

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

(oracle)

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

GI Home

(root로)

$GRID_HOME/crs/install/rootcrs.sh -prepatch -rollback

(grid 유저로)

$GRID_HOME/OPatch/opatch nrollback -local -id 31305087,31304218,31281355,31335188 -oh $GRID_HOME

(oracle 유저로)

cd <UNZIPPED_PATCH_LOCATION>

./31305339/31305087/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME (권한체크)

$ORACLE_HOME/OPatch/opatch nrollback -local -id  31305087,31281355 -oh /oracle/product/19.3.0.0

./31305339/31305087/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME (권한체크)

Run post script

(root로)

$GRID_HOME/rdbms/install/rootadd_rdbms.sh

$GRID_HOME/crs/install/rootcrs.sh -postpatch -rollback

(oracle)

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

sqlplus /nolog

SQL> conect / as sysdba

SQL> startup

SQL> quit

cd $ORACLE_HOME/OPatch

./datapatch -verbose

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