패치작업 12.2.0.1.181016 (GI PSU 28714316 )

패치작업 12.2.0.1.181016 (GI PSU 28714316 )

DB RU    : 12.2.0.1.181016 (28662603)

OCW RU   : 12.2.0.1.181016 (28662626)

ACFS RU  : 12.2.0.1.181016 (28662640)

DBWLM    : 12.2.0.1.170913 (26839277)

TOMCAT   : 12.2.0.1.0      (28566910)

Oracle Grid Infrastructure Patch Set Update 12.2.0.1.181016 (Includes Database PSU 12.2.0.1.181016) 

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

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>/28714316/28662603

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28714316/28662626

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28714316/28662640

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28714316/26839277

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28714316/28566910

- oracle 

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28714316/28662603

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28714316/28662626

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

(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 ./28714316/28662626 -silent

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./28714316/28662640 -silent

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./28714316/26839277 -silent

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./28714316/28662603 -silent

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./28714316/28566910 -silent  

(oracle)

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1

cd <UNZIPPED_PATCH_LOCATION>

./28714316/28662626/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./28714316/28662626

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./28714316/28662603

./28714316/28662626/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)

$ <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>

(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 28662626,28662640,28662603,26839277,28566910 -oh $GRID_HOME

(oracle)

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1

cd <UNZIPPED_PATCH_LOCATION>

./28714316 /28662626/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME 

$ORACLE_HOME/OPatch/opatch nrollback -local -id  28662626,28662603 -oh /oracle/product/12.2.0.1/dbhome_1

./28714316 /28662626/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)

$ <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