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
| Name | Download Link |
|---|---|
| Database Release Update 19.12.0.0.210720 | Patch 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