Oracle 패치작업 12.2.0.1.190716

2019.8월 1일 작성

패치작업 12.2.0.1.190716 (GI PSU 29708720 )

DB RU    : 12.2.0.1.190716 (29757449)

OCW RU   : 12.2.0.1.190716 (29770040)

ACFS RU  : 12.2.0.1.190716 (29770090)

DBWLM    : 12.2.0.1.170913 (26839277)

TOMCAT   : 12.2.0.1.0      (28566910)

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

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

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>/29708720/29757449

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/29708720/29770040

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/29708720/29770090

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

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

- oracle 

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/29708720/29757449

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/29708720/29770040

- 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 ./29708720/29770040 -silent

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./29708720/29770090 -silent

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

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./29708720/29757449 -silent

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

./29708720/29770040/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./29708720/29770040 -silent

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./29708720/29757449 -silent

./29708720/29770040/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 29770040,29770090,29757449,26839277,28566910 -oh $GRID_HOME

(oracle)

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1

cd <UNZIPPED_PATCH_LOCATION>

./29708720 /29770040/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME 

$ORACLE_HOME/OPatch/opatch nrollback -local -id  29770040,29757449 -oh /oracle/product/12.2.0.1/dbhome_1

./29708720 /29770040/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