ANJANI APPS DBA

Sunday, 18 October 2026

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(*)

----------

[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]

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]

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(*)

----------

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

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

Sunday, 24 May 2026

Oracle E-Business Suite 12.2.15 Fresh Install Image In Oracle Cloud - OCI

Hi All,

In this post i am going to share you how to install Oracle EBS R12.2.15 on OCI .

you will use an image hosted in Oracle Cloud Infrastructure (OCI) to provision an Oracle E-Business Suite Release 12.2.15 with Oracle Database 19c environment on a single Compute instance (VM) on OCI.

You can provision using the demo install image, and conduct demonstrations and explore new features with the resulting environment, or you can provision using the fresh install image, and tailor the resulting environment to your specific needs.

Oracle E-Business Suite 12.2.15 Demo Install Image - The instance contains demonstration data and is suitable for conducting demonstrations and exploring new features.

Oracle E-Business Suite 12.2.15 Fresh Install Image - The instance can be configured with your own data and specific, functional setups so that you can test business processes tailored to your needs.

OS ::

Oracle Linux 8

8.10 64-bit

Database version : 19C

Application version : 12.2.15

Node : Single node configuration

Click on all applications

search for Oracle E-Business Suite 12.2.15 Fresh Install Image

Click on Image and select launch instance

check the accept and click on launch

give the instance name if you want custom else leave it default

updated the shape from 1 core ocpu to 6 core ocpus..

default security and click on next

if you want to create VNC do it in this step else create vcn before launch the instance , i am using existing vcn and subnet

warning related ti IPV 6 we can ignore

update the public key and save the private key with you dont share the private key ...

click next

storage keep default and click next

review details and click on create .

estimate cost to maintain the EBS R12.2.15 fresh instance

hit the create option > we can see its provisioning

after few seconds instance is running status

we can access all the instances from OCI Console from the below navigation

select the instance we can see all the details and we can connect the cloud instance from local machine using private key .

use public ip with opc user ... we can able to connect to cloud server from the local machine.

this concludes provision EBS R12.2.15 with 19C database on OCI completed .

Thanks,

Srini

How to apply Oracle 19C RU - January 2026 step by step

Hi All,

In this post i am going to share about Oracle 19C JAN-2026 RU patch apply step by step lab .

Firstly we need to login support.oracle.com and click on critical patch updates , then click on the JAN-2026 CPU patch document

you can able to see below

Click on database > that will navigate to below Oracle Critical Patch Update (CPU) Jan 2026 for Oracle Database Products

Depends on your OS download the patch, here in this lab i used Linux X86-64 bit OS for oracle 19C Database

Click on the patch that will redirect to patch download page .. if you have valid CIS number only you can download else you can see download option disabled.

i have download that patch using right credentials, copy that patch to database server and read the read me file for pre-requisites if anything before apply the RU.