2020. 11. 19. 16:51 오라클
패치작업 19.9.0.0.201020 (GI PSU 31750108)
===========================================================================
패치작업 19.9.0.0.201020 (GI PSU 31750108)
OCW Patch Set Update : 19.9.0.0.201020 (31772784)
ACFS Patch Set Update : 19.9.0.0.201020 (31773437)
Database Patch Set Update : 19.9.0.0.201020 (31771877)
Tomcat Release Update : 19.0.0.0.0 (31780966)
Oracle Grid Infrastructure Patch Set Update 19.9.0.0.201020
-------------------------------------
GRID_HOME, ORACLE_HOME 을 개별로 각각 할때
- grid 유저
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31750108/31772784
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31750108/31773437
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31750108/31771877
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31750108/31780966
- oracle 유저
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31750108/31772784
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31750108/31771877
(oracle)
$ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name>
(root 유저)
export GRID_HOME=/u01/app/19.3.0.0/grid
$GRID_HOME/crs/install/rootcrs.sh -prepatch -nonrolling
(grid 유저)
export GRID_HOME=/u01/grid/19.3.0.0
cd <UNZIPPED_PATCH_LOCATION>
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./31750108/31772784
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./31750108/31773437
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./31750108/31771877
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./31750108/31780966
(oracle 유저)
export ORACLE_HOME=$ORACLE_BASE/product/19.3.0.0
cd <UNZIPPED_PATCH_LOCATION>
./31750108/31772784/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./31750108/31772784
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./31750108/31771877
./31750108/31772784/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
(root 유저)
export GRID_HOME=/u01/grid/19.3.0.0
$GRID_HOME/rdbms/install/rootadd_rdbms.sh
$GRID_HOME/crs/install/rootcrs.sh -postpatch
(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>
GI Home
(root로)
$GRID_HOME/crs/install/rootcrs.sh -prepatch -rollback
(grid 유저로)
$GRID_HOME/OPatch/opatch nrollback -local -id 31772784,31773437,31771877,31780966 -oh $GRID_HOME
(oracle 유저로)
cd <UNZIPPED_PATCH_LOCATION>
./31750108/31772784/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME (권한체크)
$ORACLE_HOME/OPatch/opatch nrollback -local -id 31772784,31771877 -oh /oracle/product/19.3.0.0
./31750108/31772784/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME (권한체크)
Run post script
(root로)
$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
===========================================================================
===========================================================================
패치작업 19.8.0.0.200714 (GI PSU 31305339)
OCW Patch Set Update : 19.8.0.0.200714 (31305087)
ACFS Patch Set Update : 19.8.0.0.200714 (31304218)
Database Patch Set Update : 19.8.0.0.200714 (31281355)
Tomcat Release Update : 19.0.0.0.0 (31335188)
Oracle Grid Infrastructure Patch Set Update 19.8.0.0.200714
-------------------------------------
GRID_HOME, ORACLE_HOME 을 개별로 각각 할때
- grid 유저
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31305339/31305087
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31305339/31304218
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31305339/31281355
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31305339/31335188
- oracle 유저
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31305339/31305087
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31305339/31281355
(oracle)
$ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name>
(root 유저)
export GRID_HOME=/u01/app/19.3.0.0/grid
$GRID_HOME/crs/install/rootcrs.sh -prepatch -nonrolling
(grid 유저)
export GRID_HOME=/u01/grid/19.3.0.0
cd <UNZIPPED_PATCH_LOCATION>
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./31305339/31305087
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./31305339/31304218
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./31305339/31281355
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./31305339/31335188
(oracle 유저)
export ORACLE_HOME=$ORACLE_BASE/product/19.3.0.0
cd <UNZIPPED_PATCH_LOCATION>
./31305339/31305087/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./31305339/31305087
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./31305339/31281355
./31305339/31305087/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
(root 유저)
export GRID_HOME=/u01/grid/19.3.0.0
$GRID_HOME/rdbms/install/rootadd_rdbms.sh
$GRID_HOME/crs/install/rootcrs.sh -postpatch
(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>
GI Home
(root로)
$GRID_HOME/crs/install/rootcrs.sh -prepatch -rollback
(grid 유저로)
$GRID_HOME/OPatch/opatch nrollback -local -id 31305087,31304218,31281355,31335188 -oh $GRID_HOME
(oracle 유저로)
cd <UNZIPPED_PATCH_LOCATION>
./31305339/31305087/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME (권한체크)
$ORACLE_HOME/OPatch/opatch nrollback -local -id 31305087,31281355 -oh /oracle/product/19.3.0.0
./31305339/31305087/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME (권한체크)
Run post script
(root로)
$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
===========================================================================
