upgrade - ORACLEAGENT BLOG

Patch Oracle Home 19c (19.3 to 19.9)

Here I am going to upgrade steps of Oracle Database Home 19c from 19.3 to 19.9 within Oracle Linux 8.2 The patch is 31771877 – Database Release Update 19.9.0.0.201020 Prerequisites: “You must use the OPatch utility version 12.2.0.1.19 or later to apply this patch.” from READ ME of the Patch 31771877 Checking current ORACLE_HOME – OPATCH Version:

[oracle@db101:USA] ./opatch version
OPatch Version: 12.2.0.1.17 
OPatch succeeded.

Hope everyone is aware of how to upgrade the opatch utility. We need to take a backup of the existing patch and replace our new downloaded opatch in the ORACLE_HOME location.

Step 1: Install OPatch utility “6880880”:

Backup the Old OPatch utility

[oracle@db101:USA] cd [oracle@db101:USA]ORACLE_HOME
[oracle@db101:USA] mv OPatch/ OPatch_backup

Set up the latest Optach Utility 12.2.0.1.23

[oracle@db101:USA] unzip p6880880_190000_Linux-x86-64.zip
[oracle@db101:USA] ./opatch version
OPatch Version: 12.2.0.1.23 
OPatch succeeded

Step 2: Install the patch 31771877

Stop all services using the Oracle HOME: Databases or Listeners, .. Install the Patch:

[oracle@db101:USA] unzip p31771877_190000_Linux-x86-64.zip
[oracle@db101:USA] cd 31771877/
[oracle@db101:USA] $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.23
Copyright (c) 2020, 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.23
OUI version : 12.2.0.7.0
Log file location : 
/u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2021-02-08_10-46-12AM_1.log
Verifying environment and performing prerequisite checks…
OPatch continues with these patches: 31771877 
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.0.0/db_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files…
Applying interim patch '31771877' to OH '/u01/app/oracle/product/19.0.0/db_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.awm, 19.0.0.0.0 ] , 
[ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , 
[ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , 
[ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.assistants.usm, 19.0.0.0.0 ] ,
 [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.sqlj, 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, 19.0.0.0.0…
Patching component oracle.rdbms.util, 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.ldap.rsf, 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.rdbms.dbscripts, 19.0.0.0.0…
Patching component oracle.rdbms.deconfig, 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.usm.deconfig, 19.0.0.0.0…
Patching component oracle.rdbms.crs, 19.0.0.0.0…
Patching component oracle.oraolap, 19.0.0.0.0…
Patching component oracle.precomp.rsf, 19.0.0.0.0…
Patching component oracle.javavm.client, 19.0.0.0.0…
Patching component oracle.precomp.common.core, 19.0.0.0.0…
Patching component oracle.network.client, 19.0.0.0.0…
Patching component oracle.rdbms.scheduler, 19.0.0.0.0…
Patching component oracle.ctx.atg, 19.0.0.0.0…
Patching component oracle.marvel, 19.0.0.0.0…
Patching component oracle.oraolap.dbscripts, 19.0.0.0.0…
Patching component oracle.ovm, 19.0.0.0.0…
Patching component oracle.bali.ice, 11.1.1.7.0…
Patching component oracle.ctx.rsf, 19.0.0.0.0…
Patching component oracle.rdbms.lbac, 19.0.0.0.0…
Patching component oracle.rdbms.oci, 19.0.0.0.0…
Patching component oracle.odbc, 19.0.0.0.0…
Patching component oracle.rdbms.rman, 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.drdaas, 19.0.0.0.0…
Patching component oracle.ldap.rsf.ic, 19.0.0.0.0…
Patching component oracle.ldap.security.osdt, 19.0.0.0.0…
Patching component oracle.network.listener, 19.0.0.0.0…
Patching component oracle.ons, 19.0.0.0.0…
Patching component oracle.rdbms.dv, 19.0.0.0.0…
Patching component oracle.javavm.server, 19.0.0.0.0…
Patching component oracle.xdk, 19.0.0.0.0…
Patching component oracle.ldap.owm, 19.0.0.0.0…
Patching component oracle.dbdev, 19.0.0.0.0…
Patching component oracle.rdbms.install.common, 19.0.0.0.0…
Patching component oracle.sdo.locator, 19.0.0.0.0…
Patching component oracle.duma, 19.0.0.0.0…
Patching component oracle.sqlplus.ic, 19.0.0.0.0…
Patching component oracle.xdk.rsf, 19.0.0.0.0…
Patching component oracle.xdk.parser.java, 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 31771877 successfully applied.
Sub-set patch [29517242] has become inactive due to the application of a super-set 
patch [31771877].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: 
/u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2021-02-08_10-46-12AM_1.log
OPatch succeeded.
[oracle@db101:USA 31771877]

Step 3: Check the upgrade:

[oracle@db101:USA 31771877]$ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.23
Copyright (c) 2020, 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.23
OUI version : 12.2.0.7.0
Log file location : 
/u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2021-02-08_10-53-14AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/19.0.0/db_1/
cfgtoollogs/opatch/lsinv/lsinventory2021-02-08_10-53-14AM.txt
Local Machine Information::
Hostname: db101.oracle.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.
Interim patches (2) :
Patch 31771877 : applied on Mon Jan 18 10:47:31 CET 2021
Unique Patch ID: 23869227
Patch description: "Database Release Update : 19.9.0.0.201020 (31771877)"
Created on 7 Oct 2020, 21:34:19 hrs PST8PDT
Bugs fixed:
30150710, 31935717, 7391838, 8460502, 8476681, 14735102, 17428816
17468475, 19080742, 19697993, 20313356, 21374587, 21639146, 21888352
21965541, 22580355, 22729345, 22748979, 23294761, 23296836, 23606241
23645975, 23734075, 23763462, 24596874, 24669730, 24687075, 24833686
24971456, 25030027, 25092651, 25093917, 25404117, 25416731, 25560538
25756945, 25804387, 25806201, 25809128, 25883179, 25905368, 25986062
25997810, 26001677, 26284288, 26352615, 26440142, 26476244, 26499997
26611353, 26668264, 26739322, 26777814, 26819036, 26872233, 27036163
27044169, 27101798, 27126122, 27126938, 27166935, 27195935, 27221350
27244999, 27254335, 27260704, 27261477, 27359766, 27369515, 27378053
27392968, 27406105, 27411022, 27423500, 27439716, 27453490, 27458357
27489107, 27582210, 27589260, 27629928, 27666312, 27692173, 27700413
27710072, 27729678, 27745728, 27801144, 27828892, 27846298, 27873364
27880025, 27929509, 27934711, 27935464, 27941110, 27957203, 27967484
28064977, 28072567, 28078186, 28092783, 28104176, 28109326, 28125947
28129791, 28138847, 28144569, 28181021, 28189466, 28204262, 28205555
28209985, 28210681, 28263142, 28271258, 28271693, 28276054, 28279456
28294563, 28313275, 28319114, 28322973, 28326928, 28350595, 28371123
28373960, 28375383, 28379065, 28381939, 28386259, 28390273, 28395302
28397317, 28402823, 28406374, 28410431, 28431445, 28435333, 28436414
28442896, 28454215, 28463226, 28475242, 28482048, 28484299, 28489419
28492006, 28498976, 28502773, 28504631, 28513333, 28521330, 28530171
28534475, 28535127, 28537481, 28538439, 28541606, 28542455, 28546290
28547068, 28547926, 28558645, 28561704, 28564479, 28565296, 28567417
28567819, 28569897, 28572407, 28572533, 28572544, 28572667, 28572834
28578945, 28587723, 28589509, 28593682, 28594086, 28597221, 28601957
28602253, 28605066, 28606598, 28608211, 28612239, 28618343, 28620697
28622202, 28625862, 28627033, 28628592, 28632796, 28636532, 28639299
28642899, 28643583, 28643654, 28643718, 28644549, 28645570, 28646200
28646939, 28649388, 28655209, 28661333, 28663289, 28663782, 28672457
28673945, 28681153, 28689483, 28690694, 28692103, 28692275, 28694639
28694872, 28696373, 28697526, 28703812, 28705231, 28707931, 28708400
28709063, 28710385, 28710469, 28710734, 28714461, 28715655, 28715727
28718469, 28719348, 28720204, 28720418, 28721497, 28722229, 28730079
28734355, 28740708, 28740799, 28742555, 28745367, 28749853, 28752923
28755011, 28758722, 28760206, 28765983, 28767240, 28769456, 28771947
28772390, 28774416, 28776431, 28776811, 28777214, 28778754, 28781599
28781754, 28785531, 28789531, 28791852, 28793062, 28794230, 28795551
28795734, 28802734, 28804517, 28805242, 28808314, 28808656, 28810381
28811560, 28813931, 28815123, 28815355, 28817449, 28819640, 28820669
28821847, 28824482, 28827682, 28831971, 28833912, 28835937, 28836716
28838385, 28844738, 28845346, 28846759, 28849776, 28850084, 28854004
28854733, 28855520, 28855922, 28857552, 28861861, 28862532, 28863263
28863432, 28863487, 28865569, 28867698, 28867992, 28872645, 28873575
28875089, 28876253, 28876639, 28876926, 28878865, 28882784, 28884931
28887305, 28888327, 28889389, 28889730, 28892794, 28897512, 28899663
28900506, 28901126, 28905390, 28905457, 28905615, 28907196, 28910498
28910586, 28912691, 28915561, 28917080, 28918429, 28919145, 28921844
28922227, 28922532, 28922608, 28925634, 28925880, 28927452, 28928462
28932914, 28933158, 28935293, 28936114, 28937717, 28938422, 28938698
28940179, 28940281, 28941901, 28942455, 28945421, 28945994, 28946233
28948554, 28949888, 28950868, 28951533, 28952168, 28954762, 28955606
28955883, 28956908, 28957292, 28957723, 28958088, 28959493, 28960863
28962775, 28965084, 28965095, 28965231, 28965376, 28966444, 28974083
28974999, 28977322, 28981871, 28983095, 28983486, 28984313, 28985478
28986207, 28986231, 28986257, 28986326, 28986481, 28986696, 28988482
28988864, 28989306, 28993295, 28993353, 28994307, 28994542, 28996376
29000000, 29001305, 29001888, 29002488, 29002784, 29002927, 29003407
29003738, 29006318, 29006621, 29007321, 29007353, 29007775, 29008035
29008669, 29009513, 29010126, 29010517, 29011936, 29012609, 29013475
29013832, 29014076, 29015118, 29017265, 29018655, 29019121, 29021063
29021352, 29022986, 29024054, 29024448, 29024552, 29024732, 29026582
29026606, 29027456, 29027694, 29027940, 29031575, 29031600, 29032234
29032276, 29032457, 29032607, 29033052, 29033145, 29033200, 29033280
29034587, 29036278, 29037290, 29038528, 29038728, 29039089, 29039510
29040739, 29041739, 29041775, 29043554, 29043651, 29043725, 29044086
29044763, 29044954, 29046482, 29047850, 29048178, 29048289, 29048498
29048605, 29048728, 29049673, 29050357, 29050560, 29050765, 29050886
29051263, 29051702, 29051953, 29052726, 29053783, 29055644, 29056024
29056270, 29056560, 29056767, 29056894, 29059011, 29060216, 29061016
29061959, 29062692, 29062848, 29062860, 29062868, 29110526, 29110783
29110790, 29110797, 29110802, 29110805, 29111598, 29113282, 29113305
29115857, 29117526, 29117642, 29118543, 29119077, 29120223, 29122224
29122254, 29122367, 29123297, 29123432, 29123482, 29124368, 29125036
29125374, 29125380, 29126345, 29127957, 29128693, 29128935, 29129450
29129497, 29129691, 29129712, 29130219, 29131539, 29132869, 29132938
29133470, 29134447, 29135383, 29135649, 29136111, 29138641, 29139070
29139761, 29139956, 29141316, 29141341, 29141685, 29141886, 29142609
29142667, 29143516, 29144995, 29145214, 29145730, 29146810, 29149829
29150338, 29151520, 29152357, 29154725, 29155099, 29157051, 29157389
29158680, 29158899, 29159909, 29159936, 29160174, 29161597, 29162095
29163073, 29163156, 29163415, 29163437, 29163524, 29163567, 29164376
29165682, 29167111, 29167342, 29167374, 29167940, 29168137, 29168219
29168433, 29169073, 29169215, 29170232, 29171683, 29171942, 29172618
29172826, 29173140, 29173373, 29173817, 29174004, 29174753, 29175638
29176318, 29177466, 29177543, 29177886, 29178385, 29179097, 29180313
29180455, 29180559, 29180721, 29180893, 29181078, 29181153, 29181231
29181620, 29181743, 29181923, 29182019, 29182517, 29182901, 29183912
29184297, 29184666, 29185193, 29186456, 29186605, 29188255, 29189302
29189307, 29189889, 29190235, 29190474, 29190663, 29190740, 29191541
29192419, 29192468, 29192685, 29193207, 29194205, 29194367, 29194493
29194827, 29194981, 29195279, 29195337, 29195758, 29196725, 29198092
29198913, 29199635, 29199733, 29200316, 29200700, 29201494, 29201539
29201787, 29202104, 29202461, 29202850, 29203122, 29203166, 29203227
29203425, 29203443, 29203604, 29205281, 29205323, 29205419, 29205463
29205767, 29205918, 29206109, 29206605, 29207073, 29208260, 29208732
29211457, 29211724, 29212012, 29212433, 29212611, 29213320, 29213351
29213613, 29213775, 29213850, 29213879, 29214561, 29214960, 29216312
29216723, 29216746, 29216984, 29217294, 29217472, 29217828, 29217848
29218570, 29219205, 29219273, 29220079, 29221248, 29221891, 29221942
29222031, 29222784, 29223833, 29223859, 29223967, 29224065, 29224605
29225076, 29225168, 29225758, 29227602, 29228869, 29229164, 29229754
29229844, 29229955, 29230252, 29230565, 29231133, 29232117, 29232154
29232449, 29232653, 29233415, 29233810, 29233953, 29234123, 29236573
29237538, 29237575, 29237744, 29240307, 29240668, 29240759, 29241345
29241651, 29242017, 29242884, 29243958, 29245063, 29245137, 29245160
29246163, 29247415, 29247712, 29247906, 29248495, 29248552, 29248835
29248858, 29249289, 29249412, 29249991, 29250059, 29250317, 29251259
29253184, 29253871, 29254031, 29254930, 29255178, 29255273, 29255431
29255435, 29255718, 29255973, 29256426, 29259119, 29259320, 29260452
29260956, 29261547, 29261548, 29261906, 29262512, 29262887, 29265448
29266248, 29266899, 29267292, 29268412, 29269171, 29269228, 29269825
29270585, 29273539, 29273570, 29273735, 29273812, 29273847, 29274428
29274564, 29274627, 29275461, 29276272, 29277317, 29278218, 29278684
29279658, 29279751, 29279854, 29281527, 29281691, 29281796, 29282233
29282898, 29285197, 29285503, 29285788, 29285956, 29286037, 29286229
29287130, 29287705, 29290110, 29292837, 29293072, 29293574, 29296257
29297863, 29297915, 29298220, 29299049, 29299082, 29299844, 29301463
29301566, 29302963, 29303918, 29304314, 29304692, 29304781, 29304853
29306226, 29306713, 29307638, 29309698, 29311528, 29311588, 29311927
29312310, 29312672, 29312734, 29312753, 29312889, 29313347, 29313417
29313525, 29314539, 29314636, 29317756, 29318410, 29319441, 29320900
29321489, 29323946, 29324568, 29324735, 29325087, 29325105, 29325257
29325765, 29325993, 29327044, 29327892, 29329042, 29329087, 29329807
29330361, 29331066, 29331209, 29331380, 29331493, 29332292, 29332395
29332763, 29332771, 29333500, 29336843, 29336899, 29337294, 29337310
29337742, 29338315, 29338348, 29338453, 29338780, 29338913, 29339101
29339155, 29341209, 29342099, 29343086, 29343156, 29343861, 29344541
29345937, 29346057, 29346211, 29346943, 29347620, 29348176, 29348358
29350052, 29350712, 29350762, 29350868, 29351044, 29351386, 29351662
29351716, 29351735, 29351749, 29351771, 29352298, 29352724, 29352867
29352947, 29353271, 29353432, 29353718, 29353821, 29353960, 29355654
29356547, 29356704, 29356711, 29356752, 29356782, 29358509, 29358828
29360252, 29360285, 29360672, 29360911, 29360950, 29361319, 29361472
29361801, 29362596, 29363151, 29364171, 29364177, 29366406, 29366940
29367019, 29367561, 29368253, 29368310, 29372069, 29372541, 29372562
29373418, 29373588, 29374179, 29375355, 29375941, 29375984, 29376346
29377804, 29377986, 29378029, 29378287, 29378834, 29378913, 29379750
29379978, 29382641, 29382784, 29382815, 29383695, 29384781, 29384854
29384864, 29385339, 29385429, 29385652, 29386502, 29386557, 29386635
29386660, 29386835, 29387073, 29387274, 29387310, 29387337, 29388020
29388072, 29388094, 29388524, 29388830, 29389408, 29389889, 29390011
29390435, 29390785, 29391030, 29391237, 29391438, 29391849, 29391925
29392554, 29392966, 29393291, 29394014, 29394140, 29394749, 29395657
29397954, 29397996, 29398488, 29398863, 29399046, 29399100, 29399121
29399336, 29399938, 29402131, 29404483, 29405012, 29405462, 29405651
29405996, 29407488, 29407804, 29408853, 29409149, 29409455, 29410311
29410834, 29411037, 29411469, 29412066, 29412269, 29413382, 29413517
29413544, 29413634, 29413956, 29416688, 29416700, 29417084, 29417173
29417719, 29417884, 29418165, 29420254, 29420834, 29421059, 29423003
29423016, 29423156, 29423491, 29423826, 29424999, 29426241, 29426320
29428230, 29429017, 29429087, 29429264, 29429466, 29429566, 29429895
29430524, 29430866, 29431192, 29431485, 29432176, 29434301, 29434869
29435474, 29435652, 29436454, 29436514, 29436522, 29436727, 29437379
29437594, 29437712, 29438150, 29438277, 29438736, 29439522, 29440651
29441196, 29442936, 29443187, 29443250, 29443559, 29444072, 29444282
29444602, 29446319, 29446669, 29448498, 29449477, 29449845, 29449852
29450162, 29450193, 29450421, 29450812, 29450936, 29451386, 29452251
29452576, 29452936, 29452953, 29454450, 29454978, 29455424, 29455773
29456538, 29456714, 29457312, 29457370, 29457502, 29457807, 29457978
29460252, 29461420, 29461791, 29461971, 29462594, 29462767, 29462957
29463047, 29463528, 29463798, 29464616, 29464779, 29465177, 29466674
29467622, 29469563, 29469565, 29470059, 29470291, 29471633, 29471832
29471860, 29472618, 29473708, 29476473, 29477015, 29481584, 29482021
29483452, 29483532, 29483626, 29483672, 29483685, 29483712, 29483723
29483771, 29485099, 29485877, 29486181, 29486848, 29487150, 29487189
29488894, 29489436, 29489546, 29490256, 29492127, 29492939, 29493122
29494245, 29495057, 29495684, 29497311, 29497588, 29497696, 29498198
29500257, 29500826, 29500963, 29501218, 29502561, 29503543, 29503631
29503827, 29504103, 29504492, 29504682, 29505668, 29506942, 29507270
29507616, 29508681, 29509777, 29510278, 29511064, 29511611, 29511980
29512890, 29514479, 29515134, 29515240, 29515476, 29515766, 29515834
29516300, 29516727, 29516766, 29517168, 29517883, 29519131, 29521187
29521688, 29521748, 29521862, 29522358, 29522561, 29522662, 29523055
29523216, 29523511, 29524599, 29524985, 29525366, 29525467, 29525886
29526966, 29527595, 29527610, 29528368, 29529147, 29530440, 29530515
29530812, 29530909, 29531654, 29531836, 29532532, 29536342, 29536445
29537829, 29538631, 29541742, 29541769, 29541973, 29542084, 29542449
29542580, 29542643, 29543034, 29543956, 29544552, 29546817, 29547010
29547867, 29548413, 29548427, 29548592, 29548687, 29548722, 29549040
29549071, 29549104, 29549154, 29549730, 29552402, 29552773, 29553141
29554092, 29555105, 29557144, 29557261, 29557336, 29557556, 29558238
29558452, 29558975, 29559187, 29559395, 29559446, 29559908, 29559981
29564592, 29564593, 29565611, 29579919, 29580394, 29580983, 29581771
29584261, 29584693, 29586143, 29587299, 29587765, 29588732, 29589544
29591343, 29592011, 29592215, 29597536, 29597754, 29598039, 29598046
29598226, 29598233, 29599008, 29599300, 29601461, 29602831, 29603460
29603884, 29604002, 29604257, 29606261, 29607136, 29607797, 29608000
29608023, 29610506, 29611020, 29611991, 29614206, 29614987, 29615824
29616244, 29616414, 29618074, 29618190, 29620042, 29622936, 29623323
29623592, 29624124, 29625065, 29625804, 29625876, 29626154, 29626732
29628200, 29629430, 29629650, 29629681, 29629745, 29631749, 29632095
29632265, 29632611, 29633697, 29633753, 29633936, 29634643, 29635427
29635717, 29635990, 29637362, 29637526, 29637560, 29638285, 29641736
29643721, 29644426, 29644464, 29645167, 29645349, 29647176, 29647770
29648928, 29651183, 29651520, 29652809, 29653132, 29653246, 29655164
29655668, 29656400, 29656819, 29656843, 29657399, 29657422, 29657744
29657960, 29658056, 29661028, 29661065, 29661722, 29663191, 29663368
29663494, 29663601, 29664087, 29664161, 29665168, 29665940, 29667527
29667994, 29668005, 29669413, 29670782, 29671363, 29672507, 29675446
29676089, 29677051, 29677173, 29677733, 29677927, 29679856, 29681987
29683039, 29683211, 29684518, 29685137, 29685276, 29687214, 29687220
29687459, 29687718, 29687727, 29687763, 29688867, 29689145, 29689255
29692694, 29694869, 29695425, 29695821, 29695841, 29695964, 29696310
29700125, 29700460, 29700770, 29701720, 29703932, 29705793, 29707099
29707493, 29707896, 29708353, 29708876, 29708915, 29710188, 29710858
29713810, 29715220, 29715703, 29716194, 29716227, 29716491, 29716602
29716871, 29717659, 29717901, 29719146, 29720133, 29721418, 29721576
29722167, 29724658, 29725476, 29725781, 29726695, 29738374, 29738400
29739576, 29741319, 29741976, 29742223, 29744225, 29744400, 29745288
29746962, 29747493, 29747648, 29747653, 29748285, 29748336, 29748513
29749471, 29750673, 29751094, 29753244, 29754196, 29754951, 29755821
29756274, 29756444, 29757099, 29757264, 29757651, 29757687, 29758203
29758217, 29758661, 29761678, 29761837, 29761911, 29763158, 29765035
29765393, 29766207, 29766435, 29766503, 29766679, 29768487, 29768899
29769901, 29770750, 29771032, 29771242, 29773197, 29773205, 29773842
29775393, 29779196, 29780140, 29782211, 29782823, 29782866, 29784106
29785239, 29785311, 29787292, 29787766, 29789911, 29791152, 29791880
29792213, 29792433, 29793318, 29794174, 29794462, 29795712, 29795957
29796335, 29796378, 29797209, 29797726, 29802382, 29802695, 29804875
29805368, 29805772, 29806390, 29807964, 29809792, 29809837, 29812084
29812489, 29813503, 29813650, 29813671, 29815341, 29815713, 29817278
29817547, 29817784, 29821130, 29821582, 29822714, 29825525, 29827647
29827852, 29828644, 29831196, 29833984, 29834506, 29836096, 29838337
29838485, 29838773, 29839715, 29840619, 29841267, 29841687, 29843277
29843692, 29843831, 29844131, 29844226, 29844275, 29845530, 29846126
29846645, 29846688, 29848084, 29848849, 29849100, 29850930, 29851733
29853485, 29856859, 29858121, 29858376, 29859068, 29860994, 29861075
29864203, 29864261, 29865188, 29865590, 29865658, 29869086, 29869149
29869404, 29869887, 29869906, 29870065, 29871098, 29871312, 29871360
29872401, 29872937, 29872983, 29873665, 29874090, 29874761, 29875459
29875565, 29876358, 29876989, 29877608, 29878076, 29881050, 29881478
29881575, 29881643, 29881839, 29882427, 29882454, 29882729, 29884958
29885182, 29885890, 29886809, 29887045, 29887111, 29888621, 29889184
29889358, 29890740, 29891075, 29891853, 29891916, 29892604, 29893132
29896510, 29897418, 29897863, 29900203, 29900824, 29901419, 29902299
29902327, 29902330, 29902659, 29903190, 29903299, 29903357, 29903454
29904002, 29906678, 29907942, 29908389, 29908777, 29909658, 29910402
29912286, 29913805, 29913966, 29914449, 29914544, 29915217, 29915848
29916975, 29919789, 29920025, 29920376, 29920804, 29921318, 29922225
29922461, 29923452, 29924181, 29926466, 29927756, 29928210, 29928340
29928427, 29928564, 29930457, 29932202, 29932430, 29932780, 29934052
29935685, 29937565, 29937655, 29937956, 29938225, 29939400, 29939795
29940373, 29941062, 29942096, 29942554, 29943670, 29943879, 29944035
29944159, 29944660, 29944963, 29945645, 29946388, 29947145, 29948165
29950220, 29951620, 29951759, 29956016, 29956222, 29957412, 29957493
29958925, 29960884, 29961353, 29961609, 29961847, 29962160, 29962248
29962834, 29962927, 29962939, 29965052, 29965603, 29965888, 29966768
29967223, 29968085, 29969557, 29970081, 29970298, 29971027, 29971481
29971888, 29971936, 29971951, 29972176, 29973012, 29989783, 29989845
29991257, 29993717, 29997326, 29997553, 30000664, 30001331, 30003187
30006159, 30006985, 30007450, 30007797, 30008125, 30008198, 30008214
30009710, 30012181, 30015070, 30017836, 30018017, 30018903, 30019864
30024618, 30025814, 30026016, 30027614, 30028599, 30029519, 30029806
30031027, 30032376, 30033040, 30033547, 30034456, 30035598, 30036258
30038392, 30039800, 30039959, 30040157, 30041501, 30041514, 30042490
30043398, 30043610, 30043930, 30044108, 30044507, 30045389, 30045484
30046497, 30047531, 30047702, 30047765, 30047931, 30048688, 30049966
30051176, 30051783, 30051804, 30052928, 30053036, 30053501, 30053748
30054980, 30056058, 30057718, 30057799, 30058149, 30058453, 30059106
30059109, 30060267, 30060330, 30062364, 30062819, 30064268, 30066352
30067565, 30068384, 30068871, 30071446, 30072905, 30073314, 30073744
30074296, 30074349, 30074469, 30074472, 30074820, 30075037, 30076058
30076197, 30076253, 30076604, 30078675, 30078934, 30079949, 30080266
30081546, 30081580, 30082145, 30083100, 30083216, 30083488, 30083807
30084971, 30085897, 30086596, 30086992, 30090568, 30092280, 30092859
30095591, 30095952, 30097092, 30097115, 30098251, 30099302, 30099420
30099454, 30100354, 30101186, 30103551, 30103553, 30104378, 30104555
30106748, 30109365, 30110224, 30110370, 30110518, 30114477, 30114489
30114534, 30116085, 30116203, 30116854, 30117209, 30117335, 30117469
30117593, 30118261, 30118279, 30120608, 30122583, 30125765, 30126145
30127145, 30127522, 30127805, 30127904, 30128047, 30130240, 30131286
30131645, 30132708, 30133841, 30135396, 30135731, 30135942, 30136346
30139392, 30142907, 30143470, 30143593, 30146593, 30146969, 30147473
30147928, 30148999, 30149035, 30149658, 30150606, 30153552, 30153885
30154633, 30155241, 30155814, 30155837, 30159329, 30159511, 30159536
30159752, 30159760, 30161094, 30163243, 30164714, 30165493, 30165503
30165897, 30167787, 30169254, 30170104, 30172925, 30173113, 30173556
30174401, 30175291, 30177597, 30178250, 30178839, 30178990, 30179644
30180208, 30180643, 30181756, 30182498, 30183696, 30183715, 30183920
30184102, 30185852, 30186319, 30186476, 30186706, 30187866, 30189516
30190090, 30191274, 30192691, 30193165, 30193505, 30193736, 30194612
30194710, 30194972, 30195667, 30195668, 30195684, 30196195, 30196358
30196629, 30198861, 30198905, 30199890, 30200034, 30200132, 30200237
30200680, 30200758, 30202349, 30202388, 30203929, 30204042, 30204542
30206493, 30206675, 30207473, 30208327, 30208723, 30209736, 30210884
30213031, 30213540, 30215130, 30215302, 30215351, 30217206, 30217562
30217982, 30218044, 30218317, 30219222, 30221237, 30221298, 30222512
30223712, 30223847, 30224650, 30224868, 30224950, 30225265, 30225439
30225443, 30225718, 30225844, 30226244, 30228567, 30229683, 30232638
30235919, 30235979, 30236554, 30237477, 30238211, 30238715, 30239480
30240010, 30240547, 30240930, 30241567, 30241807, 30241920, 30242120
30242724, 30243216, 30244340, 30246053, 30246179, 30247305, 30249432
30251003, 30252005, 30252098, 30252156, 30252458, 30252977, 30253035
30253090, 30253608, 30253705, 30253835, 30254206, 30254525, 30254576
30254726, 30255143, 30255528, 30256542, 30257412, 30257908, 30260595
30264405, 30265523, 30265608, 30265615, 30265703, 30266791, 30267155
30269428, 30269748, 30270647, 30270744, 30271114, 30272329, 30274090
30274188, 30274324, 30274662, 30275548, 30275569, 30275578, 30276243
30277120, 30277451, 30277589, 30277733, 30281428, 30282501, 30282591
30283296, 30283577, 30283579, 30283581, 30283932, 30284219, 30284369
30285457, 30285540, 30285843, 30288343, 30288491, 30289074, 30289458
30293345, 30294267, 30294671, 30295110, 30295137, 30295549, 30295790
30295808, 30297905, 30299367, 30299817, 30299934, 30300030, 30300342
30300363, 30300538, 30305264, 30305395, 30305568, 30305880, 30307814
30307883, 30308368, 30308624, 30308772, 30308947, 30309098, 30309798
30311826, 30312094, 30312546, 30313848, 30313989, 30314079, 30314198
30314837, 30316667, 30316897, 30317209, 30318638, 30318943, 30319080
30319099, 30320029, 30322980, 30323658, 30323849, 30324180, 30325407
30326882, 30327149, 30328168, 30328690, 30329209, 30330123, 30331356
30331759, 30332505, 30334484, 30334563, 30335127, 30335832, 30335987
30336032, 30336742, 30339103, 30341713, 30342371, 30342878, 30344614
30345201, 30345432, 30345809, 30346330, 30346867, 30347410, 30349714
30350543, 30352581, 30352623, 30352715, 30355490, 30357463, 30357897
30360383, 30362003, 30362850, 30363088, 30363716, 30364329, 30364613
30365745, 30367193, 30368048, 30368482, 30368534, 30368668, 30371264
30371623, 30371909, 30372081, 30373419, 30373550, 30374345, 30374570
30374739, 30375109, 30376986, 30377347, 30381207, 30381525, 30382982
30383286, 30384121, 30384152, 30387666, 30389229, 30389414, 30389507
30391272, 30392011, 30392987, 30393110, 30393653, 30394738, 30394974
30396946, 30397100, 30398257, 30398422, 30399906, 30402386, 30403763
30403881, 30403902, 30403989, 30404117, 30404153, 30406709, 30408515
30408808, 30409207, 30409339, 30409590, 30412188, 30412863, 30412885
30412921, 30413137, 30413294, 30414491, 30414679, 30414714, 30416034
30416603, 30417648, 30417732, 30419024, 30421204, 30421439, 30421476
30421706, 30422487, 30423135, 30423218, 30424347, 30430921, 30431274
30431504, 30431698, 30431703, 30431717, 30431867, 30433177, 30437149
30441687, 30441959, 30442266, 30442749, 30442884, 30443393, 30446583
30447060, 30447589, 30448182, 30448917, 30449194, 30449837, 30450787
30453442, 30454090, 30457633, 30458568, 30458593, 30460922, 30461458
30463938, 30464250, 30464655, 30466081, 30469777, 30472891, 30473634
30474167, 30474774, 30475115, 30476768, 30477588, 30477685, 30477691
30477767, 30479252, 30479715, 30480872, 30483065, 30483140, 30483521
30484042, 30484801, 30485255, 30486436, 30487387, 30490014, 30490578
30493518, 30495035, 30495078, 30495133, 30495483, 30496957, 30497057
30497765, 30498824, 30500224, 30500297, 30500344, 30500582, 30501574
30502415, 30503943, 30505497, 30506794, 30506991, 30507032, 30509277
30510347, 30510527, 30513285, 30513848, 30515886, 30516868, 30517214
30517516, 30519188, 30522285, 30522998, 30523137, 30523538, 30523601
30523750, 30528547, 30528704, 30528935, 30529940, 30532811, 30533132
30534351, 30534549, 30534827, 30537405, 30537533, 30539519, 30540109
30540407, 30544247, 30544595, 30544629, 30545281, 30545556, 30549255
30549637, 30549789, 30549881, 30551000, 30551123, 30554178, 30556581
30556807, 30557386, 30559252, 30560365, 30560513, 30561590, 30561737
30564139, 30564343, 30565805, 30573236, 30573703, 30576112, 30576393
30576853, 30577071, 30577591, 30578221, 30579051, 30580813, 30581448
30582221, 30582500, 30588738, 30591028, 30592859, 30593046, 30595114
30595860, 30596488, 30598682, 30598746, 30598919, 30599405, 30599407
30600173, 30600184, 30602230, 30602828, 30605215, 30606345, 30606451
30609799, 30610667, 30611603, 30612199, 30613937, 30613971, 30614411
30619525, 30619787, 30620805, 30621255, 30622528, 30623138, 30623142
30624792, 30624864, 30625121, 30628899, 30629643, 30629799, 30631393
30631523, 30633259, 30633938, 30635183, 30635302, 30635326, 30637270
30637319, 30641755, 30641900, 30644889, 30647133, 30650404, 30651231
30651621, 30651674, 30652515, 30652853, 30654558, 30655906, 30657365
30657624, 30657706, 30657875, 30658533, 30658555, 30658702, 30660412
30661939, 30662651, 30662736, 30663646, 30668407, 30670584, 30671720
30671813, 30674959, 30676209, 30679595, 30679771, 30681462, 30681516
30686131, 30687047, 30690686, 30691604, 30691731, 30691857, 30692462
30692473, 30694947, 30696566, 30698289, 30703610, 30704826, 30708735
30710807, 30711370, 30714151, 30714715, 30716863, 30718841, 30718862
30719419, 30720736, 30720844, 30722705, 30723671, 30724679, 30724881
30727701, 30729278, 30729604, 30730026, 30732711, 30734707, 30735153
30735736, 30740669, 30740997, 30741263, 30749644, 30749722, 30750991
30751521, 30751968, 30755348, 30758943, 30761878, 30763272, 30763305
30763639, 30763754, 30764663, 30765486, 30769312, 30770717, 30773164
30773797, 30776416, 30776929, 30777759, 30778855, 30779240, 30781032
30781041, 30782414, 30783551, 30785101, 30786655, 30789904, 30790441
30801296, 30801510, 30803210, 30807723, 30808869, 30812574, 30814266
30814285, 30815852, 30816760, 30816938, 30821297, 30823744, 30825391
30825419, 30825656, 30826474, 30828350, 30829779, 30832775, 30833454
30834110, 30835853, 30838605, 30844839, 30847442, 30848097, 30848773
30851951, 30856358, 30857501, 30857721, 30858919, 30861988, 30865805
30866141, 30866988, 30869131, 30870439, 30871716, 30871792, 30873527
30880774, 30880913, 30881407, 30883785, 30883877, 30886188, 30887501
30887777, 30889723, 30890720, 30890971, 30896620, 30904672, 30906274
30906407, 30909918, 30910264, 30913399, 30914272, 30914674, 30919691
30919804, 30922936, 30922996, 30923517, 30923597, 30923940, 30927821
30930339, 30936831, 30937340, 30937410, 30939307, 30939934, 30940259
30940868, 30941056, 30944643, 30945005, 30946072, 30946876, 30952104
30952191, 30953266, 30953836, 30957739, 30964194, 30965649, 30968737
30968781, 30970518, 30972841, 30972887, 30972966, 30973113, 30973137
30973143, 30973698, 30978554, 30980317, 30980733, 30981240, 30985027
30987088, 30990034, 30992597, 30993198, 30994996, 30996991, 30997375
30998759, 30998847, 31001017, 31001455, 31001859, 31003659, 31004077
31004719, 31004844, 31008240, 31008907, 31009680, 31010976, 31013127
31015330, 31016413, 31019249, 31021157, 31021324, 31021542, 31022858
31025859, 31026220, 31028986, 31029936, 31031955, 31032904, 31034794
31035916, 31038220, 31039627, 31039928, 31042208, 31043483, 31051075
31056909, 31061482, 31061504, 31062010, 31066250, 31066265, 31066554
31067892, 31071080, 31077117, 31077365, 31079204, 31080474, 31084921
31086869, 31092129, 31094688, 31097760, 31100172, 31103065, 31104809
31106577, 31109506, 31113089, 31113249, 31115502, 31118809, 31119057
31124914, 31134430, 31141792, 31153120, 31153485, 31155634, 31156383
31163379, 31172207, 31177193, 31178103, 31180519, 31182159, 31182793
31188038, 31192039, 31193936, 31194264, 31200845, 31201001, 31202536
31208287, 31214119, 31215438, 31217946, 31219975, 31220912, 31221454
31222780, 31223382, 31228670, 31234765, 31249406, 31254297, 31254535
31258101, 31265773, 31292298, 31301460, 31305624, 31306248, 31309867
31312976, 31315876, 31321092, 31325584, 31326608, 31331354, 31334606
31338249, 31338673, 31383396, 31386394, 31387443, 31393600, 31394365
31401831, 31414023, 31414524, 31417192, 31429770, 31430722, 31431005
31433092, 31455597, 31475635, 31477424, 31486557, 31500971, 31509279
31513011, 31523548, 31527103, 31536731, 31537521, 31544097, 31570161
31591384, 31591400, 31591409, 31600023, 31609974, 31628753, 31658464
31668061, 31672605, 31683044, 31718134, 31718346, 31747989, 31758846
31781897, 31792615, 31796208, 31796277, 31820859, 31833172, 31867037
31876368, 31886547, 31888148, 31897786, 31905033
Patch 29585399 : applied on Mon Feb 08 08:21:33 CET 2021
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.

Now Its upgraded to Oracle Database Home 19.9 version. Thank you for giving your valuable time to read the above information. If you want to be updated with all our articles send us the Invitation or Follow us: Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/ LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/ Facebook Page: https://www.facebook.com/Oracleagent-344577549964301 Ramkumar’s Twitter : https://twitter.com/ramkuma02877110 Ramkumar’s Telegram: https://t.me/oracleageant Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

UPGRADE ORACLE DATABASE FROM ORACLE 12.2.0.1 TO 19C USING DBUA

What is upgradation?

Upgradation is the process of replacing an older version/software with a new version of the product. It transforms the existing Oracle Database Environment into a new Environment. Upgradation can be done within the similar OS or with a different platform.

NOTE: It is important that we should apply the latest PSU or proactive bundle patch, RU, or RUR patch before starting an upgrade.

Why do we need to upgrade?

Upgrading a database generally fixes the bugs, internal errors and other technical issues which can be identified and resolved as soon as possible thereby it reduces the downtime.

You can perform a direct upgrade to the new release from the following releases:
• 11.2.0.4
• 12.1.0.1 and 12.1.0.2
• 12.2.0.1

For example: Here I am converting my db from 12.2.0 (base version) to a 19.0.0 (higher version)

Types of Upgrade:

We can upgrade our DB in any one of the following methods,

1)DBUA (Database Upgrade Assistant)

2)Manual Method

3)Data Pump

4)Transportable Tablespaces

DATABASE UPGRADE ASSISTANT (DBUA) :

DBUA is a GUI method that checks all pre-requisties themselves.it checks for all the pre-requisties such as configuring the listener, recompiling the invaid objects, upgrading the time zone, running the preupgrade_fixups.sql,postupgrade_fixups.sql, configuring the enterprise manager (EM) database express, creating a Guaranteed Restore Point and all the things by itself.DBUA only performs the upgradation process if it satisfies all the above-mentioned things.

In the manual method, we should perform all the pre-requisties things manually.

Overview of steps to Upgrade a Database:

PRE-UPGRADE STEPS:

Create a new directory called backup, Take a backup of listener.ora,tnsnames.ora,spfile and password files ,then move all the files to the newly created directory called backup.
Create a new directory called upgrade,Run the preupgrade.jar file which is in the location

(/u01/app/oracle/product/12.2.0.1/db_1/jdk/bin/java -jar /u02/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/preupgrade.jar),Move the summary of the preupgrade.script to the upgrade directory.

3.Three files named preupgrade.log,preupgrade_fixups.sql,postupgrade_fixups.sql files will be created after running the preupgrade.script.

4.We should execute the below scripts,

Before upgrade – @/u01/preupgrade/preupgrade_fixups.sql

After upgrade – @/u01/preupgrade/postupgrade_fixups.sql

5.Then check the preupgrade.log whether it is completed without any errors.

6. Verify the tablespace sizes for upgrade. (enable the AUTO EXTENT ON and set the maximum size for tablespaces)

7. Gather the dictionary statistics query to get the statistical data of fixed objects. we should gather dictionary statistics before and after the upgrade to maintain better DB performance.Because dictionary tables are modified and created during the upgrade.

8.Purge the recyclebin

9.Refresh all the materialised views before upgrade.

10.Run preupgrade_fixups.sql (/u01/upgrade/preupgrade_fixups.sql) before the upgrade.

11. You should enable the archive log list.

12.Create the flashback restore point before performing upgrade,it is important suppose if dbupgrade fails you can recover the database from this restore point.

13.Set the db_recovery_file_dest_size=10GB

UPGRADE TASK:

After we have completed all our pre-upgrade steps, Now it is time to upgrade our DB using dbua(GUI Method), All the steps will be taken by this.

Once you run the dbua command ,a log will be generated in the location (/u01/app/oracle/cfgtoollogs/dbua/upgrade2020-04-23_10-46-32PM) we can check this log file if any error occurs)

14.We should choose the database which is to be upgraded for 19c.

15. Next choose to Create a Guranteed Restore Point or RMAN backup in case of failure of upgrade. Double-check our restore point

16. Configure a new listener or upgrade the existing listener which is running up from 12.2.20.1 home to target 19c home.

17.Check if all the pre-requisites that we mentioned are correctly mentioned in the GUI.

POST UPGRADE STEPS:

18.Put an entry of current database in the vi /etc/oratab file.

19. Verify the timezone version of the upgraded database. (it should be changed to 32)

20. Then check for any invalid objects in the database after the upgrade.

21.We have to verify the DBA_REGISTRY view,it displays the information about the components loaded in the database.

22. Now we can drop the restore point that we have created already before the upgrade.

23.Update the compatible parameter value, it will be set in the base database version we have to update the upgraded db version in the compatible parameter value.

24. Finally check the listener.ora and tnsnames.ora files it should be updated to an upgraded db version.

Step:1 create a new directory for backup and for the upgrade.

[oracle@orcldbs u01]$ mkdir backup
[oracle@orcldbs u01]$ ls
app  backup  oradata                              
[oracle@orcldbs u01]$ mkdir preupgrade
[oracle@orcldbs u01]$ ls
app  backup  oradata  preupgrade

Step:2 Take backup of listener.ora,tnsnames.ora.spfile,password file.

Step:3 Run the pre-upgrade jar script,a log(preupgrade.log will be generated after running the script and send it to the /u01/preupgrade)

[oracle@orcldbs db_1]$ /u02/app/oracle/product/12.2.0.1/db_1/jdk/bin/java -jar /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/preupgrade.jar FILE DIR /u01/preupgrade

==================
PREUPGRADE SUMMARY
==================
  /u01/preupgrade/preupgrade.log

  /u01/preupgrade/preupgrade_fixups.sql

  /u01/preupgrade/postupgrade_fixups.sql

Execute fixup scripts as indicated below:

Before upgrade:
Log into the database and execute the preupgrade fixups

@/u01/preupgrade/preupgrade_fixups.sql

After the upgrade:
Log into the database and execute the postupgrade fixups

@/u01/preupgrade/postupgrade_fixups.sql

Preupgrade complete: 2021-01-30T01:54:48

Step:4 Log in to the database and run the preupgrade_fixups.sql

[oracle@orcldbs db_1]$ !sq
sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sat Jan 30 01:55:09 2021
Copyright (c) 1982, 2016, Oracle.  All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> @/u01/preupgrade/preupgrade_fixups.sql
Executing Oracle PRE-Upgrade Fixup Script
Auto-Generated by:       Oracle Preupgrade Script
                         Version: 19.0.0.0.0 Build

Generated on:            2021-01-30 01:54:46
For Source Database:        GERMANY
Source Database Version: 12.2.0.1.0
For Upgrade to Version:  19.0.0.0.0
Preup                             Preupgrade
Action                            Issue Is
Number  Preupgrade Check Name     Remedied    Further DBA Action
------  ------------------------  ----------  --------------------------------
    1.  dictionary_stats          YES         None.

    2.  pre_fixed_objects         YES         None.

    3.  tablespaces_info          NO          Informational only.
                                              Further action is optional.
    4.  rman_recovery_version     NO          Informational only.
                                             Further action is optional.

PL/SQL procedure successfully completed.

Step:5 Gather the dictionary statistics it should be gathered after performing the upgrade.

SQL> SET ECHO ON;
SET SERVEROUTPUT ON;
EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS;

PL/SQL procedure successfully completed.

Step:6 Purge the recycle bin.it is mainly used to release the storage space used,since we have enabled the GRP we can purge the recycle bin.

PURGE DBA_RECYCLEBIN;

SQL>DBA_RECYCLEBIN purged.

Step:7 Refreshing the Materialised views update all its indexes.

 SQL>  declare
list_failures integer(3) :=0;
begin
DBMS_MVIEW.REFRESH_ALL_MVIEWS(list_failures,'C','', TRUE, FALSE);
end;

PL/SQL procedure successfully completed.

Step:8 Enable the archive log mode it is mandatory to perform an db upgrade.

SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /u01/app/oracle/product/12.2.0.1/db_1/dbs/arch
Oldest online log sequence     1
Current log sequence           2
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 2432696320 bytes
Fixed Size                  8623592 bytes
Variable Size             654314008 bytes
Database Buffers         1761607680 bytes
Redo Buffers                8151040 bytes
Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> archive log list;

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/app/oracle/product/12.2.0.1/db_1/dbs/arch
Oldest online log sequence     1
Next log sequence to archive   2
Current log sequence           2

SQL> show parameter rec

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
buffer_pool_recycle                  string

control_file_record_keep_time        integer     7

db_recovery_file_dest                string

db_recovery_file_dest_size           big integer 0

db_recycle_cache_size                big integer 0

db_unrecoverable_scn_tracking        boolean     TRUE

ldap_directory_access                string      NONE

ldap_directory_sysauth               string      no

recovery_parallelism                 integer     0

recyclebin                           string      on

remote_recovery_file_dest            string

SQL> select flashback_on from v$database;

FLASHBACK_ON
------------------
NO


SQL> select name,open_mode,log_mode from v$database;

NAME      OPEN_MODE            LOG_MODE
--------- -------------------- ------------
GERMANY   MOUNTED              ARCHIVELOG


SQL> show parameter db_recovery_file_dest_size

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size           big integer 0

SQL> alter database open;

Database altered.

Step:9 set the db_recovery_fil_dest_size to 10 gb for recovery purpose.

SQL> alter system set db_recovery_file_dest_size=10G;

System altered.

Step:10 create the GRP (Guarantee Restore Point) ,suppose if any failure occurs during upgradation we can easily go to the before upgrade of db (ie looks like as if our db before upgradation)it is used for recovery purpose.

SQL> create restore point pre_upgrade guarantee flashback database;

Restore point created.

SQL> select NAME,GUARANTEE_FLASHBACK_DATABASE,TIME from V$restore_point;

NAME                                                                      TIME                                                        GUA

PRE_UPGRADE                                            30-JAN-21 02.26.08.000000000 AM             YES

Step:11 We have done all the things to be done before the upgrade. Now it’s time to run the DBUA a GUI Utility to perform the upgrade.

11.1 you have to choose the database which you need to upgrade, here I am choosing Germany db for upgrade to 19.0.0 which is in version 12.2.0 and click next.

11.2 second window shows the Pre Upgrade Recommendations and Post Upgrade Recommendations and then click next.

11.3 in this screen click the following checkboxes,

Enable Parallel Upgrade

Recompile Invalid Objects During Post Upgrade

Upgrade Timezone Data

After that you have to browse the locations of preupgrade_fixups.sql,postupgrade_fixups.sql

11.4 In this screen you can specify any of the recovery option for the database in case of upgrade failure.

Here I am using Flashback and Guaranteed Restore Point.

There are methods are also available such that RMAN backup , use latest available full RMAN backup. if you have your own backup and restore strategy you can also use that.

11.5 Select the 12c listener, it should be up and running.

11.6 select the Configure Enterprise Manager (EM) database express check box and click next.

11.7 Finally this window shows the Database Upgrade summary you can verify all your selections that you have choose above are correctly mentioned and proceed further.

11.8 After that Oracle upgrade process starts.

11.9 when the upgradation process is over it give an upgrade results which db is upgraded from which version to which version. You can check here for information.

Step:12 Put an entry of the current database in the vi /etc/oratab file.

[oracle@orcldbs ~]$ cat /etc/oratab | grep -i germany
germany:/u01/app/oracle/product/19.0.0/dbhome_1:N
[oracle@orcldbs ~]$[oracle@orcldbs admin]$ export ORACLE_SID=germany
[oracle@orcldbs admin]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jan 30 04:09:40 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL>  SELECT name from v$database;       

NAME
----------------
GERMANY

Step:13 check the timezone version for the upgraded db (GERMANY) it has changed from 26(12c) to 32(19c).

SQL>  SELECT version FROM v$timezone_file;

   VERSION
----------------           
     32

Step:14 Check for any invalid objects in upgraded database.

select count(1) from dba_objects where status='INVALID';

  COUNT(1)
------------------
     0

Step:15 Verify the dba_registry, it should be verified before and after the upgrade because it display information about the components loaded in the database.

SQL> col COMP_ID for a10
col COMP_NAME for a40
col VERSION for a15
set lines 180
set pages 999

select COMP_ID,COMP_NAME,VERSION,STATUS from dba_registry;

COMP_ID    COMP_NAME                                                               VERSION              STATUS
---------- ---------------------------------------- --------------- --------------------------------------------

CATALOG    Oracle Database Catalog Views                                         19.0.0.0.0             VALID

CATPROC    Oracle Database Packages and Type                                     19.0.0.0.0             VALID

JAVAVM     JServer JAVA Virtual Machine                                          19.0.0.0.0             VALID

XML         Oracle XDK                                                           19.0.0.0.0             VALID

CATJAVA    Oracle Database Java Packages                                         19.0.0.0.0             VALID

APS        OLAP Analytic Workspace                                               19.0.0.0.0             VALID

RAC        Oracle Real Application Clusters                                      19.0.0.0.0             OPTION OFF

XDB        Oracle XML Database                                                   19.0.0.0.0             VALID

OWM        Oracle Workspace Manager                                              19.0.0.0.0             VALID

CONTEXT   Oracle Text                                                            19.0.0.0.0             VALID

ORDIM    Oracle Multimedia                                                       19.0.0.0.0             VALID

SDO      Spatial                                                                 19.0.0.0.0             VALID

XOQ      Oracle OLAP API                                                         19.0.0.0.0             VALID

OLS      Oracle Label Security                                                   19.0.0.0.0             VALID

DV       Oracle Database Vault                                                   19.0.0.0.0             VALID


15 rows selected.

Step:16 we have upgraded our db to a higher version, hence we can drop the guaranteed restore point.

SQL> drop restore point pre_upgrade; 

Restore point dropped.

Step:17 check the compatible parameter it will be in 12.2.0 compatible value we have to set the compatible value to 19.0.0

SQL> show parameter COMPATIBLE

NAME                                                        TYPE                VALUE

------------------------------------                      ----------- ------------------------------
compatible                                                  string                12.2.0

noncdb_compatible                                           boolean               FALSE

SQL> ALTER SYSTEM SET COMPATIBLE = '19.0.0' SCOPE=SPFILE;

System altered.

SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup

ORACLE instance started.
Total System Global Area 2432695144 bytes
Fixed Size                                8899432 bytes
Variable Size                            536870912 bytes
Database Buffers                        1879048192 bytes
Redo Buffers                             7876608 bytes
Database mounted.
Database opened.

SQL> ALTER SYSTEM SET COMPATIBLE = '19.0.0' SCOPE=SPFILE;

System altered.

SQL> show parameter COMPATIBLE

NAME                                                        TYPE                VALUE

------------------------------------                    ----------- ------------------------------

compatible                                                 string              19.0.0

noncdb_compatible                                         boolean              FALSE

SQL>

Step:18 Verify whether the listener and tns files are changed to the upgraded version.(19.0.0)

[oracle@orcldbs ~]$ ps -ef | grep tns

root        15     2  0 Jan29 ?        00:00:00 [netns]
oracle    2165     1  0 02:35 ?        00:00:00 /u02/app/oracle/product/12.2.0.1/db_1/bin/tnslsnr LISTENER -inherit
oracle    6055     1  0 02:49 ?        00:00:00 /u01/app/oracle/product/19.0.0/dbhome_1/bin/tnslsnr LISTENER -inherit
oracle   25603 28937  0 04:16 pts/0    00:00:00 grep --color=auto tns


[oracle@orcldbs ~]$
[oracle@orcldbs ~]$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 30-JAN-2021 04:17:17
Copyright (c) 1991, 2019, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.26)(PORT=1521)))

STATUS of the LISTENER
------------------------

Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                30-JAN-2021 02:49:58
Uptime                    0 days 1 hr. 27 min. 18 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF

Listener Parameter File   /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/orcldbs/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.26)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=orcldbs.localdomain)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/trichy/xdb_wallet))(Presentation=HTTP)(Session=RAW))

Services Summary...
Service "oraprod" has 2 instance(s).
Instance "oraprod", status UNKNOWN, has 1 handler(s) for this service...
Instance "oraprod", status READY, has 1 handler(s) for this service...

Service "oraprodXDB" has 1 instance(s).
Instance "oraprod", status READY, has 1 handler(s) for this service...

Service "germany" has 1 instance(s).
 Instance "germany", status READY, has 1 handler(s) for this service...

Service "germanyXDB" has 1 instance(s).
Instance "germany", status READY, has 1 handler(s) for this service...

The command completed successfully 
[oracle@orcldbs ~]$

Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter: https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

19C RMAN CONCEPTS

19c RMAN CONCEPTS:

RECOVER DATAFILE WITHOUT RMAN BACKUP

RECOVER THROUGH RESETLOGS

BLOCK CHANGE TRACKING

RECOVER LOSS OF ALL CONTROL FILE USING AUTO BACKUP

RECOVER LOSS OF ALL ONLINE REDO LOGS

POINT IN TIME RECOVERY

RMAN-06183: datafile or datafile copy xyz.dbf larger than MAXSETSIZE

RMAN Database Restore ASM

DATABASE INCARNATION USING RMAN

Restore Tablespace using RMAN

RESTORE SPFILE USING RMAN

RMAN backup Full Database

RMAN Backup Tablespace

RMAN Backup Particular Datafile

RMAN Backup Spfile

RMAN Backup Current Control file

RMAN Backup Archive log Until Sequence

RMAN Backup Archive log Between Sequence

RMAN Backup Archive log Between SCN

RMAN Backup Archive log Until SCN

RMAN Backup Database Plus Archive log

RMAN Backup Database Includes A Control file

RMAN Backup Archive log and All Delete Input

RMAN Backup Archive log All and Skip Inaccessible

LEVEL 0 and LEVEL 1 Backup And Recovery using RMAN

CROSSCHECK BACKUPS Using RMAN

RESTORE CONTROL FILE USING RMAN

Backup-based Cloning of a database using RMAN

RECOVERY CATALOG DATABASE IN RMAN

RMAN ORA ERRORS

DBVERIFY

END-OF-FILE ERROR

LEVEL 0 INCREMENTAL BACKUP

point-in-time recovery using RMAN in 19c

Recover a loss of all online redo log files

Thank you for giving your valuable time to read the above information. If you want to be updated with all our articles send us the Invitation or Follow us:

Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter: https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

AutoUpgrade 21c Release: New Features/Enhancements

Belong to Below environment:

Oracle Database – Enterprise Edition – Version 12.2.0.1 and later
Oracle Database – Standard Edition – Version 12.2.0.1 and later

Overview:

Oracle Database AutoUpgrade allows DBAs to upgrade one or many databases without human intervention, all with one command and a single configuration file.

Advantages:

AutoUpgrade enables customers to upgrade one or many Oracle databases at the command-line with a single command and a single configuration file. AutoUpgrade will run the preupgrade tasks, perform automated fixups where needed, execute the database upgrade, and finish by taking care of post-upgrade tasks. It includes automatic retry and fallback, the possibility to schedule upgrades for future points in time, and the ability to set, change or remove initialization parameters as desired. It saves time and money by upgrading hundreds of databases with one command and replacing bespoke high maintenance upgrade solutions.

Download

The most recent version of AutoUpgrade can be downloaded via this link: version 20201214.

Supported Target Versions

AutoUpgrade Tool can be used on upgrading to below Oracle Database releases:

Oracle Database 21c (21.3 and newer)
Oracle Database 19c (19.3 and newer)
Oracle Database 18c (18.5 and newer)
Oracle Database 12c Release 2 (12.2 + DBJAN2019RU and newer)

How to Install

As of the January 2019 Release Updates (DBJAN2019RU) and beyond, AutoUpgrade Support is available for Oracle Database 12c Release 2 (12.2) and Oracle Database 18c (18.5) target homes. For both Oracle Database 12c Release 2 (12.2) and Oracle Database 18c (18.5) target homes, you must download the AutoUpgrade Tool and place it under $ORACLE_HOME/rdbms/admin.

In Oracle Database 19c (19.3) and later target Oracle homes, the autoupgrade.jar file exists by default. However, before you use AutoUpgrade, Oracle recommends that you download the latest version and replace the one already existing under $ORACLE_HOME/rdbms/admin.

Limitations

Database restoration option is not available on an Oracle Database Standard Edition.

AutoUpgrade 21c Release: New Features/Enhancements

Non-CDB to PDB Upgrades
- AutoUpgrade can upgrade and convert a non-CDB to a PDB in a new CDB in a single operation, or upgrade and then convert a Non-CDB database to a PDB in a pre-existing CDB
- Support for RAC and SI databases
Unplug-plug upgrade
- AutoUpgrade can perform an unplug of a pluggable database (PDB) from an earlier release source container database (CDB), plug it into a later release target CDB, and then complete all the steps required to upgrade the PDB to the target CDB release
Supports RAC upgrades (Only for Linux or Unix-based systems)
- Configuration of the RAC management system in the source and target home is automated
- Supports native file systems, ASM and ACFS
- Oracle Restart
- Pluggable databases are supported in a RAC environment
Ability to pass catctl_options (via config file)
- This enables the DBA to control the level of parallelism for a specific upgrade.
Restore capability
- AutoUpgrade restore job option allows the DBA to restore database back to source home if upgrade failed or succeeded
Clear the recovery for a specific job by adding clear_recovery_data on the command line and use jobs parameter to specific exactly which jobs recovery data must be cleared.
Upgrades on Data Guard environments
- AutoUpgrade can detect Oracle Data Guard configurations, and defer shipping logs to standby databases configured for the primary database. It will also detect and defer shipping logs to standby database if the deployment is configured manually. Upon a successfully upgrade of the primary database, upgrades to the standby database must be performed and monitored by the DBA.
AutoUpgrade performance improvements
- utlrp compilations moved out of upgrade into a post fixup
- Improved resume operations: AutoUpgrade keeps track and skips over PDBs databases that have been upgraded successfully
- Replay support was added for upgrades 21 or higher
AutoUpgrade supports upgrade on CDBs with proxy pdbs
AutoUpgrade supports upgrade on CDB’s with application containers
Added additional JSON status information
Integrated classic pre-upgrade functionality
- The -preupgrade clause of AutoUpgrade replaces the functions previously performed by the manual Pre-Upgrade Information Tool (preupgrade.jar) in previous releases The -mode clause takes one of three values:
  - analyze: Check your system for readiness to upgrade
  - fixups: Perform fixups as needed on your source Oracle Database release in preparation for upgrade
  - postfixups: Perform fixups on your target Oracle Database release after upgrade is completed.
  - Reports are identical to what the preupgrade.jar originally produced.
Starting Oracle Release 21c, Enterprise Manager, DBUA and ORAchk use AutoUpgrade to perform database upgrade readiness.
Starting Oracle Release 21c, FPP performs database upgrades using AutoUpgrade
Enhanced management of databases using Transparent Data Encryption (TDE)

Reference oracle support Doc id : 2485457.1

Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

Tag Archives: upgrade

Step 1: Install OPatch utility “6880880”:

Step 2: Install the patch 31771877

Step 3: Check the upgrade:

What is upgradation?

Why do we need to upgrade?

Types of Upgrade:

DATABASE UPGRADE ASSISTANT (DBUA) :

Overview of steps to Upgrade a Database:

PRE-UPGRADE STEPS:

19c RMAN CONCEPTS:

Backup-based Cloning of a database using RMAN

Belong to Below environment:

Overview:

Download

Supported Target Versions

How to Install

Limitations

AutoUpgrade 21c Release: New Features/Enhancements