How to Apply Release Update 19.11.0.0.0 (Patch 32545013)

This article covers the process of applying the Oracle Release Update 19.11 (Patch 32545013) on a 19c Database.

Step-1: Install Latest OPatch

First Step of Any Patching Process is to download and install the latest version of OPatch. You can follow How to Upgrade OPatch to Latest Version post to quickly upgrade OPatch to latest version.

Step 2: Download Patch 32545013 from Metalink.

From Metalink (https://support.oracle.com/) Download “Patch 32545013: DATABASE RELEASE UPDATE 19.11.0.0.0” relevant to your platform. 
oracle> opatch version
OPatch Version: 12.2.0.1.24

OPatch succeeded.
oracle>

Step 3: Check for Patch Conflict

The move the zip file downloaded in Step 2 above to a directory where Oracle has relevant read/write permission and then unzip the file which would create a folder named 32545013. Navigate to this directory and call OPatch in prereq mode:

oracle> opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.24
Copyright (c) 2021, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /apps/oracle/server/19.3.0.0/dbhome_1
Central Inventory : /opt/oracle/oraInventory
   from           : /apps/oracle/server/19.3.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.24
OUI version       : 12.2.0.7.0
Log file location : /apps/oracle/server/19.3.0.0/dbhome_1/cfgtoollogs/opatch/opatch2021-04-24_15-10-40PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

If the pre-requisite check is passed you can proceed further with applying the patch but in case it fails please take necessary actions until the pre-requisite check is passed.

Step-4: Shutdown Database

To minimize the downtime you can shutdown the database after invoking opatch apply but just to explicitly specify, I have created an additional step for this.

Once the database running from the Oracle Home that we are going to patch is shutdown, proceed further with next step.

Step-5: Apply OPatch

Navigate to the folder 32545013 and invoke the OPatch with apply mode.

$  $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.24
Copyright (c) 2021, Oracle Corporation.  All rights reserved.


Oracle Home       : /apps/oracle/server/19.3.0.0/dbhome_1
Central Inventory : /opt/oracle/oraInventory
   from           : /apps/oracle/server/19.3.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.24
OUI version       : 12.2.0.7.0
Log file location : /apps/oracle/server/19.3.0.0/dbhome_1/cfgtoollogs/opatch/opatch2021-04-24_15-11-06PM_1.log

Verifying environment and performing prerequisite checks...

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

Oracle Interim Patch Installer version 12.2.0.1.24
Copyright (c) 2021, Oracle Corporation.  All rights reserved.


Oracle Home       : /apps/oracle/server/19.3.0.0/dbhome_1
Central Inventory : /opt/oracle/oraInventory
   from           : /apps/oracle/server/19.3.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.24
OUI version       : 12.2.0.7.0
Log file location : /apps/oracle/server/19.3.0.0/dbhome_1/cfgtoollogs/opatch/opatch2021-04-24_15-17-18PM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:   32545013

Do you want to proceed? [y|n]
Could not recognize input. Please re-enter.
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/apps/oracle/server/19.3.0.0/dbhome_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '32545013' to OH '/apps/oracle/server/19.3.0.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.network.gsm, 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.options.olap.api, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.xdk.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.buildtools.rsf, 19.0.0.0.0...

Patching component oracle.ctx, 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.dbtoolslistener, 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.marvel, 19.0.0.0.0...

Patching component oracle.network.rsf, 19.0.0.0.0...

Patching component oracle.oracore.rsf, 19.0.0.0.0...

Patching component oracle.precomp.common.core, 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.rhp.db, 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.wwg.plsql, 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.rsf, 19.0.0.0.0...

Patching component oracle.dbdev, 19.0.0.0.0...

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

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

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

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

Patching component oracle.mgw.common, 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.ldap.rsf.ic, 19.0.0.0.0...

Patching component oracle.oraolap, 19.0.0.0.0...

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

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

Patching component oracle.sqlplus.ic, 19.0.0.0.0...

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

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

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

Patching component oracle.rdbms.crs, 19.0.0.0.0...

Patching component oracle.ctx.rsf, 19.0.0.0.0...

Patching component oracle.ldap.security.osdt, 19.0.0.0.0...

Patching component oracle.precomp.rsf, 19.0.0.0.0...

Patching component oracle.ldap.client, 19.0.0.0.0...

Patching component oracle.network.client, 19.0.0.0.0...

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

Patching component oracle.rdbms.rman, 19.0.0.0.0...

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

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

Patching component oracle.ovm, 19.0.0.0.0...

Patching component oracle.rdbms.rsf.ic, 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 32545013 successfully applied.
Sub-set patch [32218454] has become inactive due to the application of a super-set patch [32545013].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /apps/oracle/server/19.3.0.0/dbhome_1/cfgtoollogs/opatch/opatch2021-04-24_15-17-18PM_1.log

OPatch succeeded.

Step-6: Start the Database

Start the database that you stopped during Step-5. Once the Database is started along with all the PDBs, proceed further with the next step of applying datapatch.

Step-7: Apply Datapatch (SQL Patching Tool)

$  $ORACLE_HOME/OPatch/datapatch -verbose
SQL Patching tool version 19.11.0.0.0 Production on Sat Apr 24 18:31:51 2021
Copyright (c) 2012, 2021, Oracle.  All rights reserved.

Log file for this invocation: /apps/oracle/server/19.3.0.0/cfgtoollogs/sqlpatch/sqlpatch_28124_2021_04_24_18_31_51/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.11.0.0.0 Release_Update 210413004009: Installed
  PDB CDB$ROOT:
    Applied 19.10.0.0.0 Release_Update 210108185017 successfully on 16-APR-21 05.43.48.916739 PM
  PDB PDB$SEED:
    Applied 19.10.0.0.0 Release_Update 210108185017 successfully on 16-APR-21 06.03.58.949772 PM
  PDB PDB119:
    Applied 19.10.0.0.0 Release_Update 210108185017 successfully on 16-APR-21 06.03.58.949772 PM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED PDB119
    No interim patches need to be rolled back
    Patch 32545013 (Database Release Update : 19.11.0.0.210420 (32545013)):
      Apply from 19.10.0.0.0 Release_Update 210108185017 to 19.11.0.0.0 Release_Update 210413004009
    No interim patches need to be applied

Installing patches...

Patch installation complete.  Total patches installed: 3

Validating logfiles...done
Patch 32545013 apply (pdb CDB$ROOT): SUCCESS
  logfile: /apps/oracle/server/19.3.0.0/cfgtoollogs/sqlpatch/32545013/24175065/32545013_apply_CDB19_CDBROOT_2021Apr24_18_33_11.log (no errors)
Patch 32545013 apply (pdb PDB$SEED): SUCCESS
  logfile: /apps/oracle/server/19.3.0.0/cfgtoollogs/sqlpatch/32545013/24175065/32545013_apply_CDB19_PDBSEED_2021Apr24_18_38_07.log (no errors)
Patch 32545013 apply (pdb PDB119): SUCCESS
  logfile: /apps/oracle/server/19.3.0.0/cfgtoollogs/sqlpatch/32545013/24175065/32545013_apply_CDB19_PDB119_2021Apr24_18_38_07.log (no errors)
SQL Patching tool complete on Sat Apr 24 18:43:17 2021

That’s it the database has been patched.

SET LINESIZE 500
SET PAGESIZE 1000
SET SERVEROUT ON
SET LONG 2000000
COLUMN action_time FORMAT A12
COLUMN action FORMAT A10
COLUMN patch_type FORMAT A10
COLUMN description FORMAT A55
COLUMN status FORMAT A10
COLUMN version FORMAT A10
alter session set "_exclude_seed_cdb_view"=FALSE;
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_TIME    PATCH_ID PATCH_TYPE ACTION     DESCRIPTION                                             SOURCE_VERSION  TARGET_VERSION
---------- ------------ ---------- ---------- ---------- ------------------------------------------------------- --------------- ---------------
         1 2020-07-25     30869156 RU         APPLY      Database Release Update : 19.7.0.0.200414 (30869156)    19.1.0.0.0      19.7.0.0.0
         1 2021-05-17     32545013 RU         APPLY      Database Release Update : 19.11.0.0.210420 (32545013)   19.7.0.0.0      19.11.0.0.0
         2 2020-07-25     30869156 RU         APPLY      Database Release Update : 19.7.0.0.200414 (30869156)    19.1.0.0.0      19.7.0.0.0
         2 2021-05-17     32545013 RU         APPLY      Database Release Update : 19.11.0.0.210420 (32545013)   19.7.0.0.0      19.11.0.0.0
         3 2020-07-25     30869156 RU         APPLY      Database Release Update : 19.7.0.0.200414 (30869156)    19.1.0.0.0      19.7.0.0.0
         3 2021-05-17     32545013 RU         APPLY      Database Release Update : 19.11.0.0.210420 (32545013)   19.7.0.0.0      19.11.0.0.0

6 rows selected.

SQL>

Check the status of Installed components & objects

SQL> col comp_name format a40
SQL> SELECT comp_name, version, status FROM dba_registry;

COMP_NAME                                VERSION    STATUS
---------------------------------------- ---------- ----------
Oracle Database Catalog Views            19.0.0.0.0 VALID
Oracle Database Packages and Types       19.0.0.0.0 VALID
Oracle Real Application Clusters         19.0.0.0.0 OPTION OFF
JServer JAVA Virtual Machine             19.0.0.0.0 VALID
Oracle XDK                               19.0.0.0.0 VALID
Oracle Database Java Packages            19.0.0.0.0 VALID
OLAP Analytic Workspace                  19.0.0.0.0 OPTION OFF
Oracle XML Database                      19.0.0.0.0 VALID
Oracle Workspace Manager                 19.0.0.0.0 VALID
Oracle Text                              19.0.0.0.0 VALID
Oracle Multimedia                        19.0.0.0.0 VALID
Spatial                                  19.0.0.0.0 OPTION OFF
Oracle OLAP API                          19.0.0.0.0 OPTION OFF
Oracle Label Security                    19.0.0.0.0 OPTION OFF
Oracle Database Vault                    19.0.0.0.0 OPTION OFF
SQL> select count(*) from dba_objects where STATUS != 'VALID';

  COUNT(*)
----------
         0

SQL>

If any objects are invalid post this patching exercise and execute utlrp.sql to repair them.

One thought on “How to Apply Release Update 19.11.0.0.0 (Patch 32545013)

  1. Pingback: How to Apply Release Update 12.2.0.1.210420 (Patch 32507738 – April 2021 RU) | Oracle Database Internal Mechanism

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.