How to Apply Oracle 19C Latest RU patch on OEL 7 - 19.32 step by step

 Dear All,

In this post i am going to share step by step lab how to apply Latest RU patch on Oracle 19C Database .

Lab Environment :   Database Version > 19.3.0.0 

OS : OEL 7

Download latest RU patches from Support. 

https://support.oracle.com/support/?page=sptemplate&sptemplate=cp-patches-updates-view-more&cp-patches-updates-view-more=cp-patches-details

enter the patch number and platform details click on Apply 

Click on the patch number and download 

download the pre-requisite for this 19.32 patch was 6880880 latest 12.****.1.53

Copy the patch to server and unzip it .

https://updates.oracle.com/Orion/Services/download?type=readme&aru=28919163

stop the database services and set the path ..  

Note : take backup of all important files and home .

Before patch versions :

 

check the database status and stop the database

SQL> select count(*) from dba_objects where status='INVALID';

  COUNT(*)

----------

0

[oracle@dbnode1 OPatch]$ srvctl stop database -d prod

[oracle@dbnode1 OPatch]$ srvctl status database -d prod

Instance prod1 is not running on node dbnode1

Instance prod2 is not running on node dbnode2

unzip the opatch under oracle home , post that OPatch version would be latest 

[oracle@dbnode1 db_home]$ cd OPatch

[oracle@dbnode1 OPatch]$ ./opatch version

OPatch Version: 12.2.0.1.53

OPatch succeeded.

apply the RU PATCH 

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:   39472050  

Do you want to proceed? [y|n]

y

User Responded with: Y

All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/u01/app/oracle/product/19.0.0/db_home')

Is the local system ready for patching? [y|n]

y

User Responded with: Y

Backing up files...

Applying interim patch '39472050' to OH '/u01/app/oracle/product/19.0.0/db_home'

ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.datamining, 19.0.0.0.0 ] , [ oracle.crypto.rsf, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.precomp.companion, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.java.sqlj.sqljruntime, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.ldap.ztk, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ] , [ oracle.jdk, 1.8.0.391.11 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.util, 19.0.0.0.0...

Patching component oracle.rdbms.rsf, 19.0.0.0.0...

Patching component oracle.rdbms, 19.0.0.0.0...

Patching component oracle.assistants.acf, 19.0.0.0.0...

Patching component oracle.assistants.deconfig, 19.0.0.0.0...

Patching component oracle.assistants.server, 19.0.0.0.0...

Patching component oracle.blaslapack, 19.0.0.0.0...

Patching component oracle.buildtools.rsf, 19.0.0.0.0...

Patching component oracle.wwg.plsql, 19.0.0.0.0...

Once the patch applied successfully start the database services :

post patch invalid object count 

SQL> alter session set container=PDB;

Session altered.

SQL> select count(*) from dba_objects where status='INVALID';

  COUNT(*)

----------

0

Opatch completed : 

run the datapatch verbose 

datapatch -verbose log :

================

[oracle@dbnode1 OPatch]$ ./datapatch -verbose

SQL Patching tool version 19.32.0.0.0 Production on Sun Oct 18 17:13:01 2026

Copyright (c) 2012, 2026, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_17850_2026_10_18_17_13_01/sqlpatch_invocation.log

Connecting to database...OK

Gathering database info...done

Note:  Datapatch will only apply or rollback SQL fixes for PDBs

       that are in an open state, no patches will be applied to closed PDBs.

       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation

       (Doc ID 1585822.1)

Bootstrapping registry and package to current versions...done

Determining current state...done

Current state of interim SQL patches:

  No interim patches found

Current state of release update SQL patches:

  Binary registry:

    19.32.0.0.0 Release_Update 260705220710: Installed

  PDB CDB$ROOT:

    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 03-MAR-25 09.36.38.015829 PM

  PDB PDB:

    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 03-MAR-25 09.47.18.230520 PM

  PDB PDB$SEED:

    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 03-MAR-25 09.47.18.230520 PM

Adding patches to installation queue and performing prereq checks...done

Installation queue:

  For the following PDBs: CDB$ROOT PDB$SEED PDB

    No interim patches need to be rolled back

    Patch 39472050 (Database Release Update : 19.32.0.0.260721 (39472050)):

      Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.32.0.0.0 Release_Update 260705220710

    No interim patches need to be applied

Installing patches...

Thanks,

Srini