Patch 35042068 - Database Release Update 19.19.0.0.
230418(Linux Database
Server)
1) Backup databases using datapump expdp before applying the patch if
critical, else move to step 2.
a) Login to DB Server as user 'oracle'
b) Export environment variables ORACLE_HOME,ORACLE_BASE,etc ….
In this case ORACLE_HOME and ORACLE_BASE is
export ORACLE_BASE=/opt/oracle/product
export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=az19db01
c) Create physical directory backups under /u02/app/oracle if not present
cd /u02/app/oracle
mkdir backups
d) Create database level directory by connecting sys or system user.
sqlplus / as sysdba
create directory data_pump as '/u02/app/oracle/backups';
exit
e) Run expdp datapump to backup required schemas (Repeat if multiple
databases).
expdp system/manager directory=data_pump dumpfile= Dump_%U.dp
logfile= Dump.log schemas=<schema1>,<schema2>,… compression=all
parallel=3
NOTE: Replace dump file,log file,<schema1>,<schema2>,… with actual
schemas in the above expdp command.
2) Bring down all databases and listener on the server.
a) Login to DB Server as user 'oracle'
b) Stop databases using below command (Repeat if multiple databases).
export ORACLE_BASE=/opt/oracle/product
export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=az19db01
sqlplus / as sysdba
shut immediate
exit
c) Stop the listener using below command.
lsnrctl stop
3) Backup ORACLE_HOME and Orainventory into /u02/app/oracle/backups.
cd /opt/oracle/product/19c
cp -pr dbhome_1 /u02/app/oracle/backups/
cd /opt/oracle
cp -pr oraInventory /u02/app/oracle/backups/
4) Download oracle CPU Apr 2023 patches from below link and copy to
database server location /u02/app/oracle/backups.
https://artifactory.blueyonder.com/artifactory/oracle-db-cpu/com/oracle/
apr-2023/19c/
p35042068_190000_Linux-x86-64.zip
p35050341_190000_Linux-x86-64.zip
p6880880_190000_Linux-x86-64.zip
5) Extract the OPatch file using unzip utility in $ORACLE_HOME
Copy p6880880_190000_Linux-x86-64.zip to
/opt/oracle/product/19c/dbhome_1
cp p6880880_190000_Linux-x86-64 /opt/oracle/product/19c/dbhome_1/
cd /opt/oracle/product/19c/dbhome_1
mv OPatch OPatch_old
unzip p6880880_190000_Linux-x86-64.zip
6) Apply the patches on oracle home
a) Apply CPU Patch
cd /u02/app/oracle/backups
unzip p35042068_190000_Linux-x86-64.zip
unzip p35050341_190000_Linux-x86-64.zip
cd 35042068
export ORACLE_BASE=/opt/oracle/product
export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH
export PATH=$ORACLE_HOME/OPatch:$PATH
export PATH=$ORACLE_HOME/perl/bin:$PATH
export PERL5LIB=$ORACLE_HOME/perl/lib
opatch apply
Do you want to proceed? [y|n](Respond with y)
Is the local system ready for patching? [y|n] (Respond with y)
Patch 35042068 successfully applied.
OPatch succeeded.
Patch applied successfully.
b) Apply OJVM patch
cd /u02/app/oracle/backups/35050341
opatch apply
Do you want to proceed? [y|n](Respond with y)
Is the local system ready for patching? [y|n] (Respond with y)
Patch 35050341 successfully applied.
OPatch succeeded.
Patch applied successfully.
7) Load Modified SQL Files into the Database
For each separate database running on the same shared Oracle home being
patched, run the datapatch utility as described below.
export ORACLE_BASE=/opt/oracle/product
export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=az19db01
sqlplus / as sysdba
startup
exit
cd $ORACLE_HOME/OPatch
datapatch -verbose
Start the Listener
lsnrctl start
