패치작업 12.2.0.1.180717 (GI PSU 28183653)

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

패치작업 12.2.0.1.180717 (GI PSU 28183653)

 

 

DB RU    : 12.2.0.1.180717 (28163133)

OCW RU   : 12.2.0.1.180717 (28163190)

ACFS RU  : 12.2.0.1.180717 (28163235)

DBWLM    : 12.2.0.1.170913 (26839277)

TOMCAT   : 12.2.0.1.170723 (27144050)

 

 

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

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

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>/28183653/28163133

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28183653/28163190

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28183653/28163235

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

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28183653/27144050

 

- oracle 

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28183653/28163133

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28183653/28163190

 

- 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 GRID_HOME=/u01/app/12.2.0.1/grid

cd /u01/install

 

export OPATCH_DEBUG=true

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./28183653/28163190

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./28183653/28163235

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./28183653/26839277

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./28183653/28163133

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./28183653/27144050  

 

 

(oracle)

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1

cd <UNZIPPED_PATCH_LOCATION>

 

./28183653/28163190/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./28183653/28163190

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./28183653/28163133 (오래걸림)

./28183653/28163190/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 28163190,28163235,28163133,26839277,27144050 -oh $GRID_HOME

 

 

(oracle)

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1

cd <UNZIPPED_PATCH_LOCATION>

./28183653/28163190/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME 

$ORACLE_HOME/OPatch/opatch nrollback -local -id  28163190,28163133 -oh /oracle/product/12.2.0.1

./28183653/28163190/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