2025. 7. 16. 09:14 오라클
패치작업 19.28.0.0.250715 (GI RU 37957391 )
Critical Patch Update (CPU) Program Jul 2025 Patch Availability Document (DB-only) (Doc ID 3086459.1)
패치작업 19.28.0.0.250715 (GI RU 37957391 )
Database Patch Set Update : 19.28.0.0.250715 (37960098)
OCW Patch Set Update : 19.28.0.0.250715 (37962946)
ACFS Patch Set Update : 19.28.0.0.250715 (37962938)
Tomcat Release Update : 19.0.0.0.0 (38124772)
DBWLM Release Update : 19.0.0.0.0 (36758186)
Oracle Grid Infrastructure Patch Set Update 19.28.0.0.250715
-------------------------------------
GI_HOME, ORACLE_HOME 을 개별로 각각 할때
- grid 유저
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/37957391/37960098
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/37957391/37962946
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/37957391/37962938
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/37957391/36758186
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/37957391/38124772
- oracle 유저
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/37957391/37960098
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/37957391/37962946
(oracle)
$ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name>
(root 유저)
export GI_HOME=/u01/app/19.0.0.0/grid
$GI_HOME/crs/install/rootcrs.sh -prepatch
(grid 유저)
export GI_HOME=/u01/app/19.0.0.0/grid
cd /u01/patch
$GI_HOME/OPatch/opatch apply -oh $GI_HOME -local /u01/patch/37957391/37962946 -silent
$GI_HOME/OPatch/opatch apply -oh $GI_HOME -local /u01/patch/37957391/37962938 -silent
$GI_HOME/OPatch/opatch apply -oh $GI_HOME -local /u01/patch/37957391/37960098 -silent
$GI_HOME/OPatch/opatch apply -oh $GI_HOME -local /u01/patch/37957391/36758186 -silent
$GI_HOME/OPatch/opatch apply -oh $GI_HOME -local /u01/patch/37957391/38124772 -silent
(oracle 유저)
export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1
cd /u01/patch
./37957391/37962946/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /u01/patch/37957391/37962946 -silent
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /u01/patch/37957391/37960098 -silent
./37957391/37962946/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
(root 유저)
export GI_HOME=/u01/app/19.0.0.0/grid
$GI_HOME/rdbms/install/rootadd_rdbms.sh
$GI_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로)
$GI_HOME/crs/install/rootcrs.sh -prepatch -rollback
(grid 유저로)
export GI_HOME=/u01/app/19.0.0.0/grid
cd /u01/install
$GI_HOME/OPatch/opatch nrollback -local -id 37962946,37962938,37960098,36758186,38124772 -oh $GI_HOME -silent
(oracle 유저로)
export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1
cd /u01/install
./37957391 /37962946/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch nrollback -local -id 37962946,37960098 -oh /u01/app/oracle/product/19.0.0.0/dbhome_1 -silent
./37957391 /37962946/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
Run post script
(root로)
export GI_HOME=/u01/app/19.0.0.0/grid
$GI_HOME/rdbms/install/rootadd_rdbms.sh
$GI_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
