Patch in Oracle Gateway 19.29 is an essential maintenance activity for ensuring the security and optimal performance of your Oracle databases. The Oracle 19.29 patch (identified by patch number 38291812) is part of the Oracle Database Release Update (DBRU) for Oracle 19c. In this guide, we’ll walk you through the process of applying the 19.29 patch using the OPatch utility
Prerequisites
Before proceeding, ensure the following:
- Oracle 19c is installed on your system.
- OPatch Utility is installed and configured.
- Backup your Oracle Home directory and databases.
- Ensure Oracle instances are stopped before applying the patch to avoid issues during the patching process.
- Patch files are downloaded and accessible (e.g.,
p38291812_190000_Linux-x86-64.zip).
Step 1: Verify OPatch Version
Start by confirming that your OPatch utility is up-to-date. Oracle frequently updates the OPatch utility, and using an older version may cause compatibility issues when applying the latest patches.
To check the OPatch version, use the following command:
[oracle@prod OPatch_old]$ ./opatch version
OPatch Version: 12.2.0.1.15
OPatch succeeded.
This command will return the current OPatch version installed on your system.
If needed, update OPatch to the latest version. Oracle typically includes an updated version of OPatch within the patch zip, which you should unzip into your Oracle Gateway Home directory.
Step 2: Unzip the New OPatch Version
If your current version of OPatch is outdated, you need to update it before proceeding with the patch application.
- Download the OPatch ZIP file (e.g.,
p6880880_190000_Linux-x86-64.zip). - Unzip the OPatch ZIP file to the Oracle Gateway Home directory:
[oracle@prod gw]$ unzip p6880880_190000_Linux-x86-64.zip -d /u01/app/oracle/gw
Verify that the update was successful by running the following command:
[oracle@prod OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.47
OPatch succeeded.
Step 3: Unzip the 19.29 Patch
Now that OPatch is updated, unzip the 19.29 patch file (e.g., p38291812_190000_Linux-x86-64.zip) into a directory:
Download the 19.29 patch ZIP file.
Unzip it using the following command:
[oracle@prod 38291812]$ unzip p38291812_190000_Linux-x86-64.zip
Step 4: Check for Conflicts
Before applying the patch, you should run a conflict check to ensure that the patch can be applied without issues. This step helps avoid potential conflicts with other installed patches.
Use the following command to check for conflicts:
[oracle@prod 38291812]$ /u01/app/oracle/gw/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
If no conflicts are found, the output will look like this:
/u01/app/oracle/gw/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.47
Copyright (c) 2025, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/gw
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/gw//oraInst.loc
OPatch version : 12.2.0.1.47
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/gw/cfgtoollogs/opatch/opatch2025-10-29_09-23-50AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
Step 5: Apply the 19.29 Patch
With the patch verified and no conflicts found, you can now proceed to apply the patch. OPatch will guide you through the process.
Run the following command to apply the patch:
[oracle@prod 38291812]$ /u01/app/oracle/gw/OPatch/opatch apply
You will be prompted to confirm whether you want to proceed. Type y and press Enter to continue:
Do you want to proceed? [y|n]
y
OPatch will check the environment, perform prerequisite checks, and then proceed with patch installation.
Once the patch has been successfully applied, you’ll see an output like this:
/u01/app/oracle/gw/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.47
Copyright (c) 2025, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/gw
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/gw//oraInst.loc
OPatch version : 12.2.0.1.47
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/gw/cfgtoollogs/opatch/opatch2025-10-29_09-24-35AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 38291812
Do you want to proceed? [y|n]
y
User Responded with: Y
y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/gw')
Is the local system ready for patching? [y|n]
User Responded with: Y
Backing up files...
Applying interim patch '38291812' to OH '/u01/app/oracle/gw'
ApplySession: Optional component(s) [ oracle.rdbms, 19.0.0.0.0 ] , [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.assistants.server, 19.0.0.0.0 ] , [ oracle.blaslapack, 19.0.0.0.0 ] , [ oracle.crypto.rsf, 19.0.0.0.0 ] , [ oracle.ctx, 19.0.0.0.0 ] , [ oracle.dbdev, 19.0.0.0.0 ] , [ oracle.dbjava.ucp, 19.0.0.0.0 ] , [ oracle.duma, 19.0.0.0.0 ] , [ oracle.marvel, 19.0.0.0.0 ] , [ oracle.odbc.ic, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.precomp.common.core, 19.0.0.0.0 ] , [ oracle.precomp.companion, 19.0.0.0.0 ] , [ oracle.rdbms.dbscripts, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.oci, 19.0.0.0.0 ] , [ oracle.rdbms.scheduler, 19.0.0.0.0 ] , [ oracle.rhp.db, 19.0.0.0.0 ] , [ oracle.sdo, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.sdo.locator.jrf, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.tfa.db, 19.0.0.0.0 ] , [ oracle.wwg.plsql, 19.0.0.0.0 ] , [ oracle.rdbms.locator, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.network.aso, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.ctx.atg, 19.0.0.0.0 ] , [ oracle.ovm, 19.0.0.0.0 ] , [ oracle.rdbms.lbac, 19.0.0.0.0 ] , [ oracle.ctx.rsf, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.xdk.xquery, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.oraolap, 19.0.0.0.0 ] , [ oracle.xdk.server, 19.0.0.0.0 ] , [ oracle.odbc, 19.0.0.0.0 ] , [ oracle.oraolap.api, 19.0.0.0.0 ] , [ oracle.oraolap.dbscripts, 19.0.0.0.0 ] , [ oracle.rdbms.rat, 19.0.0.0.0 ] , [ oracle.dbtoolslistener, 19.0.0.0.0 ] , [ oracle.rdbms.hsodbc, 19.0.0.0.0 ] , [ oracle.rdbms.drdaas, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.xdk, 19.0.0.0.0 ] , [ oracle.rdbms.dm, 19.0.0.0.0 ] , [ oracle.pg4mq, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.sqlj.sqljruntime, 19.0.0.0.0 ] , [ oracle.java.sqlj.sqljruntime, 19.0.0.0.0 ] , [ oracle.datamining, 19.0.0.0.0 ] , [ oracle.javavm.server, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.ldap.ztk, 19.0.0.0.0 ] , [ oracle.mgw.common, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.rdbms.dv, 19.0.0.0.0 ] , [ oracle.sdo.locator, 19.0.0.0.0 ] , [ oracle.precomp.common, 19.0.0.0.0 ] , [ oracle.precomp.lang, 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.rsf, 19.0.0.0.0...
Patching component oracle.rdbms.util, 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.buildtools.rsf, 19.0.0.0.0...
Patching component oracle.dbjava.ic, 19.0.0.0.0...
Patching component oracle.dbjava.jdbc, 19.0.0.0.0...
Patching component oracle.javavm.client, 19.0.0.0.0...
Patching component oracle.ldap.client, 19.0.0.0.0...
Patching component oracle.ldap.owm, 19.0.0.0.0...
Patching component oracle.ldap.rsf, 19.0.0.0.0...
Patching component oracle.ldap.security.osdt, 19.0.0.0.0...
Patching component oracle.network.rsf, 19.0.0.0.0...
Patching component oracle.ons, 19.0.0.0.0...
Patching component oracle.ons.ic, 19.0.0.0.0...
Patching component oracle.oracore.rsf, 19.0.0.0.0...
Patching component oracle.perlint, 5.28.1.0.0...
Patching component oracle.precomp.rsf, 19.0.0.0.0...
Patching component oracle.rdbms.crs, 19.0.0.0.0...
Patching component oracle.rdbms.deconfig, 19.0.0.0.0...
Patching component oracle.rdbms.install.common, 19.0.0.0.0...
Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0...
Patching component oracle.rdbms.tg4db2, 19.0.0.0.0...
Patching component oracle.rsf, 19.0.0.0.0...
Patching component oracle.sqlplus, 19.0.0.0.0...
Patching component oracle.sqlplus.ic, 19.0.0.0.0...
Patching component oracle.xdk.rsf, 19.0.0.0.0...
Patching component oracle.ldap.rsf.ic, 19.0.0.0.0...
Patching component oracle.rdbms.rman, 19.0.0.0.0...
Patching component oracle.network.client, 19.0.0.0.0...
Patching component oracle.nlsrtl.rsf.core, 19.0.0.0.0...
Patching component oracle.rdbms.install.plugins, 19.0.0.0.0...
Patching component oracle.xdk.parser.java, 19.0.0.0.0...
Patching component oracle.install.deinstalltool, 19.0.0.0.0...
Patching component oracle.ldap.ssl, 19.0.0.0.0...
Patching component oracle.nlsrtl.rsf, 19.0.0.0.0...
Patching component oracle.nlsrtl.rsf.core, 19.0.0.0.0...
Patching component oracle.nlsrtl.rsf.ic, 19.0.0.0.0...
Patching component oracle.nlsrtl.rsf.lbuilder, 19.0.0.0.0...
Patching component oracle.network.listener, 19.0.0.0.0...
Patching component oracle.rdbms.hs_common, 19.0.0.0.0...
Patching component oracle.jdk, 1.8.0.201.0...
Patch 38291812 successfully applied.
Log file location: /u01/app/oracle/gw/cfgtoollogs/opatch/opatch2025-10-29_09-24-35AM_1.log
OPatch succeeded.
OPatch will log the patch application process in a log file located in the following directory:
Log file location : /u01/app/oracle/gw/cfgtoollogs/opatch/opatch2025-10-29_09-24-35AM_1.log
Step 6: Verify the Patch Installation
After the patch is applied, you can verify that it was successfully installed using the lspatches command. This command lists all patches that are currently installed on your Oracle Home.
Run the following command to check the list of installed patches:
[oracle@prod 38291812]$ /u01/app/oracle/gw/OPatch/opatch lspatches
The output should include the newly installed patch:
38291812;Database Release Update : 19.29.0.0.251021 (38291812)
OPatch succeeded.
Step 7: Restart Oracle Services
Once the patch is applied, restart any Oracle services that were stopped during the patching process. This is a necessary step to ensure that the changes take effect.
Conclusion
Applying the Oracle 19.29 patch in Oracle Gateway is a crucial step to keep your system secure and performing efficiently. By following the steps outlined in this guide, you can ensure a smooth patch installation process. For more patching-related information and updates, visit DBA Insight Patch Update
Key Points:
- Always back up your system before applying patches.
- Ensure your OPatch utility is updated before patching.
- Check for conflicts before applying any patches.
- After applying the patch, verify its success and restart Oracle services.
By regularly applying patches, you ensure that your Oracle environment stays up-to-date, secure, and optimized for performance.
Comments 1