12.2.0.1.180116 (GI PSU 27100009) 패치

패치작업 12.2.0.1.180116 (GI PSU  27100009)

DB RU    : 12.2.0.1.1801161 (27105253)

OCW RU   : 12.2.0.1.180116 (27335416)

ACFS RU  : 12.2.0.1.171115 (27128906)

DBWLM    : 12.2.0.1.170913 (26839277)

TOMCAT   : 12.2.0.1.170723 (27144050)

Oracle Grid Infrastructure Patch Set Update 12.2.0.1.1711121 (Includes Database PSU 12.2.0.1.171121) 

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

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>/27100009/27105253

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/27100009/27335416

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/27100009/27128906

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

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

- oracle 유저

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/27100009/27105253

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/27100009/27335416

(root 유저)

export GRID_HOME=/u01/app/12.2.0.1/grid

$GRID_HOME/crs/install/rootcrs.sh -prepatch 

(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 ./27100009/27335416

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./27100009/27128906

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

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./27100009/27105253

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./27100009/27144050  (TOMCAT 패치 같이 할경우)

(oracle 유저)

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1

cd <UNZIPPED_PATCH_LOCATION>

./27100009/27335416/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./27100009/27335416

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./27100009/27105253

./27100009/27335416/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 

- Loading Modified SQL Files into the Database

sqlplus /nolog

SQL> conect / as sysdba

SQL> startup

SQL> quit

cd $ORACLE_HOME/OPatch

./datapatch -verbose

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

TOMCAT patch 따로 할 경우

- oracle

export GRID_HOME=/u01/app/12.2.0.1/grid

unzip p27144050_12201_GENERIC.zip 

srvctl disable qosmserver

srvctl stop qosmserver

srvctl disable rhpserver

srvctl stop rhpserver

srvctl disable rhpclient 

srvctl stop rhpclient 

- root

export GRID_HOME=/u01/app/12.2.0.1/grid

$GRID_HOME/crs/install/rootcrs.pl -unlock 

- oracle

export GRID_HOME=/u01/app/12.2.0.1/grid

cd /u01/install/

opatch napply -local ./27100009/27144050 -oh $GRID_HOME -id 27144050 

- root

export GRID_HOME=/u01/app/12.2.0.1/grid

$GRID_HOME/crs/install/rootcrs.pl -patch 

(-patch 옵션 없음? -postpatch 로 올려야 함)

- oracle

srvctl enable qosmserver

srvctl start qosmserver

srvctl enable rhpserver

srvctl start rhpserver

srvctl enable rhpclient

srvctl start rhpclient

opatch lsinventory -detail -oh $GRID_HOME

opatch rollback -id 27144050 -local -oh $GRID_HOME

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

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 27335416,27128906,27105253,26839277,27144050 -oh $GRID_HOME

(oracle 유저로)

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1

cd <UNZIPPED_PATCH_LOCATION>

./27100009/27335416/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME 

$ORACLE_HOME/OPatch/opatch nrollback -local -id  27335416,27105253 -oh /oracle/product/12.2.0.1

./27100009/27335416/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