Oracledna

    Patching Oracle Database 19c

    • oracledna
    • Oracle Standalone Database
    • August 13, 2026

    This post demonstrates the patching of the Oracle Database from 19.27 to 19.30.

    Environment:
    ============
    DB Version: 19.27
    OS Version: OEL 9.4
    DB Type: Multitenant (CDB with two PDBs)
    Patching RU: 19.30

    1. Take the backup of database.

     

    It is recommended to take the full backup of Database.

    2. Take the backup of ORACLE HOME and inventory.


    [oracle@prod ~]$ cd /u01/app/oracle/product/19c

     

    [oracle@prod 19c]$ tar -pcvf /miss/oracle/db_home_bkp.tar db

     

     

    [oracle@prod ~]$ cat /etc/oraInst.loc
    inventory_loc=/u01/app/oraInventory
    inst_group=oinstall


    [oracle@prod ~]$ cd /u01/app/
    tar -pcvf /miss/oracle/OraInventory_Backup.tar oraInventory

    3. Upgrade the OPatch to latest version

    cd $ORACLE_HOME

    mv OPatch OPatch_old_date

    unzip p6880880_190000_Linux-x86-64

    cd OPatch

    [oracle@prod OPatch]$ ./opatch version
    OPatch Version: 12.2.0.1.52
    OPatch succeeded.

    4. Check Applied list of patches before patching.

    [oracle@prod ~]$ cd $ORACLE_HOME/OPatch

    [oracle@prod OPatch]$ ./opatch lspatches
    37642901;Database Release Update : 19.27.0.0.250415 (37642901)
    29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
    OPatch succeeded.

    5. Check Patch Conflict

    cd $ORACLE_HOME/OPatch

    [oracle@prod OPatch]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /miss/oracle/19.30/38632161
    Oracle Interim Patch Installer version 12.2.0.1.52
    Copyright (c) 2026, Oracle Corporation. All rights reserved.

    PREREQ session

    Oracle Home : /u01/app/oracle/product/19c/db
    Central Inventory : /u01/app/oraInventory
    from : /u01/app/oracle/product/19c/db/oraInst.loc
    OPatch version : 12.2.0.1.52
    OUI version : 12.2.0.7.0
    Log file location : /u01/app/oracle/product/19c/db/cfgtoollogs/opatch/opatch2026-08-12_04-56-16AM_1.log

    Invoking prereq “checkconflictagainstohwithdetail”

    Prereq “checkConflictAgainstOHWithDetail” passed.

    OPatch succeeded.

    6. Check System Space check

    [oracle@prod OPatch]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /miss/oracle/19.30/38632161
    Oracle Interim Patch Installer version 12.2.0.1.52
    Copyright (c) 2026, Oracle Corporation. All rights reserved.

    PREREQ session

    Oracle Home : /u01/app/oracle/product/19c/db
    Central Inventory : /u01/app/oraInventory
    from : /u01/app/oracle/product/19c/db/oraInst.loc
    OPatch version : 12.2.0.1.52
    OUI version : 12.2.0.7.0
    Log file location : /u01/app/oracle/product/19c/db/cfgtoollogs/opatch/opatch2026-08-12_04-58-54AM_1.log

    Invoking prereq “checksystemspace”

    Prereq “checkSystemSpace” passed.

    OPatch succeeded.

    7. Check the consistency of inventory information for database home

    [oracle@prod OPatch]$ /u01/app/oracle/product/19c/db/OPatch/opatch lsinventory -detail -oh /u01/app/oracle/product/19c/db
    Oracle Interim Patch Installer version 12.2.0.1.52
    Copyright (c) 2026, Oracle Corporation. All rights reserved.


    Oracle Home : /u01/app/oracle/product/19c/db
    Central Inventory : /u01/app/oraInventory
    from : /u01/app/oracle/product/19c/db/oraInst.loc
    OPatch version : 12.2.0.1.52
    OUI version : 12.2.0.7.0
    Log file location : /u01/app/oracle/product/19c/db/cfgtoollogs/opatch/opatch2026-08-12_05-05-23AM_1.log
    .
    .
    .
    .
    .
    .
    .
    Patch 29585399 : applied on Thu Apr 18 12:51:33 IST 2019
    Unique Patch ID: 22840393
    Patch description: “OCW RELEASE UPDATE 19.3.0.0.0 (29585399)”
    Created on 9 Apr 2019, 19:12:47 hrs PST8PDT
    Bugs fixed:
    27222128, 27572040, 27604329, 27760043, 27877830, 28302580, 28470673
    28621543, 28642469, 28699321, 28710663, 28755846, 28772816, 28785321
    28800508, 28808652, 28815557, 28847541, 28847572, 28870496, 28871040
    28874416, 28877252, 28881191, 28881848, 28888083, 28911140, 28925250
    28925460, 28935956, 28940472, 28942694, 28951332, 28963036, 28968779
    28980448, 28995287, 29003207, 29003617, 29016294, 29018680, 29024876
    29026154, 29027933, 29047127, 29052850, 29058476, 29111631, 29112455
    29117337, 29123444, 29125708, 29125786, 29129476, 29131772, 29132456
    29139727, 29146157, 29147849, 29149170, 29152603, 29152752, 29154631
    29154636, 29154829, 29159216, 29159661, 29160462, 29161923, 29169540
    29169739, 29170717, 29173618, 29181568, 29182920, 29183298, 29186091
    29191827, 29201143, 29201695, 29209545, 29210577, 29210610, 29210624
    29210683, 29213641, 29219627, 29224294, 29225861, 29229839, 29235934
    29242906, 29243749, 29244495, 29244766, 29244968, 29248723, 29249583
    29251564, 29255616, 29260224, 29261695, 29271019, 29273360, 29282090
    29282666, 29285453, 29285621, 29290235, 29292232, 29293806, 29294753
    29299830, 29307090, 29307109, 29311336, 29329675, 29330791, 29339299
    29357821, 29360467, 29360775, 29367971, 29368725, 29379299, 29379381
    29380527, 29381000, 29382296, 29391301, 29393649, 29402110, 29411931
    29413360, 29457319, 29465047, 3
    Files Touched:
    clustdb.sql –> ORACLE_HOME/srvm/admin/clustdb.sql
    Patch Location in Inventory:
    /u01/app/oracle/product/19c/db/inventory/oneoffs/29585399
    Patch Location in Storage area:
    /u01/app/oracle/product/19c/db/.patch_storage/29585399_Apr_9_2019_19_12_47


    OPatch succeeded.

    8. Stop the listener and database.

    [oracle@prod ~]$ lsnrctl stop LISTENER_PROD
    LSNRCTL for Linux: Version 19.0.0.0.0 – Production on 12-AUG-2026 05:08:24
    Copyright (c) 1991, 2025, Oracle. All rights reserved.
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=prod)(PORT=1521)))
    The command completed successfully


    SQL> shut immediate
    Database closed.
    Database dismounted.
    ORACLE instance shut down.

    9. Apply the RU patch.

    [oracle@prod ~]$ $ORACLE_HOME/OPatch/opatch apply -oh /u01/app/oracle/product/19c/db -local /miss/oracle/19.30/38632161
    Oracle Interim Patch Installer version 12.2.0.1.52
    Copyright (c) 2026, Oracle Corporation. All rights reserved.


    Oracle Home : /u01/app/oracle/product/19c/db
    Central Inventory : /u01/app/oraInventory
    from : /u01/app/oracle/product/19c/db/oraInst.loc
    OPatch version : 12.2.0.1.52
    OUI version : 12.2.0.7.0
    Log file location : /u01/app/oracle/product/19c/db/cfgtoollogs/opatch/opatch2026-08-12_05-10-41AM_1.log

    Verifying environment and performing prerequisite checks…
    OPatch continues with these patches: 38632161

    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/19c/db’)


    Is the local system ready for patching? [y|n]
    y
    User Responded with: Y
    Backing up files…
    Applying interim patch ‘38632161’ to OH ‘/u01/app/oracle/product/19c/db’
    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.datamining, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.pg4mq, 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.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.network.cman, 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.xdk.companion, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.ldap.ztk, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 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, 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.sqlj.sqljruntime, 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.xdk.parser.java, 19.0.0.0.0…

    Patching component oracle.rdbms.lbac, 19.0.0.0.0…

    Patching component oracle.ldap.ssl, 19.0.0.0.0…

    Patching component oracle.network.aso, 19.0.0.0.0…

    Patching component oracle.xdk, 19.0.0.0.0…

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

    Patching component oracle.odbc, 19.0.0.0.0…

    Patching component oracle.rdbms.rat, 19.0.0.0.0…

    Patching component oracle.rdbms.dv, 19.0.0.0.0…

    Patching component oracle.oraolap.dbscripts, 19.0.0.0.0…

    Patching component oracle.rdbms.hs_common, 19.0.0.0.0…

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

    Patching component oracle.oraolap, 19.0.0.0.0…

    Patching component oracle.install.deinstalltool, 19.0.0.0.0…

    Patching component oracle.mgw.common, 19.0.0.0.0…

    Patching component oracle.rdbms.rman, 19.0.0.0.0…

    Patching component oracle.xdk.server, 19.0.0.0.0…

    Patching component oracle.oraolap.api, 19.0.0.0.0…

    Patching component oracle.rdbms.hsodbc, 19.0.0.0.0…

    Patching component oracle.ctx.atg, 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.wwg.plsql, 19.0.0.0.0…

    Patching component oracle.network.client, 19.0.0.0.0…

    Patching component oracle.dbtoolslistener, 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.nlsrtl.rsf.lbuilder, 19.0.0.0.0…

    Patching component oracle.rdbms.drdaas, 19.0.0.0.0…

    Patching component oracle.sdo.locator, 19.0.0.0.0…

    Patching component oracle.rdbms.locator, 19.0.0.0.0…

    Patching component oracle.network.listener, 19.0.0.0.0…

    Patching component oracle.ovm, 19.0.0.0.0…

    Patching component oracle.javavm.server, 19.0.0.0.0…

    Patching component oracle.xdk.xquery, 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 38632161 successfully applied.
    Sub-set patch [37642901] has become inactive due to the application of a super-set patch [38632161].
    Please refer to Doc ID 2161861.1 for any possible further required actions.
    Log file location: /u01/app/oracle/product/19c/db/cfgtoollogs/opatch/opatch2026-08-12_05-10-41AM_1.log

    OPatch succeeded.


    —

    [oracle@prod ~]$ sqlplus -V
    SQL*Plus: Release 19.0.0.0.0 – Production
    Version 19.30.0.0.0

    10. Start the listener and database.


    [oracle@prod ~]$ lsnrctl start LISTENER_PROD
    LSNRCTL for Linux: Version 19.0.0.0.0 – Production on 12-AUG-2026 05:21:50
    Copyright (c) 1991, 2025, Oracle. All rights reserved.
    Starting /u01/app/oracle/product/19c/db/bin/tnslsnr: please wait…
    TNSLSNR for Linux: Version 19.0.0.0.0 – Production
    System parameter file is /u01/app/oracle/product/19c/db/network/admin/listener.ora
    Log messages written to /u01/app/oracle/diag/tnslsnr/prod/listener_prod/alert/log.xml
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prod)(PORT=1521)))
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=prod)(PORT=1521)))
    STATUS of the LISTENER
    ————————
    Alias LISTENER_PROD
    Version TNSLSNR for Linux: Version 19.0.0.0.0 – Production
    Start Date 12-AUG-2026 05:21:50
    Uptime 0 days 0 hr. 0 min. 0 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File /u01/app/oracle/product/19c/db/network/admin/listener.ora
    Listener Log File /u01/app/oracle/diag/tnslsnr/prod/listener_prod/alert/log.xml
    Listening Endpoints Summary…
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prod)(PORT=1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
    The listener supports no services
    The command completed successfully

     

    [oracle@prod ~]$ sqlplus / as sysdba
    SQL*Plus: Release 19.0.0.0.0 – Production on Wed Aug 12 05:22:13 2026
    Version 19.30.0.0.0
    Copyright (c) 1982, 2025, Oracle. All rights reserved.
    Connected to an idle instance.


    SQL> show pdbs
    CON_ID CON_NAME OPEN MODE RESTRICTED
    ———- —————————— ———- ———-
    2 PDB$SEED READ ONLY NO
    3 PRODPDB1 MOUNTED
    4 PRODPDB2 MOUNTED


    SQL> alter pluggable database all open;
    Pluggable database altered.


    SQL> show pdbs
    CON_ID CON_NAME OPEN MODE RESTRICTED
    ———- —————————— ———- ———-
    2 PDB$SEED READ ONLY NO
    3 PRODPDB1 READ WRITE NO
    4 PRODPDB2 READ WRITE NO


    Note: For multitenant database, make sure to open all pluggable databases before running the datapatch.

    11. Run the datapatch

    [oracle@prod ~]$ cd $ORACLE_HOME/OPatch


    [oracle@prod OPatch]$ ./datapatch -verbose
    SQL Patching tool version 19.30.0.0.0 Production on Wed Aug 12 05:24:13 2026
    Copyright (c) 2012, 2026, Oracle. All rights reserved.

    Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_29498_2026_08_12_05_24_13/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.30.0.0.0 Release_Update 260126024251: Installed
    PDB CDB$ROOT:
    Applied 19.27.0.0.0 Release_Update 250406131139 successfully on 06-08-26 4:55:04.636024 PM
    PDB PDB$SEED:
    Applied 19.27.0.0.0 Release_Update 250406131139 successfully on 06-08-26 5:10:30.369773 PM
    PDB PRODPDB1:
    Applied 19.27.0.0.0 Release_Update 250406131139 successfully on 06-08-26 5:10:30.369773 PM
    PDB PRODPDB2:
    Applied 19.27.0.0.0 Release_Update 250406131139 successfully on 06-08-26 5:10:30.369773 PM

    Adding patches to installation queue and performing prereq checks…done
    Installation queue:
    For the following PDBs: CDB$ROOT PDB$SEED PRODPDB1 PRODPDB2
    No interim patches need to be rolled back
    Patch 38632161 (Database Release Update : 19.30.0.0.260120(REL-JAN260130) (38632161)):
    Apply from 19.27.0.0.0 Release_Update 250406131139 to 19.30.0.0.0 Release_Update 260126024251
    No interim patches need to be applied

    Installing patches…
    Patch installation complete. Total patches installed: 4

    Validating logfiles…done
    Patch 38632161 apply (pdb CDB$ROOT): SUCCESS
    logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/38632161/28482211/38632161_apply_PROD_CDBROOT_2026Aug12_05_26_30.log (no errors)
    Patch 38632161 apply (pdb PDB$SEED): SUCCESS
    logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/38632161/28482211/38632161_apply_PROD_PDBSEED_2026Aug12_05_29_07.log (no errors)
    Patch 38632161 apply (pdb PRODPDB1): SUCCESS
    logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/38632161/28482211/38632161_apply_PROD_PRODPDB1_2026Aug12_05_29_07.log (no errors)
    Patch 38632161 apply (pdb PRODPDB2): SUCCESS
    logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/38632161/28482211/38632161_apply_PROD_PRODPDB2_2026Aug12_05_29_07.log (no errors)
    SQL Patching tool complete on Wed Aug 12 05:33:53 2026

    12. Verify applied patches list dba_registry_sqlpatch.


    SQL> SET LINESIZE 200
    COL action_time FOR A30
    COL status FOR A15
    COL description FOR A50
    select patch_id,patch_uid,action,status,action_time,description from dba_registry_sqlpatch order by action_time;

    PATCH_ID PATCH_UID ACTION STATUS ACTION_TIME DESCRIPTION
    ———- ———- ————— ————— —————————— ————————————————–
    37642901 27123174 APPLY SUCCESS 06-08-26 4:55:04.636024 PM Database Release Update : 19.27.0.0.250415 (376429
    01)

    38632161 28482211 APPLY SUCCESS 12-08-26 5:28:38.687966 AM Database Release Update : 19.30.0.0.260120(REL-JAN
    260130) (38632161)

     

    SQL> set linesize 300
    col VERSION for a10
    col ACTION for a26
    col NAMESPACE for a15
    col COMMENTS for a47
    col ACTION_TIME for a30
    select ACTION_TIME, ACTION, NAMESPACE, VERSION, COMMENTS from dba_registry_history;

    ACTION_TIME ACTION NAMESPACE VERSION COMMENTS
    —————————— ————————– ————— ———- ———————————————–
    BOOTSTRAP DATAPATCH 19 RDBMS_19.30.0.0.0DBRU_LINUX.X64_260125
    06-08-26 4:55:04.656404 PM RU_APPLY SERVER 19.0.0.0.0 Patch applied from 19.3.0.0.0 to 19.27.0.0.0: R
    elease_Update – 250406131139

    12-08-26 5:28:38.717759 AM RU_APPLY SERVER 19.0.0.0.0 Patch applied from 19.27.0.0.0 to 19.30.0.0.0:
    Release_Update – 260126024251

    13. Check the applied patches post patching.

    [oracle@prod OPatch]$ cd $ORACLE_HOME/OPatch


    [oracle@prod OPatch]$ ./opatch lspatches
    38632161;Database Release Update : 19.30.0.0.260120(REL-JAN260130) (38632161)
    29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
    OPatch succeeded.

    —

    $ORACLE_HOME/OPatch/opatch lsinventory

    14. Check the dba_registry status.


    SQL> set lines 1234 pages 1234
    SET LINESIZE 200
    COL comp_name FOR A40
    COL version FOR A15
    COL status FOR A15
    COL schema FOR A20

    SELECT comp_id,comp_name,version,status,schema FROM dba_registry ORDER BY comp_name;

    COMP_ID COMP_NAME VERSION STATUS SCHEMA
    —————————— —————————————- ————— ————— ——————–
    JAVAVM JServer JAVA Virtual Machine 19.0.0.0.0 VALID SYS
    APS OLAP Analytic Workspace 19.0.0.0.0 VALID SYS
    CATALOG Oracle Database Catalog Views 19.0.0.0.0 VALID SYS
    CATJAVA Oracle Database Java Packages 19.0.0.0.0 VALID SYS
    CATPROC Oracle Database Packages and Types 19.0.0.0.0 VALID SYS
    DV Oracle Database Vault 19.0.0.0.0 VALID DVSYS
    OLS Oracle Label Security 19.0.0.0.0 VALID LBACSYS
    ORDIM Oracle Multimedia 19.0.0.0.0 VALID ORDSYS
    XOQ Oracle OLAP API 19.0.0.0.0 VALID OLAPSYS
    RAC Oracle Real Application Clusters 19.0.0.0.0 OPTION OFF SYS
    CONTEXT Oracle Text 19.0.0.0.0 VALID CTXSYS
    OWM Oracle Workspace Manager 19.0.0.0.0 VALID WMSYS
    XML Oracle XDK 19.0.0.0.0 VALID SYS
    XDB Oracle XML Database 19.0.0.0.0 VALID XDB
    SDO Spatial 19.0.0.0.0 VALID MDSYS

    15 rows selected.

    Disclaimer:

    Please note the above information is only for educational purpose and practised in personal test database only. Always test in test database before implementing in production database. The pre-requisites and ways of implementing may vary from one environment to another. Hence, not providing guarantee that it will work in your environment.

    Popular Posts
    Categories