()

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


Loading

How useful was this post?

Click on a star to rate it!

Average rating / 5. Vote count:

No votes so far! Be the first to rate this post.

As you found this post useful...

Follow us on social media!

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?

DBsGuru

Hello and welcome to DBsGuru,DBsGuru is a group of experienced DBA professionals and serves databases and their related community by providing technical blogs, projects, training. Technical blogs are the source of vast information not about databases but its related product like middleware, PL/SQL, replication methodology, and so on.Thanks for the visits!Share Learn Grow!