Skip to content

Patching Logs

Agnivo102 edited this page Oct 16, 2026 · 1 revision

Patching of 33859214 Logs:

Pre-requisites and pre-database checks:

  1. Current patch status

SQL> select banner, banner_full, banner_legacy from v$version;

BANNER BANNER_FULL BANNER_LEGACY

------------------------------ ------------------------------ ------------------------------

Oracle Database 19c Enterprise Oracle Database 19c Enterprise Oracle Database 19c Enterprise

Edition Release 19.0.0.0.0 - Edition Release 19.0.0.0.0 - Edition Release 19.0.0.0.0 -

Production Production Production

Version 19.3.0.0.0

SQL> select instance_name, host_name, version, version_full from v$instance;

INSTANCE_NAME HOST_NAME VERSION VERSION_FULL

---------------- ---------------------------------------------------------------- ----------------- -----------------

prod localhost.localdomain 19.0.0.0.0 19.3.0.0.0

2. Database status

SQL> select name, db_unique_name, open_mode, database_role, log_mode, flashback_on from v$database;

NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE LOG_MODE FLASHBACK_ON

--------- ------------------------------ -------------------- ---------------- ------------ ------------------

PROD prod READ WRITE PRIMARY ARCHIVELOG NO

SQL> select instance_name, status, database_status, startup_time from v$instance;

INSTANCE_NAME STATUS DATABASE_STATUS STARTUP_T

---------------- ------------ ----------------- ---------

prod OPEN ACTIVE 15-OCT-26

SQL> select instance_name, status, database_status, to_char(startup_time, 'dd/mm/yyyy hh24:mi:ss') as startup_time from v$instance;

INSTANCE_NAME STATUS DATABASE_STATUS STARTUP_TIME

---------------- ------------ ----------------- -------------------

prod OPEN ACTIVE 15/10/2026 09:11:27

3. Check invalid objects

SQL> select owner, object_type, count(*) as invalid_count from dba_objects where status = 'INVALID' group by owner, object_type order by owner, object_type;

no rows selected

4. Purge Recycle Bin

SQL> purge recyclebin;

Recyclebin purged.

33859214/33803476/33806152

5. Upgrade the OPatch utility tool and unzip the patch file in another empty directory

Rename the older version utility tool another name, then unzip the OPatch utility tool file in the ORACLE HOME directory. Then unzip the actual patch file in another empty directory.

6. Validate the oracle Inventory:

[oracle@localhost OPatch]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME

Oracle Interim Patch Installer version 12.2.0.1.30

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

Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1

Central Inventory : /u01/app/oraInventory

from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc

OPatch version : 12.2.0.1.30

OUI version : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-10-15_09-45-16AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2026-10-15_09-45-16AM.txt

--------------------------------------------------------------------------------

Local Machine Information::

Hostname: localhost

ARU platform id: 226

ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 19c 19.0.0.0.0

7. Run OPatch Conflict Check:

OPatch failed with error code 135

[oracle@localhost OPatch]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patches/33859214/33803476/33806152

Oracle Interim Patch Installer version 12.2.0.1.30

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

PREREQ session

Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1

Central Inventory : /u01/app/oraInventory

from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc

OPatch version : 12.2.0.1.30

OUI version : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-10-15_09-47-28AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[oracle@localhost OPatch]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patches/33859214/33803476/33806152

Oracle Interim Patch Installer version 12.2.0.1.30

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

PREREQ session

Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1

Central Inventory : /u01/app/oraInventory

from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc

OPatch version : 12.2.0.1.30

OUI version : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-10-15_09-49-41AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

8. Run OPatch System Space Check

[oracle@localhost OPatch]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt

Oracle Interim Patch Installer version 12.2.0.1.30

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

PREREQ session

Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1

Central Inventory : /u01/app/oraInventory

from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc

OPatch version : 12.2.0.1.30

OUI version : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-10-15_10-02-48AM_1.log

Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.

OPatch succeeded.

Apply the patch:

  1. /u01/patches/33859214/33803476 patches

1.1. /u01/patches/33859214/33803476/33575402

[oracle@localhost 33575402]$ $ORACLE_HOME/OPatch/opatch apply

Oracle Interim Patch Installer version 12.2.0.1.30

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

Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1

Central Inventory : /u01/app/oraInventory

from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc

OPatch version : 12.2.0.1.30

OUI version : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-10-15_10-05-08AM_1.log

Verifying environment and performing prerequisite checks...

Skip patch 33575402 from list of patches to apply: This patch is not needed.

After skipping patches with missing components, there are no patches to apply.

OPatch Session completed with warnings.

Log file location: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-10-15_10-05-08AM_1.log

OPatch completed with warnings.

1.1.1. /u01/patches/33859214/33803476/33575402 logfile:

OUI version : 12.2.0.7.0

OUI location : /u01/app/oracle/product/19.0.0/dbhome_1/oui

Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-10-15_10-05-08AM_1.log

[Oct 15, 2026 10:05:09 AM] [INFO] Patch history file: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt

[Oct 15, 2026 10:05:11 AM] [INFO] [OPSR-TIME] Loading raw inventory

[Oct 15, 2026 10:05:11 AM] [INFO] [OPSR-MEMORY] Loaded all components from inventory. Heap memory in use: 13 (MB)

[Oct 15, 2026 10:05:11 AM] [INFO] [OPSR-MEMORY] Loaded all one offs from inventory. Heap memory in use: 13 (MB)

[Oct 15, 2026 10:05:11 AM] [INFO] [OPSR-TIME] Raw inventory loaded successfully

[Oct 15, 2026 10:05:11 AM] [INFO] NApply::no CAS enabled, OPatch runs with legacy process.

[Oct 15, 2026 10:05:12 AM] [INFO] Verifying environment and performing prerequisite checks...

[Oct 15, 2026 10:05:12 AM] [INFO] [OPSR-TIME] Running prerequisite checks

[Oct 15, 2026 10:05:12 AM] [INFO] opatch-external.jar is in /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/jlib/opatch-external.jar

[Oct 15, 2026 10:05:12 AM] [INFO] [OPSR-TIME] Loading cooked inventory

[Oct 15, 2026 10:05:12 AM] [INFO] [OPSR-MEMORY] : Loading cooked one offs. Heap memory used 22 (MB)

[Oct 15, 2026 10:05:12 AM] [INFO] [OPSR-MEMORY] : Loaded cooked oneoffs. Heap memory used : 25 (MB)

[Oct 15, 2026 10:05:12 AM] [INFO] [OPSR-TIME] Cooked inventory loaded successfully

[Oct 15, 2026 10:05:13 AM] [INFO] Checking if Oracle Home has components required by patches...

[Oct 15, 2026 10:05:13 AM] [INFO] Skip patch 33575402 from list of patches to apply: This patch is not needed.

[Oct 15, 2026 10:05:13 AM] [INFO] CheckMissingComps: Cached file does not exist or is invalid, re-build prereq result.

[Oct 15, 2026 10:05:13 AM] [WARNING]OUI-67124:

After skipping patches with missing components, there are no patches to apply.

[Oct 15, 2026 10:05:13 AM] [INFO] UtilSession: N-Apply done.

[Oct 15, 2026 10:05:13 AM] [INFO] --------------------------------------------------------------------------------

[Oct 15, 2026 10:05:13 AM] [INFO] The following warnings have occurred during OPatch execution:

[Oct 15, 2026 10:05:13 AM] [INFO] 1) OUI-67124:

After skipping patches with missing components, there are no patches to apply.

[Oct 15, 2026 10:05:13 AM] [INFO] --------------------------------------------------------------------------------

[Oct 15, 2026 10:05:13 AM] [SEVERE] OUI-67008:OPatch Session completed with warnings.

[Oct 15, 2026 10:05:13 AM] [INFO] Finishing UtilSession at Thu Oct 15 10:05:13 IST 2026

[Oct 15, 2026 10:05:13 AM] [INFO] Log file location: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-10-15_10-05-08AM_1.log

1.2. /u01/patches/33859214/33803476/33806152

[oracle@localhost 33806152]$ $ORACLE_HOME/OPatch/opatch apply

Oracle Interim Patch Installer version 12.2.0.1.30

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

Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1

Central Inventory : /u01/app/oraInventory

from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc

OPatch version : 12.2.0.1.30

OUI version : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-10-15_14-39-35PM_1.log

Verifying environment and performing prerequisite checks...

--------------------------------------------------------------------------------

Start OOP by Prereq process.

Launch OOP...

Oracle Interim Patch Installer version 12.2.0.1.30

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

Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1

Central Inventory : /u01/app/oraInventory

from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc

OPatch version : 12.2.0.1.30

OUI version : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-10-15_14-40-51PM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches: 33806152

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/dbhome_1')

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

y

User Responded with: Y

Backing up files...

Applying interim patch '33806152' to OH '/u01/app/oracle/product/19.0.0/dbhome_1'

ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.bali.ewt, 11.1.1.6.0...

Patching component oracle.help.ohj, 11.1.1.7.0...

Patching component oracle.perlint, 5.28.1.0.0...

Patching component oracle.rdbms.locator, 19.0.0.0.0...

Patching component oracle.perlint.expat, 2.0.1.0.4...

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

Segmentation fault (core dumped)

[oracle@localhost dbhome_1]$

Patching component oracle.rdbms.util, 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.buildtools.rsf, 19.0.0.0.0...

Patching component oracle.ctx, 19.0.0.0.0...

Patching component oracle.dbdev, 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.dbjava.ucp, 19.0.0.0.0...

Patching component oracle.duma, 19.0.0.0.0...

Patching component oracle.javavm.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.marvel, 19.0.0.0.0...

Patching component oracle.network.rsf, 19.0.0.0.0...

Patching component oracle.odbc.ic, 19.0.0.0.0...

Patching component oracle.oracore.rsf, 19.0.0.0.0...

Patching component oracle.precomp.common.core, 19.0.0.0.0...

Patching component oracle.rdbms.crs, 19.0.0.0.0...

Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...

Patching component oracle.rdbms.deconfig, 19.0.0.0.0...

Patching component oracle.rdbms.oci, 19.0.0.0.0...

Patching component oracle.rhp.db, 19.0.0.0.0...

Patching component oracle.sdo, 19.0.0.0.0...

Patching component oracle.sdo.locator.jrf, 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.wwg.plsql, 19.0.0.0.0...

Patching component oracle.rdbms.rman, 19.0.0.0.0...

Patching component oracle.dbtoolslistener, 19.0.0.0.0...

Patching component oracle.rdbms.scheduler, 19.0.0.0.0...

Patching component oracle.oraolap, 19.0.0.0.0...

Patching component oracle.oraolap.api, 19.0.0.0.0...

Patching component oracle.precomp.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.hs_common, 19.0.0.0.0...

Patching component oracle.xdk.parser.java, 19.0.0.0.0...

Patching component oracle.xdk.xquery, 19.0.0.0.0...

Patching component oracle.rdbms.install.common, 19.0.0.0.0...

Patching component oracle.mgw.common, 19.0.0.0.0...

Patching component oracle.rdbms.drdaas, 19.0.0.0.0...

Patching component oracle.install.deinstalltool, 19.0.0.0.0...

Patching component oracle.network.client, 19.0.0.0.0...

Patching component oracle.odbc, 19.0.0.0.0...

Patching component oracle.ons.ic, 19.0.0.0.0...

Patching component oracle.xdk.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.hsodbc, 19.0.0.0.0...

Patching component oracle.oraolap.dbscripts, 19.0.0.0.0...

Patching component oracle.rdbms.lbac, 19.0.0.0.0...

Patching component oracle.nlsrtl.rsf, 19.0.0.0.0...

Patching component oracle.ctx.atg, 19.0.0.0.0...

Patching component oracle.network.listener, 19.0.0.0.0...

Patching component oracle.ldap.ssl, 19.0.0.0.0...

Patching component oracle.ovm, 19.0.0.0.0...

Patching component oracle.rdbms.install.plugins, 19.0.0.0.0...

Patching component oracle.ctx.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.dv, 19.0.0.0.0...

Patching component oracle.ons, 19.0.0.0.0...

Patching component oracle.javavm.server, 19.0.0.0.0...

Patching component oracle.ldap.client, 19.0.0.0.0...

Patching component oracle.ldap.rsf.ic, 19.0.0.0.0...

Patching component oracle.xdk, 19.0.0.0.0...

Patching component oracle.sdo.locator, 19.0.0.0.0...

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

Patching component oracle.precomp.common, 19.0.0.0.0...

Patching component oracle.precomp.lang, 19.0.0.0.0...

Patching component oracle.jdk, 1.8.0.201.0...

Patch 33806152 successfully applied.

Sub-set patch [29517242] has become inactive due to the application of a super-set patch [33806152].

Please refer to Doc ID 2161861.1 for any possible further required actions.

Log file location: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-10-15_14-40-51PM_1.log

OPatch succeeded.

[oracle@localhost 33806152]$

1.3 /u01/patches/33859214/33803476/33815596

[oracle@localhost 33815596]$ $ORACLE_HOME/OPatch/opatch apply

Oracle Interim Patch Installer version 12.2.0.1.30

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

Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1

Central Inventory : /u01/app/oraInventory

from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc

OPatch version : 12.2.0.1.30

OUI version : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-10-15_15-00-12PM_1.log

Verifying environment and performing prerequisite checks...

--------------------------------------------------------------------------------

Start OOP by Prereq process.

Launch OOP...

Oracle Interim Patch Installer version 12.2.0.1.30

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

Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1

Central Inventory : /u01/app/oraInventory

from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc

OPatch version : 12.2.0.1.30

OUI version : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-10-15_15-01-10PM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches: 33815596

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/dbhome_1')

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

y

User Responded with: Y

Backing up files...

Applying interim patch '33815596' to OH '/u01/app/oracle/product/19.0.0/dbhome_1'

ApplySession: Optional component(s) [ oracle.has.crs.cvu, 19.0.0.0.0 ] , [ oracle.has.crs, 19.0.0.0.0 ] , [ oracle.has.cvu, 19.0.0.0.0 ] , [ oracle.rhp.crs, 19.0.0.0.0 ] , [ oracle.xag, 19.0.0.0.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms, 19.0.0.0.0...

Patching component oracle.has.db, 19.0.0.0.0...

Patching component oracle.has.common, 19.0.0.0.0...

Patching component oracle.has.rsf, 19.0.0.0.0...

Patching component oracle.has.db.cvu, 19.0.0.0.0...

Patching component oracle.has.common.cvu, 19.0.0.0.0...

Patching component oracle.rhp.common, 19.0.0.0.0...

Patching component oracle.rhp.db, 19.0.0.0.0...

Patch 33815596 successfully applied.

Sub-set patch [29585399] has become inactive due to the application of a super-set patch [33815596].

Please refer to Doc ID 2161861.1 for any possible further required actions.

Log file location: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-10-15_15-01-10PM_1.log

OPatch succeeded.

[oracle@localhost 33815596]$

1.4. /u01/patches/33859214/33803476/33815607

[oracle@localhost 33815607]$ $ORACLE_HOME/OPatch/opatch apply

Oracle Interim Patch Installer version 12.2.0.1.30

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

Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1

Central Inventory : /u01/app/oraInventory

from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc

OPatch version : 12.2.0.1.30

OUI version : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-10-15_15-06-20PM_1.log

Verifying environment and performing prerequisite checks...

Skip patch 33815607 from list of patches to apply: This patch is not needed.

After skipping patches with missing components, there are no patches to apply.

OPatch Session completed with warnings.

Log file location: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-10-15_15-06-20PM_1.log

OPatch completed with warnings.

1.4.1. /u01/patches/33859214/33803476/33815607 logfile

[Oct 15, 2026 3:06:21 PM] [INFO] CAS Dynamic Loading :

CasClasspathLoader: Opatch path to be searched for cas jars :/u01/app/oracle/product/19.0.0/dbhome_1/OPatch/jlib

CasClasspathLoader : Non CAS based Home

[Oct 15, 2026 3:06:21 PM] [INFO] CUP_LOG: Trying to load HomeOperations object

[Oct 15, 2026 3:06:21 PM] [INFO] CUP_LOG: HomeOperations object created. CUP1.0 is enabled

[Oct 15, 2026 3:06:21 PM] [INFO] OPatch invoked as follows: 'apply -invPtrLoc /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc '

[Oct 15, 2026 3:06:21 PM] [INFO] Runtime args: [-Xmx3072m, -XX:+HeapDumpOnOutOfMemoryError, -XX:HeapDumpPath=/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch, -DCommonLog.LOG_SESSION_ID=, -DCommonLog.COMMAND_NAME=apply, -DOPatch.ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1, -DOPatch.DEBUG=false, -DOPatch.MAKE=false, -DOPatch.RUNNING_DIR=/u01/app/oracle/product/19.0.0/dbhome_1/OPatch, -DOPatch.MW_HOME=, -DOPatch.WL_HOME=, -DOPatch.COMMON_COMPONENTS_HOME=, -DOPatch.OUI_LOCATION=/u01/app/oracle/product/19.0.0/dbhome_1/oui, -DOPatch.FMW_COMPONENT_HOME=, -DOPatch.OPATCH_CLASSPATH=, -DOPatch.WEBLOGIC_CLASSPATH=, -DOPatch.SKIP_OUI_VERSION_CHECK=, -DOPatch.NEXTGEN_HOME_CHECK=false, -DOPatch.PARALLEL_ON_FMW_OH=]

[Oct 15, 2026 3:06:21 PM] [INFO] Heap in use : 7 MB

Total memory: 69 MB

Free memory : 62 MB

Max memory : 2969 MB

[Oct 15, 2026 3:06:21 PM] [INFO] Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1

Central Inventory : /u01/app/oraInventory

from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc

OPatch version : 12.2.0.1.30

OUI version : 12.2.0.7.0

OUI location : /u01/app/oracle/product/19.0.0/dbhome_1/oui

Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-10-15_15-06-20PM_1.log

[Oct 15, 2026 3:06:21 PM] [INFO] Patch history file: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt

[Oct 15, 2026 3:06:23 PM] [INFO] [OPSR-TIME] Loading raw inventory

[Oct 15, 2026 3:06:24 PM] [INFO] [OPSR-MEMORY] Loaded all components from inventory. Heap memory in use: 13 (MB)

[Oct 15, 2026 3:06:24 PM] [INFO] [OPSR-MEMORY] Loaded all one offs from inventory. Heap memory in use: 15 (MB)

[Oct 15, 2026 3:06:24 PM] [INFO] [OPSR-TIME] Raw inventory loaded successfully

[Oct 15, 2026 3:06:24 PM] [INFO] NApply::no CAS enabled, OPatch runs with legacy process.

[Oct 15, 2026 3:06:24 PM] [INFO] Verifying environment and performing prerequisite checks...

[Oct 15, 2026 3:06:24 PM] [INFO] [OPSR-TIME] Running prerequisite checks

[Oct 15, 2026 3:06:24 PM] [INFO] opatch-external.jar is in /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/jlib/opatch-external.jar

"/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-10-15_15-06-20PM_1.log" 46L, 4980C

1.5. /u01/patches/33859214/33803476/33911149

[oracle@localhost 33911149]$ $ORACLE_HOME/OPatch/opatch apply

Oracle Interim Patch Installer version 12.2.0.1.30

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

Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1

Central Inventory : /u01/app/oraInventory

from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc

OPatch version : 12.2.0.1.30

OUI version : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-10-15_15-15-57PM_1.log

Verifying environment and performing prerequisite checks...

Skip patch 33911149 from list of patches to apply: This patch is not needed.

After skipping patches with missing components, there are no patches to apply.

OPatch Session completed with warnings.

Log file location: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-10-15_15-15-57PM_1.log

OPatch completed with warnings.

1.5.1. /u01/patches/33859214/33803476/33911149 its log:

[Oct 15, 2026 3:15:58 PM] [INFO] CAS Dynamic Loading :

CasClasspathLoader: Opatch path to be searched for cas jars :/u01/app/oracle/product/19.0.0/dbhome_1/OPatch/jlib

CasClasspathLoader : Non CAS based Home

[Oct 15, 2026 3:15:58 PM] [INFO] CUP_LOG: Trying to load HomeOperations object

[Oct 15, 2026 3:15:58 PM] [INFO] CUP_LOG: HomeOperations object created. CUP1.0 is enabled

[Oct 15, 2026 3:15:58 PM] [INFO] OPatch invoked as follows: 'apply -invPtrLoc /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc '

[Oct 15, 2026 3:15:58 PM] [INFO] Runtime args: [-Xmx3072m, -XX:+HeapDumpOnOutOfMemoryError, -XX:HeapDumpPath=/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch, -DCommonLog.LOG_SESSION_ID=, -DCommonLog.COMMAND_NAME=apply, -DOPatch.ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1, -DOPatch.DEBUG=false, -DOPatch.MAKE=false, -DOPatch.RUNNING_DIR=/u01/app/oracle/product/19.0.0/dbhome_1/OPatch, -DOPatch.MW_HOME=, -DOPatch.WL_HOME=, -DOPatch.COMMON_COMPONENTS_HOME=, -DOPatch.OUI_LOCATION=/u01/app/oracle/product/19.0.0/dbhome_1/oui, -DOPatch.FMW_COMPONENT_HOME=, -DOPatch.OPATCH_CLASSPATH=, -DOPatch.WEBLOGIC_CLASSPATH=, -DOPatch.SKIP_OUI_VERSION_CHECK=, -DOPatch.NEXTGEN_HOME_CHECK=false, -DOPatch.PARALLEL_ON_FMW_OH=]

[Oct 15, 2026 3:15:58 PM] [INFO] Heap in use : 7 MB

Total memory: 69 MB

Free memory : 62 MB

Max memory : 2969 MB

[Oct 15, 2026 3:15:58 PM] [INFO] Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1

Central Inventory : /u01/app/oraInventory

from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc

OPatch version : 12.2.0.1.30

OUI version : 12.2.0.7.0

OUI location : /u01/app/oracle/product/19.0.0/dbhome_1/oui

Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-10-15_15-15-57PM_1.log

[Oct 15, 2026 3:15:58 PM] [INFO] Patch history file: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt

[Oct 15, 2026 3:16:00 PM] [INFO] [OPSR-TIME] Loading raw inventory

[Oct 15, 2026 3:16:01 PM] [INFO] [OPSR-MEMORY] Loaded all components from inventory. Heap memory in use: 13 (MB)

[Oct 15, 2026 3:16:01 PM] [INFO] [OPSR-MEMORY] Loaded all one offs from inventory. Heap memory in use: 15 (MB)

[Oct 15, 2026 3:16:01 PM] [INFO] [OPSR-TIME] Raw inventory loaded successfully

[Oct 15, 2026 3:16:01 PM] [INFO] NApply::no CAS enabled, OPatch runs with legacy process.

[Oct 15, 2026 3:16:01 PM] [INFO] Verifying environment and performing prerequisite checks...

[Oct 15, 2026 3:16:01 PM] [INFO] [OPSR-TIME] Running prerequisite checks

[Oct 15, 2026 3:16:01 PM] [INFO] opatch-external.jar is in /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/jlib/opatch-external.jar

"/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-10-15_15-15-57PM_1.log" 46L, 4980C

2. /u01/patches/33859214/33808367 patches

2.1. There is no other sub-patches inside this one. So /u01/patches/33859214/33808367 patch:

[oracle@localhost 33808367]$ $ORACLE_HOME/OPatch/opatch apply

Oracle Interim Patch Installer version 12.2.0.1.30

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

Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1

Central Inventory : /u01/app/oraInventory

from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc

OPatch version : 12.2.0.1.30

OUI version : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-10-15_15-39-17PM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches: 33808367

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/dbhome_1')

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

y

User Responded with: Y

Backing up files...

Applying interim patch '33808367' to OH '/u01/app/oracle/product/19.0.0/dbhome_1'

Patching component oracle.javavm.server, 19.0.0.0.0...

Patching component oracle.javavm.server.core, 19.0.0.0.0...

Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...

Patching component oracle.rdbms, 19.0.0.0.0...

Patching component oracle.javavm.client, 19.0.0.0.0...

Patch 33808367 successfully applied.

Log file location: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-10-15_15-39-17PM_1.log

OPatch succeeded.

[oracle@localhost 33808367]$

Post-patching test:

  1. Start the Database

2. See the dba registry view, and run datapatch verbose.

SQL> select install_id, patch_id, patch_type, action, status, description from dba_registry_sqlpatch;

INSTALL_ID PATCH_ID PATCH_TYPE ACTION STATUS DESCRIPTION

---------- ---------- ---------- --------------- ------------------------- ------------------------------

1 29517242 RU APPLY SUCCESS Database Release Update : 19.3

.0.0.190416 (29517242)

3. Run datapatch verbose

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

SQL Patching tool version 19.15.0.0.0 Production on Thu Oct 15 15:49:13 2026

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

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

Connecting to database...OK

Gathering database info...done

Bootstrapping registry and package to current versions...done

Determining current state...done

Current state of interim SQL patches:

Interim patch 33808367 (OJVM RELEASE UPDATE: 19.15.0.0.220419 (33808367)):

Binary registry: Installed

SQL registry: Not installed

Current state of release update SQL patches:

Binary registry:

19.15.0.0.0 Release_Update 220331125408: Installed

SQL registry:

Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 02-OCT-26 06.36.20.419174 AM

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

Installation queue:

No interim patches need to be rolled back

Patch 33806152 (Database Release Update : 19.15.0.0.220419 (33806152)):

Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.15.0.0.0 Release_Update 220331125408

The following interim patches will be applied:

33808367 (OJVM RELEASE UPDATE: 19.15.0.0.220419 (33808367))

Installing patches...

.......................................(This is currently running)

See during running datapatch verbose a change can be noticed here.

SQL> select install_id, patch_id, patch_type, action, status, description from dba_registry_sqlpatch;

INSTALL_ID PATCH_ID PATCH_TYPE ACTION STATUS DESCRIPTION

---------- ---------- ---------- --------------- ------------------------- ------------------------------

1 29517242 RU APPLY SUCCESS Database Release Update : 19.3

.0.0.190416 (29517242)

2 33808367 INTERIM APPLY INITIALIZE OJVM RELEASE UPDATE: 19.15.0.0

.220419 (33808367)

SQL> Select patch_id, action, status, description, action time from dba_registry_sqlpatch order by action_time desc;

PATCH_ID ACTION STATUS DESCRIPTION TIME

---------- --------------- ------------------------- ------------------------------ ---------------

33808367 APPLY INITIALIZE OJVM RELEASE UPDATE: 19.15.0.0 APPLY

.220419 (33808367)

29517242 APPLY SUCCESS Database Release Update : 19.3 APPLY

This is the complete running of it,

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

SQL Patching tool version 19.15.0.0.0 Production on Fri Oct 16 16:16:35 2026

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

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

Connecting to database...OK

Gathering database info...done

Bootstrapping registry and package to current versions...done

Determining current state...done

Current state of interim SQL patches:

Interim patch 33808367 (OJVM RELEASE UPDATE: 19.15.0.0.220419 (33808367)):

Binary registry: Installed

SQL registry: Not installed

Current state of release update SQL patches:

Binary registry:

19.15.0.0.0 Release_Update 220331125408: Installed

SQL registry:

Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 02-OCT-26 06.36.20.419174 AM

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

Installation queue:

No interim patches need to be rolled back

Patch 33806152 (Database Release Update : 19.15.0.0.220419 (33806152)):

Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.15.0.0.0 Release_Update 220331125408

The following interim patches will be applied:

33808367 (OJVM RELEASE UPDATE: 19.15.0.0.220419 (33808367))

Installing patches...

Patch installation complete. Total patches installed: 2

Validating logfiles...done

Patch 33806152 apply: SUCCESS

logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33806152/24713297/33806152_apply_PROD_2026Oct16_16_27_02.log (no errors)

Patch 33808367 apply: SUCCESS

logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33808367/24680225/33808367_apply_PROD_2026Oct16_16_17_00.log (no errors)

SQL Patching tool complete on Fri Oct 16 16:41:14 2026

[oracle@localhost OPatch]$

Now the command.

SQL> Select patch_id, action, status, description, action time from dba_registry_sqlpatch order by action_time desc;

PATCH_ID ACTION STATUS DESCRIPTION TIME

---------- --------------- ------------------------- ------------------------------ ---------------

33808367 APPLY SUCCESS OJVM RELEASE UPDATE: 19.15.0.0 APPLY

.220419 (33808367)

33806152 APPLY SUCCESS Database Release Update : 19.1 APPLY

5.0.0.220419 (33806152)

29517242 APPLY SUCCESS Database Release Update : 19.3 APPLY

.0.0.190416 (29517242)

.0.0.190416 (29517242)

This parching was successful.

Clone this wiki locally