2018. 5. 18. 15:19 오라클
패치작업 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
