Anuj Singh Oracle DBA: 5 Jan 2026

Monday, 5 January 2026

Oracle database Patch 38291812 - Database Release Update 19.29.0.0




Oracle database Patch 38291812 - Database Release Update 19.29.0.0


/home/oracle/38291812

38291812


export PATH=$ORACLE_HOME/OPatch:$PATH

[oracle@ora19 38291812]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.48
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.48
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-01-05_10-09-20AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@ora19 38291812]$ pwd
/home/oracle/38291812



===========

[oracle@ora19 38291812]$ opatch prereq CheckSystemSpace -ph ./
Oracle Interim Patch Installer version 12.2.0.1.48
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.48
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-01-05_10-32-06AM_1.log

Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.

OPatch succeeded.
[oracle@ora19 38291812]$


******************
[oracle@ora19 38291812]$ pwd
/home/oracle/38291812
[oracle@ora19 38291812]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.48
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.48
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-01-05_11-47-26AM_1.log

Verifying environment and performing prerequisite checks...

--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...

Oracle Interim Patch Installer version 12.2.0.1.48
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.48
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-01-05_11-49-40AM_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
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...
y

Applying interim patch '38291812' to OH '/u01/app/oracle/product/19.0.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.crypto.rsf, 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.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 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.pg4mq, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.java.sqlj.sqljruntime, 19.0.0.0.0 ] , [ oracle.datamining, 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.net.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, 19.0.0.0.0...

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.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.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.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.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.common.core, 19.0.0.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.dbscripts, 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.oci, 19.0.0.0.0...

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

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

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

Patching component oracle.rsf, 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.tfa.db, 19.0.0.0.0...

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

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

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

Patching component oracle.network.aso, 19.0.0.0.0...

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

Patching component oracle.ovm, 19.0.0.0.0...

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

Patching component oracle.ctx.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.xdk.xquery, 19.0.0.0.0...

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

Patching component oracle.oraolap, 19.0.0.0.0...

Patching component oracle.xdk.server, 19.0.0.0.0...

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

Patching component oracle.odbc, 19.0.0.0.0...

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

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

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

Patching component oracle.rdbms.rat, 19.0.0.0.0...

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

Patching component oracle.dbtoolslistener, 19.0.0.0.0...

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

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

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

Patching component oracle.xdk, 19.0.0.0.0...

Patching component oracle.rdbms.dm, 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.sqlj.sqljruntime, 19.0.0.0.0...

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

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

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

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

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

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

Patching component oracle.rdbms.hs_common, 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 38291812 successfully applied.
Sub-set patch [37960098] has become inactive due to the application of a super-set patch [38291812].
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-01-05_11-49-40AM_1.log

OPatch succeeded.
[oracle@ora19 38291812]$ y
bash: y: command not found...
[oracle@ora19 38291812]$


*****************************************************************************************************

[oracle@ora19 38291812]$ sqlme

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jan 5 12:02:56 2026
Version 19.29.0.0.0

Copyright (c) 1982, 2025, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup ;
ORACLE instance started.

Total System Global Area  910160856 bytes
Fixed Size                  9184216 bytes
Variable Size             578813952 bytes
Database Buffers          314572800 bytes
Redo Buffers                7589888 bytes
Database mounted.
Database opened.
SQL>  alter pluggable database all open;

Pluggable database altered.

SQL>


SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 VIHAAN27                       READ WRITE NO
SQL>


 cd $ORACLE_HOME/OPatch

[oracle@ora19 OPatch]$ pwd
/u01/app/oracle/product/19.0.0/dbhome_1/OPatch
[oracle@ora19 OPatch]$


[oracle@ora19 OPatch]$ ls -ltr data*
-rwxr-x--- 1 oracle oinstall 589 Oct  7 15:11 datapatch
[oracle@ora19 OPatch]$ ./datapatch -sanity_checks
SQL Patching sanity checks version 19.29.0.0.0 on Mon 05 Jan 2026 12:07:36 GMT
Copyright (c) 2021, 2026, Oracle.  All rights reserved.

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

Running checks
JSON report generated in /u01/app/oracle/cfgtoollogs/sqlpatch/sanity_checks_20260105_120736_9801/sqlpatch_sanity_checks_summary.json file
Checks completed. Printing report:

Check: Database component status - INFO
  There should be no INVALID components prior patching due to risk of potential errors.
  Listed components have a non-valid status.
  For INVALID components: Run '?/rdbms/admin/utlrp.sql' (per container) to try recompiling invalid objects and restore component status.
  For other non-valid status, depending on patch content warnings may be returned.
  VIHAAN27:
    | COMPONENT | STATUS  |
    |-----------+---------|
    |    SDO    | LOADING |
    |-----------+---------|
Check: PDB Violations - OK
Check: Invalid System Objects - OK
Check: Tablespace Status - ERROR
  Temp tablespaces must have sufficient space for patching. Minimum recommended space is 2GB.
  Tablespace is above 80% of used space or it has less than 2GB of space left.
  Ensure there is adequate tablespace for patching. Note suggested quantities are an estimated minimum size value, it is strongly recommended to adjust the data file maximum size as needed based on testing. Refer to the section "Managing Data Files and Temp Files" in the Oracle Database Administrator's Guide for details on managing data file operations.
  VIHAAN27:
    | TABLESPACE_NAME  | AUTO_EXTENSIBLE | TABLESPACE_SIZE | FREE_TABLESPACE | USAGE |
    |------------------+-----------------+-----------------+-----------------+-------|
    | ODITEST_ODI_TEMP |       YES       |      1000       |       999       |  .1   |
    |------------------+-----------------+-----------------+-----------------+-------|
Check: Backup jobs - OK
Check: Temp file exists - OK
Check: Temp file online - OK
Check: Data Pump running - OK
Check: Container status - OK
Check: Oracle Database Keystore - OK
Check: Dictionary statistics gathering - WARNING
  Patching the database without recent data dictionary statistics gathered may lead to performance issues.
  Data dictionary statistics are older than 7 days.
  Run the following queries to start gathering the dictionary statistics:
    EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;
    EXEC DBMS_SYSTEM.GATHER_FIXED_OBJECTS_STATS;
  Refer to MOS 457926.1 for more details.
  PDB$SEED:
    |     LATEST      |        OPERATION        |  STATUS   |
    |-----------------+-------------------------+-----------|
    | 25-JUN-25 10:56 | gather_dictionary_stats | COMPLETED |
    |-----------------+-------------------------+-----------|
Check: Scheduled Jobs - OK
Check: GoldenGate triggers - OK
Check: Logminer DDL triggers - OK
Check: Check sys public grants - OK
Check: Statistics gathering running - OK
Check: Optim dictionary upgrade parameter - OK
Check: Symlinks on oracle home path - OK
Check: Central Inventory - OK
Check: Java Virtual Machine Enable - OK
Check: Oracle Database Vault Enabled - OK
Check: Queryable Inventory database directories - OK
Check: Queryable Inventory locks - OK
Check: Queryable Inventory package - OK
Check: Queryable Inventory external table - OK
Check: Imperva processes - OK
Check: Guardium processes - OK
Check: Locale - OK

Refer to MOS Note 2975965.1 and debug log
/u01/app/oracle/cfgtoollogs/sqlpatch/sanity_checks_20260105_120736_9801/sanity_checks_debug_20260105_120736_9801.log

SQL Patching sanity checks completed on Mon 05 Jan 2026 12:07:42 GMT
[oracle@ora19 OPatch]$


**************************************************


[oracle@ora19 OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.29.0.0.0 Production on Mon Jan  5 12:08:29 2026
Copyright (c) 2012, 2025, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_9824_2026_01_05_12_08_29/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.29.0.0.0 Release_Update 251002005342: Installed
  PDB CDB$ROOT:
    Applied 19.28.0.0.0 Release_Update 250705030417 successfully on 04-JAN-26 17.28.02.803708
  PDB PDB$SEED:
    Applied 19.28.0.0.0 Release_Update 250705030417 successfully on 04-JAN-26 17.33.02.268396
  PDB VIHAAN27:
    Applied 19.28.0.0.0 Release_Update 250705030417 successfully on 04-JAN-26 17.32.54.258125

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED VIHAAN27
    No interim patches need to be rolled back
    Patch 38291812 (Database Release Update : 19.29.0.0.251021 (38291812)):
      Apply from 19.28.0.0.0 Release_Update 250705030417 to 19.29.0.0.0 Release_Update 251002005342
    No interim patches need to be applied

Installing patches...
Patch installation complete.  Total patches installed: 3

Validating logfiles...done
Patch 38291812 apply (pdb CDB$ROOT): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/38291812/28130960/38291812_apply_VIHAAN_CDBROOT_2026Jan05_12_11_57.log (no errors)
Patch 38291812 apply (pdb PDB$SEED): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/38291812/28130960/38291812_apply_VIHAAN_PDBSEED_2026Jan05_12_13_00.log (no errors)
Patch 38291812 apply (pdb VIHAAN27): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/38291812/28130960/38291812_apply_VIHAAN_VIHAAN27_2026Jan05_12_13_00.log (no errors)
SQL Patching tool complete on Mon Jan  5 12:13:50 2026

[oracle@ora19 OPatch]$



 sqlme

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jan 5 12:22:48 2026
Version 19.29.0.0.0

Copyright (c) 1982, 2025, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.29.0.0.0  <<<<<<





set lines 132  verify  off head off  feedback on  long 1000
select distinct
'======================================================'	||chr(10)||
'INSTALL ID.................: '||INSTALL_ID 			||Chr(10)||
'PATCH_ID...................: '||PATCH_ID 			||Chr(10)||
'PATCH UID..................: '||PATCH_UID   			||Chr(10)||
'PATCH TYPE.................: '||PATCH_TYPE  			||Chr(10)||
'ACTION.....................: '||ACTION   			||Chr(10)||
'STATUS.....................: '||STATUS   			||Chr(10)||
'ACTION TIME................: '||ACTION_TIME    		||Chr(10)||
'DESCRIPTION................: '||DESCRIPTION    		||Chr(10)||
'FLAGS......................: '||FLAGS   			||Chr(10)||
'SOURCE VERSION.............: '||SOURCE_VERSION 		||Chr(10)||
'SOURCE BUILD_DESCRIPTION...: '||SOURCE_BUILD_DESCRIPTION    	||Chr(10)||
'SOURCE BUILD_TIMESTAMP.....: '||SOURCE_BUILD_TIMESTAMP  	||Chr(10)||
'TARGET VERSION.............: '||TARGET_VERSION   	 	||Chr(10)||
'TARGET BUILD DESCRIPTION...: '||TARGET_BUILD_DESCRIPTION    	||Chr(10)||
'TARGET BUILD TIMESTAMP.....: '||TARGET_BUILD_TIMESTAMP         ||Chr(10)
--'LOGFILE....................: '||LOGFILE  			||Chr(10)||
--'RU LOGFILE.................: '||RU_LOGFILE   		||Chr(10)
from dba_registry_sqlpatch  
order by 1




======================================================
INSTALL ID.................: 1
PATCH_ID...................: 37642901
PATCH UID..................: 27123174
PATCH TYPE.................: RU
ACTION.....................: APPLY
STATUS.....................: SUCCESS
ACTION TIME................: 14-JUN-25 11.00.09.198524
DESCRIPTION................: Database Release Update : 19.27.0.0.250415 (37642901)
FLAGS......................: N
SOURCE VERSION.............: 19.1.0.0.0
SOURCE BUILD_DESCRIPTION...: Feature Release
SOURCE BUILD_TIMESTAMP.....:

TARGET VERSION.............: 19.27.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 06-APR-25 13.11.39.000000

======================================================
INSTALL ID.................: 2
PATCH_ID...................: 37960098
PATCH UID..................: 27635722
PATCH TYPE.................: RU
ACTION.....................: APPLY
STATUS.....................: SUCCESS
ACTION TIME................: 04-JAN-26 17.28.02.803708
DESCRIPTION................: Database Release Update : 19.28.0.0.250715 (37960098)

FLAGS......................: N
SOURCE VERSION.............: 19.27.0.0.0
SOURCE BUILD_DESCRIPTION...: Release_Update
SOURCE BUILD_TIMESTAMP.....: 06-APR-25 13.11.39.000000
TARGET VERSION.............: 19.28.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 05-JUL-25 03.04.17.000000

======================================================
INSTALL ID.................: 3
PATCH_ID...................: 38291812
PATCH UID..................: 28130960
PATCH TYPE.................: RU

ACTION.....................: APPLY
STATUS.....................: SUCCESS
ACTION TIME................: 05-JAN-26 12.12.44.490435
DESCRIPTION................: Database Release Update : 19.29.0.0.251021 (38291812)
FLAGS......................: N
SOURCE VERSION.............: 19.28.0.0.0
SOURCE BUILD_DESCRIPTION...: Release_Update
SOURCE BUILD_TIMESTAMP.....: 05-JUL-25 03.04.17.000000
TARGET VERSION.............: 19.29.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 02-OCT-25 00.53.42.000000


3 rows selected.



set lines 132  verify  off head off  feedback on  long 1000
select distinct
'======================================================'	||chr(10)||
'INSTALL ID.................: '||INSTALL_ID 			||Chr(10)||
'PATCH_ID...................: '||PATCH_ID 			||Chr(10)||
'PATCH UID..................: '||PATCH_UID   			||Chr(10)||
'PATCH TYPE.................: '||PATCH_TYPE  			||Chr(10)||
'ACTION.....................: '||ACTION   			||Chr(10)||
'STATUS.....................: '||STATUS   			||Chr(10)||
'ACTION TIME................: '||ACTION_TIME    		||Chr(10)||
'DESCRIPTION................: '||DESCRIPTION    		||Chr(10)||
'FLAGS......................: '||FLAGS   			||Chr(10)||
'SOURCE VERSION.............: '||SOURCE_VERSION 		||Chr(10)||
'SOURCE BUILD_DESCRIPTION...: '||SOURCE_BUILD_DESCRIPTION    	||Chr(10)||
'SOURCE BUILD_TIMESTAMP.....: '||SOURCE_BUILD_TIMESTAMP  	||Chr(10)||
'TARGET VERSION.............: '||TARGET_VERSION   	 	||Chr(10)||
'TARGET BUILD DESCRIPTION...: '||TARGET_BUILD_DESCRIPTION    	||Chr(10)||
'TARGET BUILD TIMESTAMP.....: '||TARGET_BUILD_TIMESTAMP         ||Chr(10)||
'CON_ID.....................: '||CON_ID
--'LOGFILE....................: '||LOGFILE  			||Chr(10)||
--'RU LOGFILE.................: '||RU_LOGFILE   		||Chr(10)
from cdb_registry_sqlpatch
 order by 1



======================================================
INSTALL ID.................: 1
PATCH_ID...................: 37642901
PATCH UID..................: 27123174
PATCH TYPE.................: RU
ACTION.....................: APPLY
STATUS.....................: SUCCESS
ACTION TIME................: 14-JUN-25 11.00.09.198524
DESCRIPTION................: Database Release Update : 19.27.0.0.250415 (37642901)
FLAGS......................: N
SOURCE VERSION.............: 19.1.0.0.0
SOURCE BUILD_DESCRIPTION...: Feature Release
SOURCE BUILD_TIMESTAMP.....:

TARGET VERSION.............: 19.27.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 06-APR-25 13.11.39.000000
CON_ID.....................: 1

======================================================
INSTALL ID.................: 1
PATCH_ID...................: 37642901
PATCH UID..................: 27123174
PATCH TYPE.................: RU
ACTION.....................: APPLY
STATUS.....................: WITH ERRORS
ACTION TIME................: 14-JUN-25 11.05.28.279212

DESCRIPTION................: Database Release Update : 19.27.0.0.250415 (37642901)
FLAGS......................: N
SOURCE VERSION.............: 19.1.0.0.0
SOURCE BUILD_DESCRIPTION...: Feature Release
SOURCE BUILD_TIMESTAMP.....:
TARGET VERSION.............: 19.27.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 06-APR-25 13.11.39.000000
CON_ID.....................: 3

======================================================
INSTALL ID.................: 2
PATCH_ID...................: 37642901

PATCH UID..................: 27123174
PATCH TYPE.................: RU
ACTION.....................: APPLY
STATUS.....................: SUCCESS
ACTION TIME................: 25-JUN-25 11.12.32.980376
DESCRIPTION................: Database Release Update : 19.27.0.0.250415 (37642901)
FLAGS......................: N
SOURCE VERSION.............: 19.1.0.0.0
SOURCE BUILD_DESCRIPTION...: Feature Release
SOURCE BUILD_TIMESTAMP.....:
TARGET VERSION.............: 19.27.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 06-APR-25 13.11.39.000000

CON_ID.....................: 3

======================================================
INSTALL ID.................: 2
PATCH_ID...................: 37960098
PATCH UID..................: 27635722
PATCH TYPE.................: RU
ACTION.....................: APPLY
STATUS.....................: SUCCESS
ACTION TIME................: 04-JAN-26 17.28.02.803708
DESCRIPTION................: Database Release Update : 19.28.0.0.250715 (37960098)
FLAGS......................: N
SOURCE VERSION.............: 19.27.0.0.0

SOURCE BUILD_DESCRIPTION...: Release_Update
SOURCE BUILD_TIMESTAMP.....: 06-APR-25 13.11.39.000000
TARGET VERSION.............: 19.28.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 05-JUL-25 03.04.17.000000
CON_ID.....................: 1

======================================================
INSTALL ID.................: 3
PATCH_ID...................: 37960098
PATCH UID..................: 27635722
PATCH TYPE.................: RU
ACTION.....................: APPLY

STATUS.....................: SUCCESS
ACTION TIME................: 04-JAN-26 17.32.54.258125
DESCRIPTION................: Database Release Update : 19.28.0.0.250715 (37960098)
FLAGS......................: N
SOURCE VERSION.............: 19.27.0.0.0
SOURCE BUILD_DESCRIPTION...: Release_Update
SOURCE BUILD_TIMESTAMP.....: 06-APR-25 13.11.39.000000
TARGET VERSION.............: 19.28.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 05-JUL-25 03.04.17.000000
CON_ID.....................: 3

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

INSTALL ID.................: 3
PATCH_ID...................: 38291812
PATCH UID..................: 28130960
PATCH TYPE.................: RU
ACTION.....................: APPLY
STATUS.....................: SUCCESS
ACTION TIME................: 05-JAN-26 12.12.44.490435
DESCRIPTION................: Database Release Update : 19.29.0.0.251021 (38291812)
FLAGS......................: N
SOURCE VERSION.............: 19.28.0.0.0
SOURCE BUILD_DESCRIPTION...: Release_Update
SOURCE BUILD_TIMESTAMP.....: 05-JUL-25 03.04.17.000000
TARGET VERSION.............: 19.29.0.0.0

TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 02-OCT-25 00.53.42.000000
CON_ID.....................: 1

======================================================
INSTALL ID.................: 4
PATCH_ID...................: 38291812
PATCH UID..................: 28130960
PATCH TYPE.................: RU
ACTION.....................: APPLY
STATUS.....................: SUCCESS
ACTION TIME................: 05-JAN-26 12.13.29.590889
DESCRIPTION................: Database Release Update : 19.29.0.0.251021 (38291812)

FLAGS......................: N
SOURCE VERSION.............: 19.28.0.0.0
SOURCE BUILD_DESCRIPTION...: Release_Update
SOURCE BUILD_TIMESTAMP.....: 05-JUL-25 03.04.17.000000
TARGET VERSION.............: 19.29.0.0.0
TARGET BUILD DESCRIPTION...: Release_Update
TARGET BUILD TIMESTAMP.....: 02-OCT-25 00.53.42.000000
CON_ID.....................: 3


7 rows selected.
Anuj Singh Oracle DBA

Search This Blog

Total Pageviews

Monday, 5 January 2026

Oracle database Patch 38291812 - Database Release Update 19.29.0.0

Oracle DBA

anuj blog Archive
