Description:-
This article we are going to see steps used to apply the Oracle 19c Database Release Update Revision 19.4.1.0.0
The environment is single instance database.
Check More information on Oracle Support
Oracle Database 19c Proactive Patch Information (Doc ID 2521164.1)
Database 19c Release Updates and Revisions Bugs Fixed Lists (Doc ID 2523220.1)
Oracle Database 19c Release Update & Release Update Revision October 2019 Known Issues (Doc ID 2568305.1)
Note:-
1)Review readme file on Patch 30080447 – Database Release Update Revision 19.4.1.0.191015
2)Download patch p30080447_190000_Linux-x86-64
3)Make sure the opatch version is minimum 12.2.0.1.17
[oracle@dev19c admin]$ export ORACLE_SID=orcl
[oracle@dev19c admin]$ export ORACLE_HOME=/u01/app/oracle/product/19.3.0/db_1
[oracle@dev19c admin]$ export PATH=/u01/app/oracle/product/19.3.0/db_1/OPatch:$PATH
[oracle@dev19c admin]$ opatch version
OPatch Version: 12.2.0.1.17
OPatch succeeded.
Download the Patch from oracle support
Step:-1 We have copied the patch to DB Server:-
[oracle@dev19c ~]$ cd /home/oracle/patch/RUR
[oracle@dev19c RUR]$ ls -lrt
-rwxrw-rw-. 1 oracle oinstall 739201401 Oct 17 20:05 p30080447_190000_Linux-x86-64.zip
Step:-2 unzip p30080447_190000_Linux-x86-64
Step:-3 Check Patches status before apply using below query
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 A32
COLUMN status FORMAT A10
COLUMN version FORMAT A10
alter session set “_exclude_seed_cdb_view”=FALSE;
spool check_patches_19c.txt
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;
spool off
Step:-4 Take Backup of ORACLE_HOME and Database (Rollback plan)
cd $ORACLE_HOME
tar -cvf oracle_home_oct17_2019.tar $ORACLE_HOME
Connect with rman take full backup
Step 5:- Shutdown Database and Listener
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
——— ——————–
ORCL READ WRITE
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.4.0.0.0
[oracle@dev19c patch]$ lsnrctl stop
LSNRCTL for Linux: Version 19.0.0.0.0 – Production on 17-OCT-2019 20:26:53
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.125.155)(PORT=1521)))
The command completed successfully
Step:-6 Apply RUR patch on ORACLE_HOME 19c
[oracle@dev19c RUR]$ ls -lrt
total 722052
drwxr-xr-x. 4 oracle oinstall 63 Sep 19 19:39 30080447
-rw-rw-r–. 1 oracle oinstall 142836 Oct 15 20:26 PatchSearch.xml
-rwxrw-rw-. 1 oracle oinstall 739201401 Oct 17 20:05 p30080447_190000_Linux-x86-64.zip
-rw-r–r–. 1 oracle oinstall 103 Oct 17 20:23 offexit.lst
-rw-r–r–. 1 oracle oinstall 26457 Oct 17 20:26 check_patches_19c.txt
[oracle@dev19c RUR]$ cd 30080447
[oracle@dev19c 30080447]$ export ORACLE_SID=ORCL
[oracle@dev19c 30080447]$ export ORACLE_HOME=/u01/app/oracle/product/19.3.0/db_1
[oracle@dev19c 30080447]$ export PATH=/u01/app/oracle/product/19.3.0/db_1/OPatch:$PATH
[oracle@dev19c 30080447]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2019-10-17_20-30-40PM_1.log
Verifying environment and performing prerequisite checks…
OPatch continues with these patches: 30080447
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 = ‘/u01/app/oracle/product/19.3.0/db_1’)
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files…
Applying interim patch ‘30080447’ to OH ‘/u01/app/oracle/product/19.3.0/db_1’
ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.options.olap.awm, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.nlsrtl.companion, 19.0.0.0.0 ] , [ oracle.assistants.usm, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.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, 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.ldap.rsf, 19.0.0.0.0…
Patching component oracle.network.rsf, 19.0.0.0.0…
Patching component oracle.rdbms.dbscripts, 19.0.0.0.0…
Patching component oracle.sdo, 19.0.0.0.0…
Patching component oracle.sqlplus, 19.0.0.0.0…
Patching component oracle.odbc, 19.0.0.0.0…
Patching component oracle.xdk, 19.0.0.0.0…
Patching component oracle.ons, 19.0.0.0.0…
Patching component oracle.network.client, 19.0.0.0.0…
Patching component oracle.rdbms.deconfig, 19.0.0.0.0…
Patching component oracle.ctx.atg, 19.0.0.0.0…
Patching component oracle.rdbms.util, 19.0.0.0.0…
Patching component oracle.ovm, 19.0.0.0.0…
Patching component oracle.dbjava.jdbc, 19.0.0.0.0…
Patching component oracle.sdo.locator.jrf, 19.0.0.0.0…
Patching component oracle.install.deinstalltool, 19.0.0.0.0…
Patching component oracle.rdbms.oci, 19.0.0.0.0…
Patching component oracle.sdo.locator, 19.0.0.0.0…
Patching component oracle.rdbms.rman, 19.0.0.0.0…
Patching component oracle.ldap.security.osdt, 19.0.0.0.0…
Patching component oracle.ctx.rsf, 19.0.0.0.0…
Patching component oracle.dbjava.ucp, 19.0.0.0.0…
Patching component oracle.network.listener, 19.0.0.0.0…
Patching component oracle.ldap.owm, 19.0.0.0.0…
Patching component oracle.xdk.rsf, 19.0.0.0.0…
Patching component oracle.rdbms.install.plugins, 19.0.0.0.0…
Patching component oracle.duma, 19.0.0.0.0…
Patching component oracle.rdbms.dv, 19.0.0.0.0…
Patching component oracle.dbdev, 19.0.0.0.0…
Patching component oracle.oracore.rsf, 19.0.0.0.0…
Patching component oracle.oraolap.dbscripts, 19.0.0.0.0…
Patching component oracle.xdk.parser.java, 19.0.0.0.0…
Patching component oracle.ldap.rsf.ic, 19.0.0.0.0…
Patching component oracle.nlsrtl.rsf, 19.0.0.0.0…
Patching component oracle.sqlplus.ic, 19.0.0.0.0…
Patching component oracle.dbjava.ic, 19.0.0.0.0…
Patching component oracle.nlsrtl.rsf.core, 19.0.0.0.0…
Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0…
Patching component oracle.precomp.lang, 19.0.0.0.0…
Patching component oracle.precomp.common, 19.0.0.0.0…
Patch 30080447 successfully applied.
Sub-set patch [29834717] has become inactive due to the application of a super-set patch [30080447].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2019-10-17_20-30-40PM_1.log
OPatch succeeded.
Step:-7 Startup the Database and Listener
[oracle@dev19c 30080447]$ lsnrctl start
LSNRCTL for Linux: Version 19.0.0.0.0 – Production on 17-OCT-2019 20:38:42
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Starting /u01/app/oracle/product/19.3.0/db_1/bin/tnslsnr: please wait…
TNSLSNR for Linux: Version 19.0.0.0.0 – Production
System parameter file is /u01/app/oracle/product/19.3.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/dev19c/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.125.155)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.125.155)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 – Production
Start Date 17-OCT-2019 20:38:42
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/19.3.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/dev19c/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.125.155)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary…
Service “dbwr” has 1 instance(s).
Instance “orcl”, status UNKNOWN, has 1 handler(s) for this service…
Service “orcl” has 1 instance(s).
[oracle@dev19c 30080447]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 – Production on Thu Oct 17 20:38:53 2019
Version 19.4.1.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1258290752 bytes
Fixed Size 8896064 bytes
Variable Size 989855744 bytes
Database Buffers 251658240 bytes
Redo Buffers 7880704 bytes
Database mounted.
Database opened.
Step:-8 Execute post patch steps and run datapatch command
[oracle@dev19c 30080447]$ cd $ORACLE_HOME/OPatch
[oracle@dev19c OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.4.1.0.0 Production on Thu Oct 17 20:41:45 2019
Copyright (c) 2012, 2019, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_6357_2019_10_17_20_41_45/sqlpatch_invocation.log
Connecting to database…OK
Gathering database info…done
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.4.1.0.0 Release_Update_Revision 190819162456: Installed
SQL registry:
Rolled back to 19.4.0.0.0 Release_Update 190626171128 successfully on 17-OCT-19 07.27.41.455226 PM
Adding patches to installation queue and performing prereq checks…done
Installation queue:
No interim patches need to be rolled back
Patch 30080447 (Database Release Update Revision : 19.4.1.0.191015 (30080447)):
Apply from 19.4.0.0.0 Release_Update 190626171128 to 19.4.1.0.0 Release_Update_Revision 190819162456
No interim patches need to be applied
Installing patches…
Patch installation complete. Total patches installed: 1
Validating logfiles…done
Patch 30080447 apply: SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30080447/23123983/30080447_apply_ORCL_2019Oct17_20_42_23.log (no errors)
SQL Patching tool complete on Thu Oct 17 20:42:43 2019
Step:-9 After applying RU patch,Check the DBA_REGISTRY_SQLPATCH
Step:-10 Check opatch lsinventory and list of patches applied in ORACLE_HOME
[oracle@dev19c OPatch]$ opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2019-10-17_20-49-02PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2019-10-17_20-49-02PM.txt
——————————————————————————–
Local Machine Information::
Hostname: dev19c
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 30080447 : applied on Thu Oct 17 20:32:02 IST 2019
Unique Patch ID: 23123983
Patch description: “Database Release Update Revision : 19.4.1.0.191015 (30080447)”
Created on 19 Sep 2019, 07:09:42 hrs PST8PDT
Bugs fixed:
29225758, 29389889, 14735102, 17428816, 19080742, 19697993, 20313356
21374587, 21965541, 23296836, 23606241, 25756945, 25806201, 25883179
25986062, 25997810, 26476244, 26611353, 26739322, 26872233, 27126938
27244999, 27359766, 27369515, 27423500, 27453490, 27666312, 27710072
27846298, 27957203, 28064977, 28072567, 28125947, 28129791, 28181021
28210681, 28271693, 28279456, 28313275, 28326928, 28350595, 28371123
28379065, 28381939, 28390273, 28431445, 28463226, 28475242, 28489419
28502773, 28513333, 28534475, 28547068, 28561704, 28569897, 28572533
28572544, 28572667, 28572834, 28587723, 28593682, 28594086, 28597221
28601957, 28605066, 28606598, 28612239, 28625862, 28627033, 28636532
28643718, 28644549, 28645570, 28646200, 28646939, 28649388, 28655209
28663782, 28673945, 28692275, 28694872, 28696373, 28705231, 28710385
28710734, 28714461, 28715727, 28718469, 28719348, 28720418, 28722229
28730079, 28740708, 28742555, 28749853, 28755011, 28758722, 28760206
28767240, 28772390, 28774416, 28777214, 28781754, 28785531, 28789531
28791852, 28795551, 28802734, 28804517, 28810381, 28811560, 28815123
28815355, 28819640, 28824482, 28827682, 28833912, 28835937, 28849776
28854004, 28862532, 28863432, 28867992, 28873575, 28876253, 28876639
28884931, 28888327, 28889730, 28892794, 28897512, 28899663, 28901126
28905457, 28907196, 28912691, 28915561, 28917080, 28918429, 28919145
28922227, 28922532, 28922608, 28925634, 28925880, 28933158, 28936114
28937717, 28938698, 28940179, 28940281, 28941901, 28942455, 28945421
28945994, 28950868, 28951533, 28952168, 28954762, 28955606, 28956908
28957292, 28957723, 28962775, 28965231, 28966444, 28974083, 28977322
28983095, 28983486, 28986207, 28986231, 28986326, 28986481, 28988482
28989306, 28993295, 28993353, 28994307, 28996376, 29000000, 29001305
29001888, 29002784, 29002927, 29003738, 29006318, 29006621, 29007321
29007775, 29008035, 29008669, 29009513, 29011936, 29012609, 29013475
29014076, 29015118, 29017265, 29018655, 29019121, 29021063, 29021352
29024054, 29024552, 29024732, 29026582, 29026606, 29027456, 29027694
29027940, 29031575, 29031600, 29032234, 29032276, 29032457, 29032607
29033052, 29033145, 29033200, 29033280, 29034587, 29037290, 29038528
29039089, 29039510, 29040739, 29043554, 29043651, 29043725, 29044763
29044954, 29047850, 29048178, 29048289, 29048498, 29048605, 29050357
29050560, 29050765, 29051702, 29051953, 29052726, 29053783, 29056024
29056270, 29056560, 29056767, 29059011, 29061959, 29062692, 29062848
29062860, 29062868, 29110526, 29110783, 29110790, 29110797, 29110802
29110805, 29111598, 29113282, 29113305, 29117526, 29117642, 29119077
29120223, 29122224, 29122254, 29123297, 29123432, 29123482, 29124368
29125036, 29125374, 29125380, 29126345, 29127957, 29128693, 29128935
29129450, 29129497, 29129712, 29130219, 29131539, 29132938, 29134447
29135383, 29135649, 29136111, 29138641, 29141316, 29141341, 29141685
29142609, 29142667, 29144995, 29145214, 29145730, 29149829, 29150338
29151520, 29152357, 29155099, 29157389, 29158680, 29158899, 29159909
29159936, 29160174, 29162095, 29163156, 29163415, 29163437, 29163524
29163567, 29167111, 29167342, 29167374, 29167940, 29168219, 29168433
29169073, 29169215, 29171683, 29171942, 29172618, 29172826, 29173140
29173373, 29173817, 29174004, 29176318, 29177466, 29177543, 29177886
29178385, 29180313, 29180455, 29180559, 29180893, 29181153, 29181231
29181620, 29181743, 29181923, 29182019, 29183912, 29184297, 29184666
29185193, 29186456, 29189302, 29189307, 29189889, 29190235, 29190474
29190740, 29191541, 29192419, 29192468, 29192685, 29193207, 29194205
29194367, 29194493, 29194827, 29194981, 29195279, 29195337, 29195758
29196725, 29199635, 29199733, 29200316, 29200700, 29201494, 29201539
29202104, 29202850, 29203122, 29203166, 29203425, 29203443, 29203604
29205281, 29205323, 29205419, 29205463, 29205767, 29205918, 29206109
29206605, 29207073, 29208260, 29208732, 29211457, 29211724, 29212012
29212433, 29212611, 29213351, 29213775, 29213850, 29213879, 29214561
29214960, 29216746, 29216984, 29217294, 29217472, 29217828, 29217848
29218570, 29219205, 29219273, 29220079, 29221248, 29221891, 29222031
29222784, 29223833, 29223859, 29223967, 29224065, 29224605, 29225076
29225168, 29227602, 29228869, 29229164, 29229754, 29229844, 29229955
29230252, 29230565, 29231133, 29232117, 29232154, 29233415, 29234123
29237538, 29240307, 29241345, 29241651, 29242017, 29242884, 29243958
29245137, 29245160, 29246163, 29247415, 29247712, 29247906, 29248495
29248552, 29248835, 29248858, 29249991, 29250059, 29250317, 29251259
29253184, 29253871, 29254031, 29254930, 29255178, 29255273, 29255431
29255435, 29256426, 29259119, 29259320, 29260452, 29261547, 29261906
29262512, 29262887, 29265448, 29266248, 29266899, 29267292, 29268412
29269171, 29269228, 29270585, 29273539, 29273570, 29273735, 29273812
29273847, 29274428, 29274564, 29274627, 29275461, 29276272, 29277317
29278218, 29279658, 29279751, 29279854, 29281527, 29281691, 29281796
29282233, 29282898, 29285503, 29285788, 29285956, 29286037, 29287130
29287705, 29292837, 29293072, 29293574, 29297863, 29297915, 29298220
29299049, 29299082, 29299844, 29301463, 29301566, 29302963, 29303918
29304781, 29306226, 29306713, 29311588, 29312310, 29312672, 29312734
29312753, 29313347, 29313417, 29313525, 29314539, 29317756, 29318410
29319441, 29321489, 29323946, 29324568, 29324735, 29325087, 29325105
29325257, 29325765, 29325993, 29327044, 29329042, 29329087, 29329807
29330361, 29331066, 29331209, 29331380, 29331493, 29332292, 29332395
29332771, 29333500, 29336843, 29337310, 29338315, 29338453, 29338780
29338913, 29339101, 29339155, 29341209, 29343086, 29345937, 29346057
29346211, 29346943, 29347620, 29348176, 29350052, 29351386, 29351716
29351735, 29351749, 29352298, 29352724, 29352867, 29352947, 29353271
29353432, 29353960, 29355654, 29356547, 29356704, 29356711, 29356752
29358509, 29358828, 29360285, 29360672, 29360911, 29360950, 29361472
29361801, 29363151, 29364171, 29364177, 29366940, 29367019, 29367561
29368253, 29372541, 29373418, 29373588, 29374179, 29375941, 29376346
29377986, 29378029, 29378834, 29378913, 29379978, 29382784, 29382815
29384781, 29384854, 29384864, 29385429, 29385652, 29386502, 29386635
29386660, 29387073, 29387274, 29388020, 29388072, 29388094, 29388524
29388830, 29390011, 29390435, 29390785, 29391030, 29394014, 29394140
29394749, 29395657, 29397954, 29397996, 29398488, 29398863, 29399100
29399121, 29399938, 29402131, 29404483, 29405012, 29405462, 29405651
29405996, 29407804, 29409149, 29410311, 29410834, 29411037, 29412066
29412269, 29417719, 29417884, 29420834, 29421059, 29423826, 29424999
29426241, 29429017, 29429264, 29429566, 29430524, 29431192, 29431485
29434301, 29435474, 29435652, 29436454, 29436514, 29437594, 29437712
29438277, 29438736, 29439522, 29441196, 29443187, 29443250, 29444072
29444282, 29444602, 29446669, 29449477, 29450421, 29451386, 29452576
29452936, 29452953, 29455424, 29457312, 29457370, 29457807, 29460252
29461791, 29462594, 29462767, 29462957, 29464779, 29465177, 29467622
29476473, 29483532, 29483672, 29483685, 29483712, 29483723, 29486181
29488894, 29489546, 29490256, 29492127, 29492939, 29494245, 29495057
29495684, 29497311, 29500826, 29502561, 29503543, 29503631, 29503827
29504492, 29504682, 29505668, 29507616, 29510278, 29511611, 29514479
29515134, 29515240, 29515766, 29515834, 29516300, 29516766, 29517168
29521187, 29521748, 29522358, 29522561, 29522662, 29523511, 29525467
29525886, 29527595, 29529147, 29530440, 29530515, 29530812, 29531654
29541769, 29542449, 29543034, 29546817, 29547867, 29548687, 29548722
29549154, 29549730, 29557336, 29558975, 29559187, 29559446, 29559908
29559981, 29565611, 29580983, 29581771, 29584261, 29586143, 29597536
29597754, 29598039, 29598233, 29599300, 29601461, 29604002, 29608000
29611020, 29611991, 29616244, 29616414, 29618074, 29618190, 29622936
29625065, 29626732, 29628200, 29629650, 29629681, 29631749, 29632095
29633697, 29635427, 29635717, 29637362, 29638285, 29641736, 29653246
29656819, 29657422, 29664087, 29664161, 29670782, 29676089, 29677051
29677733, 29679856, 29687459, 29687763, 29692694, 29695841, 29703932
29707099, 29707896, 29742223, 29747648, 29751094, 29753244, 29754951
29756274, 29757651, 29766207, 29766503, 29766679, 29775393, 29779196
29782211, 29795957, 29838773, 29850930, 30114534
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:
27222128, 27572040, 27604329, 27760043, 27877830, 28302580, 28470673
28621543, 28642469, 28699321, 28710663, 28755846, 28772816, 28785321
28800508, 28808652, 28815557, 28847541, 28847572, 28870496, 28871040
28874416, 28877252, 28881191, 28881848, 28888083, 28911140, 28925250
28925460, 28935956, 28940472, 3, 28942694, 28951332, 28963036, 28968779
28980448, 28995287, 29003207, 29003617, 29016294, 29018680, 29024876
29026154, 29027933, 29047127, 29052850, 29058476, 29111631, 29112455
29117337, 29123444, 29125708, 29125786, 29129476, 29131772, 29132456
29139727, 29146157, 29147849, 29149170, 29152603, 29152752, 29154631
29154636, 29154829, 29159216, 29159661, 29160462, 29161923, 29169540
29169739, 29170717, 29173618, 29181568, 29182920, 29183298, 29186091
29191827, 29201143, 29201695, 29209545, 29210577, 29210610, 29210624
29210683, 29213641, 29219627, 29224294, 29225861, 29229839, 29235934
29242906, 29243749, 29244495, 29244766, 29244968, 29248723, 29249583
29251564, 29255616, 29260224, 29261695, 29271019, 29273360, 29282090
29282666, 29285453, 29285621, 29290235, 29292232, 29293806, 29294753
29299830, 29307090, 29307109, 29311336, 29329675, 29330791, 29339299
29357821, 29360467, 29360775, 29367971, 29368725, 29379299, 29379381
29380527, 29381000, 29382296, 29391301, 29393649, 29402110, 29411931
29413360, 29457319, 29465047
——————————————————————————–
OPatch succeeded.
[oracle@dev19c OPatch]$
Step:-11 Any databases that have invalid objects after the execution of datapatch should have utlrp.sql run to revalidate those objects.
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql
Successfully applied the RUR Patch from oracle 19.4.0.0 to 19.4.1.0
Connect with me:-
Telegram App:https://t.me/oracledbwr
LinkedIn:https://www.linkedin.com/in/hariprasathdba
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page : https://www.facebook.com/dbahariprasath/?
Twitter : https://twitter.com/hariprasathdba
