19c
Applying Oracle 19c30 Grid Infrastructure Patch
First obtain the 19c30 Grid, Database and OJVM patches
- Grid Infrastructure patch – 38629535
- Database patch – 38632161
- OJVM patch – 38523609
Move new version of OPatch
We'll be storing the patches in a filesystem called /patchstore
as root
cd $GRID_HOME
rm -fr OPatch
cd /patchstore/19c30andgrid
cp -p -r OPatch $GRID_HOME
Run pre-req checks
as oracle
. oraenv
+ASM
export PATH=$PATH:$ORACLE_HOME/OPatch
cd /patchstore/19c30andgrid
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patchstore/19c30andgrid/38629535/38632161
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patchstore/19c30andgrid/38629535/38661284
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patchstore/19c30andgrid/38629535/38653268
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patchstore/19c30andgrid/38629535/38729293
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patchstore/19c30andgrid/38629535/36758186
Apply the grid home patch
For DEV
as oracle - stop all services and databases
as root
. oraenv
+ASM
export PATH=$PATH:$ORACLE_HOME/OPatch
cd /patchstore/19c30andgrid
opatchauto apply /patchstore/19c30andgrid/38629535 -oh /oracle/product/19cgrid
For PROD
as oracle - stop all services and databases
as root
. oraenv
+ASM
export PATH=$PATH:$ORACLE_HOME/OPatch
cd /patchstore/19c30andgrid
opatchauto apply /patchstore/19c30andgrid/38629535 -oh /oracle/product/19c_grid
Reboot the DB server
shutdown -r 0
Database Home Patching
as oracle
Update OPatch in the ORACLE_HOME to latest
cd to $ORACLE_HOME
rm -fr OPatch
cp -p -r /patchstore/19c30andgrid/OPatch .
set an oracle home that belongs to /oracle/product/19c
export PATH=$PATH:$ORACLE_HOME/OPatch
For EBS databases
opatch rollback -id 36749043
opatch rollback -id 33538523
cd /patchstore/19c30andgrid/38632161
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
if no patch conflicts are found then
opatch apply
Now the OJVM patch
cd /patchstore/19c30andgrid/38523609
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
if no patch conflicts detected then
opatch apply
Startup the DB and cd $ORACLE_HOME/OPatch
If EBS database do alter pluggable database all open;
./datapatch -verbose
for each database
shutdown the DB.
For EBS go to $ORACLE_HOME/appsutil/scripts/DB_lxdev01 and run
./adcdbctl.sh start
./adcdblnctl.sh start LISTENER_NAME