ORACLE DATABASE PATCHING RU STEPS 19C

Source version : 19.0.0.0

RU version : 19.13.0.0

Download the patch from the below link

NameDownload Link
Database Release Update 19.12.0.0.210720Patch 32904851

Analyze the Patch conflicts for your version in below link

https://support.oracle.com/epmos/faces/PatchConflictCheck

Copy the software to host and unzip the software in stage directory

-bash-4.2$ unzip p33192793_190000_Linux-x86-64.zip

Take a tar ball of current oracle home

-bash-4.2$ tar -cvf 19.0.0.tar 19.0.0/ -d /tmp/

Check for active sessions and notify the application owners to stop the applications if any running

SQL> select username,
  2         program,
  3         module,
  4         count(*)
  5  from
  6  v$session
  7  where status<>'INACTIVE'
  8  and
  9  username not in  ('SYS','SYSTEM')
 10  group by username,program,module;

no rows selected

Stop the listener

-bash-4.2$ lsnrctl stop

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 03-DEC-2021 18:22:31

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl19x)(PORT=1521)))
The command completed successfully

Stop the database instance

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

Stop the EM agent

-bash-4.2$ /u01/app/oracle/agent/agent_13.4.0.0.0/bin/emctl stop agent
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation.  All rights reserved.
Stopping agent ... stopped.

Set the environment variables and check patch inventory for existing applied patches

-bash-4.2$ export PATH=/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/data01/product/19.0.0/bin:/data01/product/19.0.0/OPatch
-bash-4.2$
-bash-4.2$ opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2021, Oracle Corporation.  All rights reserved.


Oracle Home       : /data01/product/19.0.0
Central Inventory : /apps01/oraInventory1
   from           : /data01/product/19.0.0/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.2.0.7.0
Log file location : /data01/product/19.0.0/cfgtoollogs/opatch/opatch2021-12-03_18-33-39PM_1.log

Lsinventory Output file location : /data01/product/19.0.0/cfgtoollogs/opatch/lsinv/lsinventory2021-12-03_18-33-39PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: orcl19x
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  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:
...........................................
OPatch succeeded.

Download the latest opatch utility from the link and upload it to host. (This link may or may not work if the link redirect to the another site)

Move the existing opatch directory to a backup directory

-bash-4.2$ cd $ORACLE_HOME
-bash-4.2$ mv OPatch/ OPatch_bkp

Unzip the download new opatch zip file to oracle home

-bash-4.2$ unzip /home/oracle/p6880880_190000_LINUX.zip -d /data01/product/19.0.0

Perform the prechecks by check conflict against oracle home with the patch staging directory

-bash-4.2$ opatch prereq CheckConflictAgainstOHWithDetail -ph /home/oracle/33192793/
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2021, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /data01/product/19.0.0
Central Inventory : /apps01/oraInventory1
   from           : /data01/product/19.0.0/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.2.0.7.0
Log file location : /data01/product/19.0.0/cfgtoollogs/opatch/opatch2021-12-03_18-44-27PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

Check if there are active files accessed by processes

-bash-4.2$ opatch prereq CheckActiveFilesAndExecutables -ph /home/oracle/33192793/
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2021, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /data01/product/19.0.0
Central Inventory : /apps01/oraInventory1
   from           : /data01/product/19.0.0/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.2.0.7.0
Log file location : /data01/product/19.0.0/cfgtoollogs/opatch/opatch2021-12-03_18-49-28PM_1.log

Invoking prereq "checkactivefilesandexecutables"

Prereq "checkActiveFilesAndExecutables" for patch 33192793 passed.

OPatch succeeded.

Start the opatch by applying the patch and monitor the logfile for errors

Note: ‘Installing patches…’ at this point , it may take more time to complete. So dont panic and be patient for the installation to complete

-bash-4.2$ opatch apply -jdk $ORACLE_HOME/jdk
Oracle Interim Patch Installer version 12.2.0.1.28
Copyright (c) 2021, Oracle Corporation.  All rights reserved.


Oracle Home       : /data01/product/19.0.0
Central Inventory : /apps01/oraInventory1
   from           : /data01/product/19.0.0/oraInst.loc
OPatch version    : 12.2.0.1.28
OUI version       : 12.2.0.7.0
Log file location : /data01/product/19.0.0/cfgtoollogs/opatch/opatch2021-12-03_20-04-26PM_1.log

Verifying environment and performing prerequisite checks...

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

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


Oracle Home       : /data01/product/19.0.0
Central Inventory : /apps01/oraInventory1
   from           : /data01/product/19.0.0/oraInst.loc
OPatch version    : 12.2.0.1.28
OUI version       : 12.2.0.7.0
Log file location : /data01/product/19.0.0/cfgtoollogs/opatch/opatch2021-12-03_20-05-40PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   33192793

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 = '/data01/product/19.0.0')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '33192793' to OH '/data01/product/19.0.0'
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.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.network.cman, 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.perlint, 5.28.1.0.0...

Patching component oracle.rdbms.locator, 19.0.0.0.0...

Patching component oracle.perlint.expat, 2.0.1.0.4...

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.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.odbc.ic, 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.sqlplus.ic, 19.0.0.0.0...

Patching component oracle.wwg.plsql, 19.0.0.0.0...

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

Patching component oracle.network.listener, 19.0.0.0.0...

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

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

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

Patching component oracle.rdbms.hs_common, 19.0.0.0.0...

Patching component oracle.xdk, 19.0.0.0.0...

Patching component oracle.ons.ic, 19.0.0.0.0...

Patching component oracle.xdk.xquery, 19.0.0.0.0...

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

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

Patching component oracle.ovm, 19.0.0.0.0...

Patching component oracle.dbdev, 19.0.0.0.0...

Patching component oracle.rdbms.dv, 19.0.0.0.0...

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

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

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

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

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

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

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

Patching component oracle.odbc, 19.0.0.0.0...

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

Patching component oracle.dbtoolslistener, 19.0.0.0.0...

Patching component oracle.ons, 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.rdbms.rman, 19.0.0.0.0...

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

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

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

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

Patching component oracle.mgw.common, 19.0.0.0.0...

Patching component oracle.xdk.rsf, 19.0.0.0.0...

Patching component oracle.oraolap, 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 33192793 successfully applied.
Sub-set patch [29517242] has become inactive due to the application of a super-set patch [33192793].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /data01/product/19.0.0/cfgtoollogs/opatch/opatch2021-12-03_20-05-40PM_1.log

OPatch succeeded.

Start the listener

-bash-4.2$ lsnrctl start

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 03-DEC-2021 22:34:53

Copyright (c) 1991, 2021, Oracle.  All rights reserved.

Starting /data01/product/19.0.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /data01/product/19.0.0/network/admin/listener.ora
Log messages written to /data01/base/diag/tnslsnr/orcl19x/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl19x)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl19x)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                03-DEC-2021 22:34:54
Uptime                    0 days 0 hr. 0 min. 20 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /data01/product/19.0.0/network/admin/listener.ora
Listener Log File         /data01/base/diag/tnslsnr/orcl19x/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl19x)(PORT=1521)))
Services Summary...
Service "orcl19x1" has 1 instance(s).
  Instance "orcl19x1", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

Start the database instance

-bash-4.2$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Dec 3 22:35:39 2021
Version 19.13.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup;
ORACLE instance started.

Total System Global Area 1560278088 bytes
Fixed Size                  9135176 bytes
Variable Size             905969664 bytes
Database Buffers          637534208 bytes
Redo Buffers                7639040 bytes
Database mounted.
Database opened.

Run the datapatch to perform the post patch SQL fixes

-bash-4.2$ /data01/product/19.0.0/OPatch/datapatch -verbose
SQL Patching tool version 19.13.0.0.0 Production on Fri Dec  3 22:59:50 2021
Copyright (c) 2012, 2021, Oracle.  All rights reserved.

Log file for this invocation: /data01/base/cfgtoollogs/sqlpatch/sqlpatch_6788_2021_12_03_22_59_50/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
Error: prereq checks failed!
verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table
Prereq check failed, exiting without installing any patches.

Please refer to MOS Note 1609718.1 and/or the invocation log
/data01/base/cfgtoollogs/sqlpatch/sqlpatch_6788_2021_12_03_22_59_50/sqlpatch_invocation.log
for information on how to resolve the above errors.

SQL Patching tool complete on Fri Dec  3 22:59:55 2021
-bash-4.2$ /data01/product/19.0.0/OPatch/datapatch -verbose
SQL Patching tool version 19.13.0.0.0 Production on Fri Dec  3 23:11:51 2021
Copyright (c) 2012, 2021, Oracle.  All rights reserved.

Log file for this invocation: /data01/base/cfgtoollogs/sqlpatch/sqlpatch_7201_2021_12_03_23_11_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.13.0.0.0 Release_Update 211004165050: Installed
  PDB CDB$ROOT:
    No release update patches installed
  PDB PDB$SEED:
    No release update patches installed
  PDB PDB1:
    No release update patches installed
  PDB PDB2:
    No release update patches installed

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED PDB1 PDB2
    No interim patches need to be rolled back
    Patch 33192793 (Database Release Update : 19.13.0.0.211019 (33192793)):
      Apply from 19.1.0.0.0 Feature Release to 19.13.0.0.0 Release_Update 211004165050
    No interim patches need to be applied
Installing patches...

Patch installation complete.  Total patches installed: 4

Validating logfiles...done
Patch 33192793 apply (pdb CDB$ROOT): SUCCESS
  logfile: /data01/base/cfgtoollogs/sqlpatch/33192793/24462514/33192793_apply_DBEMT_CDBROOT_2021Dec03_23_14_15.log (no errors)
Patch 33192793 apply (pdb PDB$SEED): SUCCESS
  logfile: /data01/base/cfgtoollogs/sqlpatch/33192793/24462514/33192793_apply_DBEMT_PDBSEED_2021Dec03_23_44_35.log (no errors)
Patch 33192793 apply (pdb PDB1): SUCCESS
  logfile: /data01/base/cfgtoollogs/sqlpatch/33192793/24462514/33192793_apply_DBEMT_PDB1_2021Dec03_23_44_36.log (no errors)
Patch 33192793 apply (pdb PDB2): WITH ERRORS
  logfile: /data01/base/cfgtoollogs/sqlpatch/33192793/24462514/33192793_apply_DBEMT_PDB2_2021Dec04_00_19_11.log (errors)
  -> Error at line 301629: script md/admin/catmdloc.sql
      - ORA-04031: unable to allocate 4096 bytes of shared memory ("java
      - pool","java/time/Period","JOXLE^575d66d7",":SGAClass")

Automatic recompilation incomplete; run utlrp.sql to revalidate.
  PDBs: PDB1 PDB2 PDB$SEED


Please refer to MOS Note 1609718.1 and/or the invocation log
/data01/base/cfgtoollogs/sqlpatch/sqlpatch_7201_2021_12_03_23_11_51/sqlpatch_invocation.log
for information on how to resolve the above errors.

SQL Patching tool complete on Sat Dec  4 00:42:15 2021

Check the latest applied patch

select PATCH_ID,PATCH_UID,PATCH_TYPE,ACTION,STATUS,DESCRIPTION,SOURCE_VERSION,TARGET_VERSION from dba_registry_sqlpatch;

  PATCH_ID  PATCH_UID PATCH ACTION     STATUS          DESCRIPTION          SOURCE_VER TARGET_VERSION
---------- ---------- ----- ---------- --------------- -------------------- ---------- ---------------
  33192793   24462514 RU    APPLY      SUCCESS         Database Release Upd 19.1.0.0.0 19.13.0.0.0
                                                       ate : 19.13.0.0.2110
                                                       19 (33192793)

Validate the application connectivity

Leave a Reply