패치작업 12.2.0.1.190115 (GI PSU 28828733 )

패치작업 12.2.0.1.190115 (GI PSU 28828733 )

DB RU    : 12.2.0.1.190115 (28822515)

OCW RU   : 12.2.0.1.190115 (28870605)

ACFS RU  : 12.2.0.1.190115 (28864846)

DBWLM    : 12.2.0.1.170913 (26839277)

TOMCAT   : 12.2.0.1.0      (28566910)

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

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

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>/28828733/28822515

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28828733/28870605

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28828733/28864846

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

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

- oracle 

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28828733/28822515

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28828733/28870605

- 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 ./28828733/28870605 -silent

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./28828733/28864846 -silent

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

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./28828733/28822515 -silent

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./28828733/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>

./28828733/28870605/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./28828733/28870605 -silent

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./28828733/28822515 -silent

./28828733/28870605/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 28870605,28864846,28822515,26839277,28566910 -oh $GRID_HOME

(oracle)

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1

cd <UNZIPPED_PATCH_LOCATION>

./28828733 /28870605/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME 

$ORACLE_HOME/OPatch/opatch nrollback -local -id  28870605,28822515 -oh /oracle/product/12.2.0.1/dbhome_1

./28828733 /28870605/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