패치작업 12.2.0.1.180417 (GI PSU 27468969)

패치작업 12.2.0.1.180417 (GI PSU 27468969)

DB RU    : 12.2.0.1.180116 (27674384)

OCW RU   : 12.2.0.1.180116 (27464465)

ACFS RU  : 12.2.0.1.171115 (27458609)

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>/27468969/27674384

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/27468969/27464465

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/27468969/27458609

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

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

- oracle 유저

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/27468969/27674384

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/27468969/27464465

(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 (2노드 동시에 하고자할 때)

(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 ./27468969/27464465

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./27468969/27458609

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

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./27468969/27674384

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

(oracle 유저)

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1

cd <UNZIPPED_PATCH_LOCATION>

./27468969/27464465/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./27468969/27464465

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

./27468969/27464465/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 (2노드 동시에 하고자 할때)

- Loading Modified SQL Files into the Database

sqlplus /nolog

SQL> conect / as sysdba

SQL> startup

SQL> quit

cd $ORACLE_HOME/OPatch

./datapatch -verbose

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

 

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

GI Home

(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 27464465,27458609,27674384,26839277,27144050 -oh $GRID_HOME

 

(oracle 유저로)

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1

cd <UNZIPPED_PATCH_LOCATION>

./27468969/27464465/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME 

$ORACLE_HOME/OPatch/opatch nrollback -local -id  27464465,27674384 -oh /oracle/product/12.2.0.1

./27468969/27464465/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

sqlplus /nolog

SQL> conect / as sysdba

SQL> startup

SQL> quit

cd $ORACLE_HOME/OPatch

./datapatch -verbose