Validate Applied Patches in Database Oracle 19c
In this article, we are going to demonstrate validate applied patches in Oracle 19c and 12c on both ORACLE HOME & DATABASE using various methods/options including container & pluggable database. Validation becomes important before and after the patch apply. Let’s begin practical.
1. Validation in ORACLE HOME
First, we will validate in ORACLE HOME, follow some important available options below to verify the applied patch.
1.1. lsinventory: Validate applied patch in inventory which shows all patches. Click here for the complete output.
[oracle@DBsGuruN ~]$ ORACLE_SID = [oracle] ? gurudb
The Oracle base has been set to /u01/app/oracle
[oracle@DBsGuruN ~]$ export PATH=$ORACLE_HOME/OPatch:$PATH
[oracle@DBsGuruN ~]$ opatch version
OPatch Version: 12.2.0.1.25
OPatch succeeded.
[oracle@DBsGuruN ~]$ opatch lsinventory
1.2. lsinventory -details: Report installed products and other details.
[oracle@DBsGuruN ~]$ opatch lsinventory -details
Oracle Interim Patch Installer version 12.2.0.1.25
Copyright (c) 2021, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/19.0.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.25
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2021-08-03_17-51-18PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2021-08-03_17-51-18PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: DBsGuruN.dbsguru.com
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.
Installed Products (128):
Assistant Common Files 19.0.0.0.0
BLASLAPACK Component 19.0.0.0.0
Buildtools Common Files 19.0.0.0.0
Cluster Verification Utility Common Files 19.0.0.0.0
Cluster Verification Utility DB Files 19.0.0.0.0
Database Configuration and Upgrade Assistants 19.0.0.0.0
Database Migration Assistant for Unicode 19.0.0.0.0
Database SQL Scripts 19.0.0.0.0
Database Workspace Manager 19.0.0.0.0
DB TOOLS Listener 19.0.0.0.0
Deinstallation Tool 19.0.0.0.0
Enterprise Edition Options 19.0.0.0.0
Expat libraries 2.0.1.0.4
Generic Connectivity Common Files 19.0.0.0.0
Hadoopcore Component 19.0.0.0.0
HAS Common Files 19.0.0.0.0
HAS Files for DB 19.0.0.0.0
Installation Common Files 19.0.0.0.0
Installation Plugin Files 19.0.0.0.0
Installer SDK Component 12.2.0.7.0
JAccelerator (COMPANION) 19.0.0.0.0
Java Development Kit 1.8.0.201.0
LDAP Required Support Files 19.0.0.0.0
OLAP SQL Scripts 19.0.0.0.0
Oracle Advanced Analytics 19.0.0.0.0
Oracle Advanced Security 19.0.0.0.0
Oracle Application Express 19.0.0.0.0
Oracle Bali Share 11.1.1.6.0
Oracle Call Interface (OCI) 19.0.0.0.0
Oracle Clusterware RDBMS Files 19.0.0.0.0
Oracle Context Companion 19.0.0.0.0
Oracle Core Required Support Files 19.0.0.0.0
Oracle Core Required Support Files for Core DB 19.0.0.0.0
Oracle Database 19c 19.0.0.0.0
Oracle Database 19c 19.0.0.0.0
Oracle Database 19c Multimedia Files 19.0.0.0.0
Oracle Database Deconfiguration 19.0.0.0.0
Oracle Database Gateway for ODBC 19.0.0.0.0
Oracle Database Provider for DRDA 19.0.0.0.0
Oracle Database Utilities 19.0.0.0.0
Oracle Database Vault option 19.0.0.0.0
Oracle DBCA Deconfiguration 19.0.0.0.0
Oracle Extended Windowing Toolkit 11.1.1.6.0
Oracle Globalization Support 19.0.0.0.0
Oracle Globalization Support 19.0.0.0.0
Oracle Globalization Support For Core 19.0.0.0.0
Oracle Help for Java 11.1.1.7.0
Oracle Help Share Library 11.1.1.7.0
Oracle Ice Browser 11.1.1.7.0
Oracle Internet Directory Client 19.0.0.0.0
Oracle Java Client 19.0.0.0.0
Oracle JDBC Server Support Package 19.0.0.0.0
Oracle JDBC/OCI Instant Client 19.0.0.0.0
Oracle JDBC/THIN Interfaces 19.0.0.0.0
Oracle JFC Extended Windowing Toolkit 11.1.1.6.0
Oracle JVM 19.0.0.0.0
Oracle JVM For Core 19.0.0.0.0
Oracle Label Security 19.0.0.0.0
Oracle LDAP administration 19.0.0.0.0
Oracle Locale Builder 19.0.0.0.0
Oracle Message Gateway Common Files 19.0.0.0.0
Oracle Multimedia 19.0.0.0.0
Oracle Multimedia Client Option 19.0.0.0.0
Oracle Multimedia Java Advanced Imaging 19.0.0.0.0
Oracle Multimedia Locator 19.0.0.0.0
Oracle Multimedia Locator Java Required Support Files 19.0.0.0.0
Oracle Multimedia Locator RDBMS Files 19.0.0.0.0
Oracle Net 19.0.0.0.0
Oracle Net Listener 19.0.0.0.0
Oracle Net Required Support Files 19.0.0.0.0
Oracle Net Services 19.0.0.0.0
Oracle Netca Client 19.0.0.0.0
Oracle Notification Service 19.0.0.0.0
Oracle Notification Service for Instant Client 19.0.0.0.0
Oracle ODBC Driver 19.0.0.0.0
Oracle ODBC Driverfor Instant Client 19.0.0.0.0
Oracle OLAP 19.0.0.0.0
Oracle OLAP API 19.0.0.0.0
Oracle OLAP RDBMS Files 19.0.0.0.0
Oracle One-Off Patch Installer 12.2.0.1.15
Oracle Partitioning 19.0.0.0.0
Oracle Programmer 19.0.0.0.0
Oracle R Enterprise Server Files 19.0.0.0.0
Oracle RAC Required Support Files-HAS 19.0.0.0.0
Oracle Real Application Testing 19.0.0.0.0
Oracle Recovery Manager 19.0.0.0.0
Oracle Scheduler Agent 19.0.0.0.0
Oracle Security Developer Tools 19.0.0.0.0
Oracle Spatial and Graph 19.0.0.0.0
Oracle SQL Developer 19.0.0.0.0
Oracle Starter Database 19.0.0.0.0
Oracle Text 19.0.0.0.0
Oracle Text ATG Language Support Files 19.0.0.0.0
Oracle Text Required Support Files 19.0.0.0.0
Oracle Universal Connection Pool 19.0.0.0.0
Oracle Universal Installer 12.2.0.7.0
Oracle USM Deconfiguration 19.0.0.0.0
Oracle Wallet Manager 19.0.0.0.0
Oracle XML Development Kit 19.0.0.0.0
Oracle XML Query 19.0.0.0.0
oracle.swd.commonlogging 13.3.0.0.0
oracle.swd.opatchautodb 12.2.0.1.5
oracle.swd.oui.core.min 12.2.0.7.0
Parser Generator Required Support Files 19.0.0.0.0
Perl Interpreter 5.28.1.0.0
Perl Modules 5.28.1.0.0
PL/SQL 19.0.0.0.0
PL/SQL Embedded Gateway 19.0.0.0.0
Platform Required Support Files 19.0.0.0.0
Precompiler Common Files 19.0.0.0.0
Precompiler Common Files for Core 19.0.0.0.0
Precompiler Required Support Files 19.0.0.0.0
Precompilers 19.0.0.0.0
RDBMS Required Support Files 19.0.0.0.0
RDBMS Required Support Files for Instant Client 19.0.0.0.0
Required Support Files 19.0.0.0.0
RHP Files for Common 19.0.0.0.0
RHP Files for DB 19.0.0.0.0
Secure Socket Layer 19.0.0.0.0
SQL*Plus 19.0.0.0.0
SQL*Plus Files for Instant Client 19.0.0.0.0
SQL*Plus Required Support Files 19.0.0.0.0
SQLJ Runtime 19.0.0.0.0
SSL Required Support Files for InstantClient 19.0.0.0.0
Trace File Analyzer for DB 19.0.0.0.0
XDK Required Support Files 19.0.0.0.0
XML Parser for Java 19.0.0.0.0
XML Parser for Oracle JVM 19.0.0.0.0
There are 128 products installed in this Oracle Home.
Interim patches (2) :
Patch 32904851 : applied on Sun Jul 25 19:00:38 IST 2021
Unique Patch ID: 24343243
Patch description: "Database Release Update : 19.12.0.0.210720 (32904851)"
Created on 20 Jul 2021, 09:21:24 hrs UTC
Bugs fixed:
7391838, 8460502, 8476681, 14570574, 14735102, 15931756, 16662822
=================Trimmed data=================
Files Touched:
/kubsbd.o --> ORACLE_HOME/lib/libclient19.a
/kpupft.o --> ORACLE_HOME/lib/libclient19.a
=================Trimmed data=================
Files Touched:
clustdb.sql --> ORACLE_HOME/srvm/admin/clustdb.sql
Patch Location in Inventory:
/u01/app/oracle/product/19.0.0/db_1/inventory/oneoffs/29585399
Patch Location in Storage area:
/u01/app/oracle/product/19.0.0/db_1/.patch_storage/29585399_Apr_9_2019_19_12_47
--------------------------------------------------------------------------------
OPatch succeeded.
1.3. Filter keyword “Patch description”: Filter patch IDs with keyword “Patch Description” in the ORACLE HOME.
[oracle@DBsGuruN ~]$ opatch lsinventory |grep -i "Patch description"
Patch description: "Database Release Update : 19.12.0.0.210720 (32904851)"
Patch description: "OCW RELEASE UPDATE 19.3.0.0.0 (29585399)"
1.4. Patch ID: Lists the patch IDs installed in the ORACLE HOME in ascending (asc) or descending (desc) order,
[oracle@DBsGuruN ~]$ opatch lsinventory -patch_id desc/asc
1.5.lspatches: Summary of installed patches in ORACLE HOME.
[oracle@DBsGuruN ~]$ opatch lspatches
32904851;Database Release Update : 19.12.0.0.210720 (32904851)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
2. Validation in ORACLE HOME
In this section, we will execute various SQL commands to validate patches in the database.
2.1. Post patch validate: Validate applied patch IDs in the database specific to post after i.e after applying patches to ORACLE HOME then to the database.
2.1.1: Validate in 12c databases: Click here to get SQL command for version 12c, refer to section database only.
2.1.2: Validate in 19c database: Execute the below command which is specific to the 19c database.
Normal Database/Instance
SQL> SET PAGES 55
SET LINESIZE 601
COLUMN ACTION_TIME FORMAT A21
COLUMN ACTION FORMAT A11
COLUMN STATUS FORMAT A11
COLUMN DESCRIPTION FORMAT A55
COLUMN VERSION FORMAT A11
COLUMN BUNDLE_SERIES FORMAT A11
SELECT TO_CHAR(ACTION_TIME, 'DD-MON-YYYY HH24:MI:SS') AS ACTION_TIME, PATCH_TYPE,
ACTION,STATUS,DESCRIPTION, SOURCE_VERSION,TARGET_VERSION, PATCH_ID FROM SYS.DBA_REGISTRY_SQLPATCH ORDER BY ACTION_TIME DESC;
prompt$$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
ACTION_TIME PATCH_TYPE ACTION STATUS DESCRIPTION SOURCE_VERSION TARGET_VERSION PATCH_ID
--------------------- ---------- ----------- ----------- ------------------------------------------------------- --------------- --------------- ----------
25-JUL-2021 20:20:42 RU APPLY SUCCESS Database Release Update : 19.12.0.0.210720 (32904851) 19.3.0.0.0 19.12.0.0.0 32904851
05-JUN-2021 22:47:33 RU APPLY SUCCESS Database Release Update : 19.3.0.0.190416 (29517242) 19.1.0.0.0 19.3.0.0.0 29517242
SQL> $$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
Multitenant Database/Instance
SET PAGES 55
SET LINESIZE 601
COLUMN ACTION_TIME FORMAT A21
COLUMN ACTION FORMAT A11
COLUMN STATUS FORMAT A11
COLUMN DESCRIPTION FORMAT A55
COLUMN VERSION FORMAT A11
COLUMN BUNDLE_SERIES FORMAT A11
SELECT CON_ID,TO_CHAR(ACTION_TIME, 'DD-MON-YYYY HH24:MI:SS') AS ACTION_TIME, PATCH_TYPE,
ACTION,STATUS,DESCRIPTION, SOURCE_VERSION,TARGET_VERSION, PATCH_ID FROM SYS.CDB_REGISTRY_SQLPATCH ORDER BY CON_ID,ACTION_TIME DESC;
prompt$$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
CON_ID ACTION_TIME PATCH_TYPE ACTION STATUS DESCRIPTION SOURCE_VERSION TARGET_VERSION PATCH_ID
---------- --------------------- ---------- ----------- ----------- ------------------------------------------------------- --------------- --------------- ----------
1 25-JUL-2021 20:20:42 RU APPLY SUCCESS Database Release Update : 19.12.0.0.210720 (32904851) 19.3.0.0.0 19.12.0.0.0 32904851
1 05-JUN-2021 22:47:33 RU APPLY SUCCESS Database Release Update : 19.3.0.0.190416 (29517242) 19.1.0.0.0 19.3.0.0.0 29517242
3 25-JUL-2021 20:20:52 RU APPLY SUCCESS Database Release Update : 19.12.0.0.210720 (32904851) 19.3.0.0.0 19.12.0.0.0 32904851
3 05-JUN-2021 22:55:14 RU APPLY SUCCESS Database Release Update : 19.3.0.0.190416 (29517242) 19.1.0.0.0 19.3.0.0.0 29517242
SQL> $$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
Optionally you can also connect to each container database and execute the below command to fetch details:
Connect to root container database (CDB$ROOT)
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> SET PAGES 55
SET LINESIZE 601
COLUMN ACTION_TIME FORMAT A21
COLUMN ACTION FORMAT A11
COLUMN STATUS FORMAT A11
COLUMN DESCRIPTION FORMAT A55
COLUMN VERSION FORMAT A11
COLUMN BUNDLE_SERIES FORMAT A11
SELECT TO_CHAR(ACTION_TIME, 'DD-MON-YYYY HH24:MI:SS') AS ACTION_TIME, PATCH_TYPE,
ACTION,STATUS,DESCRIPTION, SOURCE_VERSION,TARGET_VERSION, PATCH_ID FROM SYS.DBA_REGISTRY_SQLPATCH ORDER BY ACTION_TIME DESC;
prompt$$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
ACTION_TIME PATCH_TYPE ACTION STATUS DESCRIPTION SOURCE_VERSION TARGET_VERSION PATCH_ID
--------------------- ---------- ----------- ----------- ------------------------------------------------------- --------------- --------------- ----------
25-JUL-2021 20:20:42 RU APPLY SUCCESS Database Release Update : 19.12.0.0.210720 (32904851) 19.3.0.0.0 19.12.0.0.0 32904851
05-JUN-2021 22:47:33 RU APPLY SUCCESS Database Release Update : 19.3.0.0.190416 (29517242) 19.1.0.0.0 19.3.0.0.0 29517242
SQL> $$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
Connect to Pluggable database (DBSGURU_PDB) and follow same for each PDBs as applicable.
[oracle@DBsGuruN ~]$ sqlplus sys@DBSGURU_PDB as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jul 25 20:35:41 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Enter password:
Last Successful login time: Sun Jul 25 2021 17:48:38 +05:30
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
SQL> show con_name
CON_NAME
------------------------------
DBSGURU_PDB
SQL> SET PAGES 55
SET LINESIZE 601
COLUMN ACTION_TIME FORMAT A21
COLUMN ACTION FORMAT A11
COLUMN STATUS FORMAT A11
COLUMN DESCRIPTION FORMAT A55
COLUMN VERSION FORMAT A11
COLUMN BUNDLE_SERIES FORMAT A11
SELECT TO_CHAR(ACTION_TIME, 'DD-MON-YYYY HH24:MI:SS') AS ACTION_TIME, PATCH_TYPE,
ACTION,STATUS,DESCRIPTION, SOURCE_VERSION,TARGET_VERSION, PATCH_ID FROM SYS.DBA_REGISTRY_SQLPATCH ORDER BY ACTION_TIME DESC;
prompt$$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
ACTION_TIME PATCH_TYPE ACTION STATUS DESCRIPTION SOURCE_VERSION TARGET_VERSION PATCH_ID
--------------------- ---------- ----------- ----------- ------------------------------------------------------- --------------- --------------- ----------
25-JUL-2021 20:20:52 RU APPLY SUCCESS Database Release Update : 19.12.0.0.210720 (32904851) 19.3.0.0.0 19.12.0.0.0 32904851
05-JUN-2021 22:55:14 RU APPLY SUCCESS Database Release Update : 19.3.0.0.190416 (29517242) 19.1.0.0.0 19.3.0.0.0 29517242
SQL> $$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
2.2. Validate specific patches using DBMS_QOPATCH: Validate specific patches using DBMS_QOPATCH, here we are using a multitenant database.
SQL> SHOW CON_NAME
CON_NAME
------------------------------
CDB$ROOT
SQL> SET LINES 77
SELECT XMLTRANSFORM(DBMS_QOPATCH.IS_PATCH_INSTALLED('32904851'),DBMS_QOPATCH.GET_OPATCH_XSLT) "PATCH INSTALLED DETAILS FOR 32904851" FROM DUAL;
prompt$$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
PATCH INSTALLED DETAILS FOR 32904851
-----------------------------------------------------------------------------
Patch Information:
32904851: applied on 2021-07-25T19:00:38+05:30
SQL> $$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
SQL> ALTER SESSION SET CONTAINER=DBSGURU_PDB;
Session altered.
SQL> SHOW CON_NAME
CON_NAME
------------------------------
DBSGURU_PDB
SQL> SELECT XMLTRANSFORM(DBMS_QOPATCH.IS_PATCH_INSTALLED('32904851'),DBMS_QOPATCH.GET_OPATCH_XSLT) "PATCH INSTALLED DETAILS FOR 32904851" FROM DUAL;
prompt$$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
PATCH INSTALLED DETAILS FOR 32904851
-----------------------------------------------------------------------------
Patch Information:
32904851: applied on 2021-07-25T19:00:38+05:30
SQL> $$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
2.3. Validate bug-fixed patches using DBMS_QOPATCH: List all bug-fixed patches using DBMS_QOPATCH.
SQL> SHOW CON_NAME
CON_NAME
------------------------------
CDB$ROOT
SQL> SET LINES 77
SELECT XMLTRANSFORM(DBMS_QOPATCH.GET_OPATCH_BUGS, DBMS_QOPATCH.GET_OPATCH_XSLT) "BUG FIXED PATCH IDS" FROM DUAL;
prompt$$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
BUG FIXED PATCH IDS
--------------------------------------------------------------------------------
Bugs fixed:
7391838 8460502 8476681 14570574 14735102 15931756
SQL> $$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
SQL> alter session set container=DBSGURU_PDB;
Session altered.
SQL> SELECT XMLTRANSFORM(DBMS_QOPATCH.GET_OPATCH_BUGS, DBMS_QOPATCH.GET_OPATCH_XSLT) "BUG FIXED PATCH IDS" FROM DUAL;
prompt$$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
BUG FIXED PATCH IDS
-----------------------------------------------------------------------------
Bugs fixed:
7391838 8460502 8476681 14570574 14735102 15931756
SQL> $$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
2.4. Validate SQLPATCH patch IDs using DBMS_QOPATCH: Validate SQLPATCH patch IDs using DBMS_QOPATCH which are postpatch. Here we are using a multitenant database so its require to validate in all PDBs individually as applicable.
SQL> SHOW CON_NAME
CON_NAME
------------------------------
CDB$ROOT
SQL> SET LINES 555
SET SERVEROUT ON;
EXEC DBMS_QOPATCH.GET_SQLPATCH_STATUS;SQL> SQL>
prompt$$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
Patch Id : 29517242
Action : APPLY
Action Time : 05-JUN-2021 22:47:33
Description : Database Release Update : 19.3.0.0.190416 (29517242)
Logfile : /u01/app/oracle/cfgtoollogs/sqlpatch/29517242/22862832/29517242_apply_DBSGURU_CDBROOT_2021Jun05_22_43_00.log
Status : SUCCESS
Patch Id : 32904851
Action : APPLY
Action Time : 25-JUL-2021 20:20:42
Description : Database Release Update : 19.12.0.0.210720 (32904851)
Logfile : /u01/app/oracle/cfgtoollogs/sqlpatch/32904851/24343243/32904851_apply_GURUDB_CDBROOT_2021Jul25_20_08_57.log
Status : SUCCESS
PL/SQL procedure successfully completed.
SQL> $$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
SQL> alter session set container=DBSGURU_PDB;
Session altered.
SQL> SHOW CON_NAME
CON_NAME
------------------------------
DBSGURU_PDB
SQL> SET SERVEROUT ON;
EXEC DBMS_QOPATCH.GET_SQLPATCH_STATUS;SQL> SQL>
prompt$$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
Patch Id : 29517242
Action : APPLY
Action Time : 05-JUN-2021 22:55:14
Description : Database Release Update : 19.3.0.0.190416 (29517242)
Logfile : /u01/app/oracle/cfgtoollogs/sqlpatch/29517242/22862832/29517242_apply_DBSGURU_PDBSEED_2021Jun05_22_52_45.log
Status : SUCCESS
Patch Id : 32904851
Action : APPLY
Action Time : 25-JUL-2021 20:20:52
Description : Database Release Update : 19.12.0.0.210720 (32904851)
Logfile : /u01/app/oracle/cfgtoollogs/sqlpatch/32904851/24343243/32904851_apply_GURUDB_DBSGURU_PDB_2021Jul25_20_13_34.log
Status : SUCCESS
PL/SQL procedure successfully completed.
SQL> $$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
NOTE: Except Step 2.1 all are applicable to both database version 12c and 19c.
Click here to get more patching-related articles.
Click here for Upgrade Database (July 2021 Patch Apply 19c) 19.3 to 19.12 in Oracle.
This document is only for learning purpose and always validate in the LAB environment first before applying in the LIVE environment.
Hope so you like this article!
Please share your valuable feedback/comments/subscribe and follow us below and don’t forget to click on the bell icon to get the most recent update. Click here to know more about our pursuit.
Related articles
- Oracle Critical Database Patch ID for October 2024 along with enabled Download Link
- Oracle Critical Database Patch ID for July 2024 along with enabled Download Link
- Oracle Critical Database Patch ID for April 2024 along with enabled Download Link
- Oracle Critical Database Patch ID for January 2024 along with enabled Download Link
- Oracle Critical Database Patch ID for October 2023 along with enabled Download Link