Patching Oracle Database 19C Release Update on April 2024 19.23 (p36233263) on Single Instance Database
Posted by Mir Sayeed Hassan on May 29th, 2024
Patching Oracle Database 19C Release Update on April 2024 19.23 (p36233263) on Single Instance Database
Check the status of Database
SQL> select instance_name, version, open_mode from V$database, v$instance; INSTANCE_NAME VERSION OPEN_MODE ---------------- ------------------------ peptestdb 19.0.0.0.0 READ WRITE
Verify the lastest OPatch applied on it., If not use the below link to apply
Download the Patch from below link
https://support.oracle.com/epmos/faces/PatchSearchResults?_adf.ctrl-state=ym4c1dobw_120&_afrLoop=189225645173189
Apply the Opatch
https://www.mirsayeedhassan.com/apply-the-latest-optach-12-2-0-1-42-on-19c-database/
Verify the OPatch applied
[oracle@peptestdb OPatch]$ cd $ORACLE_HOME/OPatch [oracle@peptestdb OPatch]$ ./opatch version OPatch Version: 12.2.0.1.42 OPatch succeeded.
Create a directory & place the downloaded DB Patch into it.
[oracle@peptestdb ~]$ cd /u02/source/PATCH_19C_19.23/DB_RU_19.23.0.0.0_16-APR-2024/
[oracle@peptestdb DB_RU_19.23.0.0.0_16-APR-2024]$ ls p36233263_190000_Linux-x86-64.zip
[oracle@peptestdb DB_RU_19.23.0.0.0_16-APR-2024]$ ll total 1812808 -rwxrwxrwx. 1 oracle oinstall 1856311021 May 27 11:48 p36233263_190000_Linux-x86-64.zip
[oracle@peptestdb DB_RU_19.23.0.0.0_16-APR-2024]$ unzip p36233263_190000_Linux-x86-64.zip
[oracle@peptestdb DB_RU_19.23.0.0.0_16-APR-2024]$ ll total 1814688 drwxr-xr-x. 5 oracle oinstall 4096 Apr 10 21:15 36233263 -rwxrwxrwx. 1 oracle oinstall 1856311021 May 27 11:48 p36233263_190000_Linux-x86-64.zip -rw-rw-r--. 1 oracle oinstall 1920064 Apr 16 17:39 PatchSearch.xml
[oracle@peptestdb DB_RU_19.23.0.0.0_16-APR-2024]$ cd 36233263/ [oracle@peptestdb 36233263]$ ls custom etc files README.html README.txt
Verify the Patch Conflict.
[oracle@peptestdb 36233263]$ /u01/app/oracle/product/19c/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 12.2.0.1.42 Copyright (c) 2024, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/19c/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19c/db_1/oraInst.loc OPatch version : 12.2.0.1.42 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2024-05-27_12-50-34PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.
Check the patches applied until now.
[oracle@peptestdb 36233263]$ $ORACLE_HOME/OPatch/opatch lspatches 35943157;Database Release Update : 19.22.0.0.240116 (35943157) 29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399) OPatch succeeded.
Shutdown database & listener
[oracle@peptestdb 36233263]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 27 13:53:50 2024 Version 19.22.0.0.0 Copyright (c) 1982, 2023, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.22.0.0.0 SQL> shu immediate Database closed. Database dismounted. ORACLE instance shut down.
[oracle@peptestdb 36233263]$ lsnrctl stop
Start Apply the Patch
[oracle@peptestdb 36233263]$ /u01/app/oracle/product/19c/db_1/OPatch/opatch apply Oracle Interim Patch Installer version 12.2.0.1.42 Copyright (c) 2024, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/19c/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19c/db_1/oraInst.loc OPatch version : 12.2.0.1.42 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2024-05-27_12-55-52PM_1.log Verifying environment and performing prerequisite checks... -------------------------------------------------------------------------------- Start OOP by Prereq process. Launch OOP... Oracle Interim Patch Installer version 12.2.0.1.42 Copyright (c) 2024, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/19c/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19c/db_1/oraInst.loc OPatch version : 12.2.0.1.42 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2024-05-27_12-57-49PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 36233263 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_1') Is the local system ready for patching? [y|n] Y User Responded with: Y Backing up files... Applying interim patch '36233263' to OH '/u01/app/oracle/product/19c/db_1' ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.crypto.rsf, 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.tfa, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.sdo.companion, 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.rdbms.rsf, 19.0.0.0.0... 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.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.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.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.wwg.plsql, 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.ldap.client, 19.0.0.0.0... Patching component oracle.rdbms.rman, 19.0.0.0.0... Patching component oracle.rdbms.dv, 19.0.0.0.0... Patching component oracle.xdk.parser.java, 19.0.0.0.0... Patching component oracle.ldap.rsf.ic, 19.0.0.0.0... Patching component oracle.oraolap.api, 19.0.0.0.0... Patching component oracle.javavm.server, 19.0.0.0.0... Patching component oracle.mgw.common, 19.0.0.0.0... Patching component oracle.xdk, 19.0.0.0.0... Patching component oracle.odbc, 19.0.0.0.0... Patching component oracle.xdk.xquery, 19.0.0.0.0... Patching component oracle.nlsrtl.rsf, 19.0.0.0.0... Patching component oracle.rdbms.lbac, 19.0.0.0.0... Patching component oracle.network.client, 19.0.0.0.0... Patching component oracle.network.listener, 19.0.0.0.0... Patching component oracle.install.deinstalltool, 19.0.0.0.0... Patching component oracle.ctx.atg, 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, 19.0.0.0.0... Patching component oracle.rdbms.install.common, 19.0.0.0.0... Patching component oracle.oraolap.dbscripts, 19.0.0.0.0... Patching component oracle.sdo.locator, 19.0.0.0.0... Patching component oracle.rdbms.drdaas, 19.0.0.0.0... Patching component oracle.nlsrtl.rsf.lbuilder, 19.0.0.0.0... Patching component oracle.oraolap, 19.0.0.0.0... Patching component oracle.ovm, 19.0.0.0.0... Patching component oracle.rdbms.hs_common, 19.0.0.0.0... Patching component oracle.ctx.rsf, 19.0.0.0.0... Patching component oracle.dbtoolslistener, 19.0.0.0.0... Patching component oracle.ldap.ssl, 19.0.0.0.0... Patching component oracle.rdbms.install.plugins, 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 36233263 successfully applied. Sub-set patch [35943157] has become inactive due to the application of a super-set patch [36233263]. Please refer to Doc ID 2161861.1 for any possible further required actions. Log file location: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2024-05-27_12-57-49PM_1.log
OPatch succeeded.
Verify the patch applied
[oracle@peptestdb ~]$ $ORACLE_HOME/OPatch/opatch lspatches 36233263;Database Release Update : 19.23.0.0.240416 (36233263) 29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399) OPatch succeeded.
OR
[oracle@peptestdb ~]$ $ORACLE_HOME/OPatch/opatch lsinventory Oracle Interim Patch Installer version 12.2.0.1.42 Copyright (c) 2024, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/19c/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19c/db_1/oraInst.loc OPatch version : 12.2.0.1.42 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2024-05-27_13-12-25PM_1.log Lsinventory Output file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/lsinv/lsinventory2024-05-27_13-12-25PM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: peptestdb ARU platform id: 226 ARU platform description:: Linux x86-64 Installed Top-level Products (1): Oracle Database 19c 19.0.0.0.0 There are 1 products installed in this Oracle Home. Interim patches (2) : Patch 36233263 : applied on Mon May 27 13:03:30 IRST 2024 Unique Patch ID: 25638263 Patch description: "Database Release Update : 19.23.0.0.240416 (36233263)" Created on 8 Apr 2024, 17:16:56 hrs UTC Bugs fixed: 10121473, 10123661, 1297945, 14570574, 14735102, 15931756, 15959416 -------------------------------------------------------------------------------- OPatch succeeded.
OR
[oracle@peptestdb ~]$ $ORACLE_HOME/OPatch/opatch lsinv | grep applied Patch 36233263 : applied on Mon May 27 13:03:30 IRST 2024 Patch 29585399 : applied on Thu Apr 18 11:51:33 IRDT 2019
Start the database & Listener
[oracle@peptestdb ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 27 14:13:59 2024 Version 19.23.0.0.0 Copyright (c) 1982, 2023, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 3204445096 bytes Fixed Size 9192360 bytes Variable Size 2063597568 bytes Database Buffers 1124073472 bytes Redo Buffers 7581696 bytes Database mounted. Database opened.
SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- -------------------------------- 2 PDB$SEED READ ONLY NO 3 PDB1 MOUNTED
Open the Pluggable Databases
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 PDB1 READ WRITE NO
Start the listener
[oracle@peptestdb ~]$ lsnrctl start (If its ASM Instance srvctl start listener)
SQL> alter system register; System altered.
SQL> alter session set container=pdb1; Session altered.
SQL> alter system register; System altered.
Therefore the DB Patch are applied in Container., Need to apply for All PDB Database as fallow.
[oracle@peptestdb ~]$ cd $ORACLE_HOME/OPatch
[oracle@peptestdb OPatch]$ ./datapatch -verbose SQL Patching tool version 19.23.0.0.0 Production on Mon May 27 14:18:02 2024 Copyright (c) 2012, 2024, Oracle. All rights reserved. Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_127790_2024_05_27_14_18_02/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.23.0.0.0 Release_Update 240406004238: Installed PDB CDB$ROOT: Applied 19.22.0.0.0 Release_Update 240104023954 successfully on 27-MAY-24 11.49.16.558576 AM PDB PDB$SEED: Applied 19.22.0.0.0 Release_Update 240104023954 successfully on 26-MAY-24 09.24.06.392321 PM PDB PDB1: Applied 19.22.0.0.0 Release_Update 240104023954 successfully on 26-MAY-24 08.55.51.181953 PM Adding patches to installation queue and performing prereq checks...done Installation queue: For the following PDBs: CDB$ROOT PDB$SEED PDB1 No interim patches need to be rolled back Patch 36233263 (Database Release Update : 19.23.0.0.240416 (36233263)): Apply from 19.22.0.0.0 Release_Update 240104023954 to 19.23.0.0.0 Release_Update 240406004238 No interim patches need to be applied Installing patches... Patch installation complete. Total patches installed: 3 Validating logfiles...done Patch 36233263 apply (pdb CDB$ROOT): SUCCESS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/36233263/25638263/36233263_apply_PEPTEST_CDBROOT_2024May27_14_19_49.log (no errors) Patch 36233263 apply (pdb PDB$SEED): SUCCESS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/36233263/25638263/36233263_apply_PEPTEST_PDBSEED_2024May27_14_21_25.log (no errors) Patch 36233263 apply (pdb PDB1): SUCCESS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/36233263/25638263/36233263_apply_PEPTEST_PDB1_2024May27_14_21_25.log (no errors) SQL Patching tool complete on Mon May 27 14:23:11 2024
Check the invalid objects on Container and PDB Databases
On CDB
SQL> show con_name CON_NAME ---------- CDB$ROOT
SQL> select count(*) from all_objects where status='INVALID' group by owner; no rows selected
On PDB
SQL> alter session set container=pdb1; Session altered.
SQL> select count(*) from all_objects where status='INVALID' group by owner; COUNT(*) ---------- 397 2 12 2 2 13 8 8 8 rows selected.
Run the UTLRPT.SQL Package to compile the INVALID Object
SQL> @?/rdbms/admin/utlrp.sql; Session altered. TIMESTAMP ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ COMP_TIMESTAMP UTLRP_BGN 2024-05-27 14:31:51 DOC> The following PL/SQL block invokes UTL_RECOMP to recompile invalid DOC> objects in the database. Recompilation time is proportional to the DOC> number of invalid objects in the database, so this command may take DOC> a long time to execute on a database with a large number of invalid DOC> objects. DOC> DOC> Use the following queries to track recompilation progress: DOC> DOC> 1. Query returning the number of invalid objects remaining. This DOC> number should decrease with time. DOC> SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6); DOC> DOC> 2. Query returning the number of objects compiled so far. This number DOC> should increase with time. DOC> SELECT COUNT(*) FROM UTL_RECOMP_COMPILED; DOC> DOC> This script automatically chooses serial or parallel recompilation DOC> based on the number of CPUs available (parameter cpu_count) multiplied DOC> by the number of threads per CPU (parameter parallel_threads_per_cpu). DOC> On RAC, this number is added across all RAC nodes. DOC> DOC> UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel DOC> recompilation. Jobs are created without instance affinity so that they DOC> can migrate across RAC nodes. Use the following queries to verify DOC> whether UTL_RECOMP jobs are being created and run correctly: DOC> DOC> 1. Query showing jobs created by UTL_RECOMP DOC> SELECT job_name FROM dba_scheduler_jobs DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%'; DOC> DOC> 2. Query showing UTL_RECOMP jobs that are running DOC> SELECT job_name FROM dba_scheduler_running_jobs DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%'; DOC># PL/SQL procedure successfully completed. TIMESTAMP ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ COMP_TIMESTAMP UTLRP_END 2024-05-27 14:33:30 DOC> The following query reports the number of invalid objects. DOC> DOC> If the number is higher than expected, please examine the error DOC> messages reported with each object (using SHOW ERRORS) to see if they DOC> point to system misconfiguration or resource constraints that must be DOC> fixed before attempting to recompile these objects. DOC># OBJECTS WITH ERRORS ------------------- 0 DOC> The following query reports the number of exceptions caught during DOC> recompilation. If this number is non-zero, please query the error DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors DOC> are due to misconfiguration or resource constraints that must be DOC> fixed before objects can compile successfully. DOC> Note: Typical compilation errors (due to coding errors) are not DOC> logged into this table: they go into DBA_ERRORS instead. DOC># ERRORS DURING RECOMPILATION --------------------------- 0 Function created. PL/SQL procedure successfully completed. Function dropped. PL/SQL procedure successfully completed.
Re-check the INVALID Objects, The result should be ‘no rows selected’
SQL> select count(*) from all_objects where status='INVALID' group by owner; no rows selected
Hence applied for all PDB DB’s & veified.
SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------------ 2 PDB$SEED READ ONLY NO 3 DB1 READ WRITE NO
SQL> set linesize 300 SQL> select CON_ID, TO_CHAR(action_time, 'YYYY-MM-DD') AS action_time, PATCH_ID, PATCH_TYPE, ACTION, DESCRIPTION, SOURCE_VERSION, TARGET_VERSION from CDB_REGISTRY_SQLPATCH order by CON_ID, action_time, patch_id; CON_ID ACTION_TIM PATCH_ID PATCH_TYPE ACTION DESCRIPTION SOURCE_VERSION TARGET_VERSION ---------- ---------- ---------- ---------- --------------- ---------------------------------------------------------------------------------------------------- --------------- --------------- 1 2024-05-27 35943157 RU APPLY Database Release Update : 19.22.0.0.240116 (35943157) 19.1.0.0.0 19.22.0.0.0 1 2024-05-27 36233263 RU APPLY Database Release Update : 19.23.0.0.240416 (36233263) 19.22.0.0.0 19.23.0.0.0 3 2024-05-26 29517242 RU APPLY Database Release Update : 19.3.0.0.190416 (29517242) 19.1.0.0.0 19.3.0.0.0 3 2024-05-26 35943157 RU APPLY Database Release Update : 19.22.0.0.240116 (35943157) 19.3.0.0.0 19.22.0.0.0 3 2024-05-26 35943157 RU APPLY Database Release Update : 19.22.0.0.240116 (35943157) 19.3.0.0.0 19.22.0.0.0 3 2024-05-26 35943157 RU APPLY Database Release Update : 19.22.0.0.240116 (35943157) 19.3.0.0.0 19.22.0.0.0 3 2024-05-26 35943157 RU APPLY Database Release Update : 19.22.0.0.240116 (35943157) 19.3.0.0.0 19.22.0.0.0 3 2024-05-27 36233263 RU APPLY Database Release Update : 19.23.0.0.240416 (36233263) 19.22.0.0.0 19.23.0.0.0 8 rows selected.
SQL> alter session set container=pdb1; Session altered.
SQL> set linesize 300 SQL> select CON_ID, TO_CHAR(action_time, 'YYYY-MM-DD') AS action_time, PATCH_ID, PATCH_TYPE, ACTION, DESCRIPTION, SOURCE_VERSION, TARGET_VERSION from CDB_REGISTRY_SQLPATCH order by CON_ID, action_time, patch_id; CON_ID ACTION_TIM PATCH_ID PATCH_TYPE ACTION DESCRIPTION SOURCE_VERSION TARGET_VERSION ---------- ---------- ---------- ---------- --------------- ---------------------------------------------------------------------------------------------------- --------------- --------------- 3 2024-05-26 29517242 RU APPLY Database Release Update : 19.3.0.0.190416 (29517242) 19.1.0.0.0 19.3.0.0.0 3 2024-05-26 35943157 RU APPLY Database Release Update : 19.22.0.0.240116 (35943157) 19.3.0.0.0 19.22.0.0.0 3 2024-05-26 35943157 RU APPLY Database Release Update : 19.22.0.0.240116 (35943157) 19.3.0.0.0 19.22.0.0.0 3 2024-05-26 35943157 RU APPLY Database Release Update : 19.22.0.0.240116 (35943157) 19.3.0.0.0 19.22.0.0.0 3 2024-05-26 35943157 RU APPLY Database Release Update : 19.22.0.0.240116 (35943157) 19.3.0.0.0 19.22.0.0.0 3 2024-05-27 36233263 RU APPLY Database Release Update : 19.23.0.0.240416 (36233263) 19.22.0.0.0 19.23.0.0.0 6 rows selected.
Verify the RU Patch check with DBA_REGISTRY_SQLPATCH
SQL> col version for a11 SQL> col status for a10 SQL> col comp_name for a37 SQL> select comp_id,comp_name,version,status from dba_registry;SQL> SQL> SQL> COMP_ID COMP_NAME VERSION STATUS ------------------------------ ------------------------------------- ---------- CATALOG Oracle Database Catalog Views 19.0.0.0.0 VALID CATPROC Oracle Database Packages and Types 19.0.0.0.0 VALID RAC Oracle Real Application Clusters 19.0.0.0.0 OPTION OFF JAVAVM JServer JAVA Virtual Machine 19.0.0.0.0 VALID XML Oracle XDK 19.0.0.0.0 VALID CATJAVA Oracle Database Java Packages 19.0.0.0.0 VALID APS OLAP Analytic Workspace 19.0.0.0.0 VALID XDB Oracle XML Database 19.0.0.0.0 VALID OWM Oracle Workspace Manager 19.0.0.0.0 VALID CONTEXT Oracle Text 19.0.0.0.0 VALID ORDIM Oracle Multimedia 19.0.0.0.0 VALID SDO Spatial 19.0.0.0.0 VALID XOQ Oracle OLAP API 19.0.0.0.0 VALID OLS Oracle Label Security 19.0.0.0.0 VALID DV Oracle Database Vault 19.0.0.0.0 VALID
SQL> COLUMN action_time FORMAT A10 SQL> COLUMN status FORMAT A30 SQL> COLUMN description FORMAT A30 SQL> SELECT action_time,action,status,description,patch_id from dba_registry_sqlpatch;SQL> SQL> SQL> SQL> ACTION_TIM ACTION STATUS DESCRIPTION PATCH_ID ---------- --------------- ------------------------------ ------------------------------ ---------- 26-MAY-24 APPLY SUCCESS Database Release Update : 19.3 29517242 02.54.56.0 .0.0.190416 (29517242) 89916 PM 26-MAY-24 APPLY SUCCESS Database Release Update : 19.2 35943157 08.55.51.1 2.0.0.240116 (35943157) 81953 PM 27-MAY-24 APPLY SUCCESS Database Release Update : 19.2 36233263 02.21.55.1 3.0.0.240416 (36233263)