19.11 Database Release Update

Posted by

I tweeted about a particular bug fix that interests me for 19.11, namely a critical fix for Flashback Data Archive in high volume transactional systems.

image

Unfortunately this bug is not listed in the official Bugs Fixed section of the release notes, but if you see your shared pool being polluted with lots of SQL statements containing references to internal tables containing the term “FDA”, then this is definitely the patch for you.

As always, follow the release notes carefully for your particular software configuration, but for my Windows installation here at home, the patch went through without any problems. Don’t forget that on Windows environments, you typically need to rollback the previous OJVM patch before you can apply either the new database patch or new OJVM patch.

Complete output from my process below in case its helpful as a guide for your own patching experience.


U:\software\19.11windows\32409154>opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.24
Copyright (c) 2021, Oracle Corporation.  All rights reserved.


Oracle Home       : C:\oracle\product\19
Central Inventory : C:\Program Files\Oracle\Inventory
   from           :
OPatch version    : 12.2.0.1.24
OUI version       : 12.2.0.7.0
Log file location : C:\oracle\product\19\cfgtoollogs\opatch\opatch2021-07-02_14-28-17PM_1.log

Lsinventory Output file location : C:\oracle\product\19\cfgtoollogs\opatch\lsinv\lsinventory2021-07-02_14-28-17PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: gtx
ARU platform id: 233
ARU platform description:: Microsoft Windows (64-bit AMD)


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  32067171     : applied on Tue Apr 27 12:10:25 AWST 2021
Unique Patch ID:  24096715
Patch description:  "OJVM RELEASE UPDATE 19.10.0.0.0 (32067171)"
   Created on 27 Feb 2021, 07:46:44 hrs PST8PDT
   Bugs fixed:
     31306261, 29774362, 30889443, 32032733, 30855101, 31359215, 29512125
     30895577, 29254623, 30134746, 30160625, 29445548, 29942275, 29224710
     31668872, 32165759, 30534662, 26716835, 32069696, 29540327, 30674373
   This patch overlays patches:
     32062765
   This patch needs patches:
     32062765
   as prerequisites

Patch  32062765     : applied on Tue Apr 27 12:07:49 AWST 2021
Unique Patch ID:  23986305
Patch description:  "Windows Database Bundle Patch : 19.10.0.0.210119 (32062765)"
   Created on 8 Feb 2021, 01:04:39 hrs PST8PDT
   Bugs fixed:
     31414023, 31541335, 30392987, 28767240, 31104809, 30324180, 30565805
     29248495, 27663388, 31374884, 30454090, 30654186, 29192685, 29642451
     29163415, 28189466, 29003207, 29667200, 30031949, 31001455, 28755011
     28821847, 31172207, 28835937, 29806964, 27195575, 29497696, 29183912
     29710858, 30047531, 29545235, 30006262, 30693791, 29897863, 29375984
     29625065, 30970518, 27551228, 29438073, 28875089, 29478378, 30448917
     30277589, 29846645, 30045389, 30398257, 30765486, 28755084, 29638285
     30895426, 30092859, 29717901, 30500224, 30600173, 30093449, 31855526
     31823051, 28884931, 29379299, 31130156, 30195684, 31113089, 31039627
     29971027, 27453490, 29910893, 30582487, 29680700, 30560365, 31764866
     29509777, 29605539, 30424257, 30234227, 30247305, 30349714, 30117469
     30335987, 29340333, 29199635, 28831971, 30528687, 30616406, 30658555
     31394365, 28986481, 28760206, 29380201, 31293586, 28397317, 31075960
     29203122, 29559908, 29033052, 30345432, 29366406, 30027649, 30387361
     31753692, 28870111, 30610667, 30003187, 29178385, 30155241, 27829722
     29667994, 31717585, 29353821, 29002927, 29342966, 29283505, 30242120
     29257308, 30308624, 30635183, 29604257, 28860451, 29202104, 31047022
     30556807, 31663788, 29483532, 30224650, 30847871, 29271019, 29024054
     31155634, 31752814, 28985114, 29766435, 30596694, 31001017, 29869906
     30237477, 28957260, 31897786, 30495133, 29182019, 31727560, 29506942
     28922532, 30763639, 29061016, 31338769, 31026220, 30160725, 31585351
     31208287, 31254929, 30493518, 32172777, 31069706, 31499370, 30484042
     30529280, 31734583, 31215438, 29865658, 8460502, 30980115, 29928427
     29438736, 31695062, 30157526, 28935293, 29383695, 29661065, 29142667
     31820859, 29302963, 29536445, 29255273, 30613971, 32050048, 31895670
     29951620, 29610506, 29033145, 29598046, 29159661, 29247906, 23645975
     31009590, 30073744, 29428155, 31102824, 30910264, 30014200, 30832775
     29681987, 29592188, 28601957, 30081580, 29274911, 30412863, 30699151
     28983095, 30334538, 30808869, 30052928, 29944660, 27729678, 31190624
     28965376, 29741976, 29248723, 31741653, 28945421, 29412620, 28897123
     30193505, 29521688, 30123138, 26476244, 29160174, 30246982, 29700460
     29592011, 29232449, 31057354, 29245160, 30309098, 29450448, 28862532
     30051176, 30004660, 30513007, 30886188, 30311166, 30556581, 29902327
     29844275, 30770717, 31061482, 29744225, 29117337, 29965052, 29368725
     31644757, 29861561, 28643583, 29451386, 31234790, 29326233, 30479596
     30043610, 31373837, 31001490, 31103065, 29913805, 28922608, 28986207
     28504631, 30545230, 30729604, 31781897, 31015330, 32129659, 30761878
     30043518, 31049319, 29380253, 30393653, 31837842, 29856420, 29666451
     30751968, 28785321, 28710734, 30123264, 30046297, 31417420, 29373588
     31182793, 30135942, 28795551, 29771242, 31204878, 31757570, 30326882
     29947145, 31383814, 30068384, 29389889, 29312889, 31697741, 31039928
     31391991, 30537405, 30820168, 31044002, 29827647, 31287871, 30544247
     30288491, 28874416, 31888148, 30295137, 30476768, 30651621, 28572544
     30155814, 29024876, 29280752, 27877830, 30453442, 30314079, 29117642
     32002411, 30109365, 28795734, 29747493, 29229754, 31200845, 30339103
     30305579, 30564343, 29924080, 30873527, 29110783, 28642469, 28778754
     29919789, 29214935, 31587709, 29766679, 30072905, 31507107, 28699321
     30007450, 31771410, 30902655, 29707246, 30285026, 29439095, 29849100
     29962834, 30652853, 31627587, 30322980, 31410517, 29286037, 29145730
     29881839, 29737941, 21528318, 30117335, 30403989, 29863559, 29194493
     29339299, 29027694, 28905390, 29858420, 29048498, 30740747, 32105135
     31633224, 31035287, 29718198, 29125708, 32040408, 30782266, 29254031
     31100172, 30887501, 29784106, 29059011, 29194205, 31305624, 31268377
     31771468, 29278684, 29757687, 30032562, 30368668, 28888327, 29048728
     29715703, 28872829, 29601549, 30496957, 29500963, 29331209, 31637251
     29903299, 29017265, 29529127, 30919804, 31775359, 29213320, 27828892
     31591400, 31723651, 31597727, 31311830, 30909002, 30628899, 29043725
     31433092, 29232117, 30909918, 32069815, 29130169, 29405996, 30252156
     29484738, 30935767, 31591409, 29969557, 17787434, 31682766, 28534475
     29044763, 31674380, 30716863, 31240626, 30131645, 29398418, 31393599
     31905033, 28558645, 29224605, 25905368, 31144402, 29706160, 31215465
     29305093, 29530515, 29887111, 29159936, 29502561, 31533274, 30046497
     30336530, 29450421, 32296941, 32010707, 31064137, 30973137, 31074907
     31386394, 30612898, 30178990, 31553813, 31387443, 31591421, 29387337
     29191541, 28293236, 30946072, 29450812, 29001888, 30060330, 30217206
     30017836, 28949888, 29261548, 31555539, 29696310, 31168440, 31007750
     29659031, 29710188, 30624874, 31236358, 30792314, 31127969, 30841241
     27489107, 29494245, 31873207, 30476067, 30183715, 31847489, 31046188
     30494900, 29181078, 30557386, 29457502, 29047127, 29326865, 31035916
     29844226, 29628200, 28962775, 29177466, 29027456, 28541606, 30483065
     31585952, 28820669, 29230252, 29130219, 29360775, 31630551, 30423218
     31138106, 27684864, 30358809, 29019121, 29395961, 29779196, 31014069
     29186456, 29417321, 28482048, 30807723, 31177204, 30925316, 29423156
     29632095, 29937565, 30374739, 31628311, 28945994, 29785311, 29604082
     31374442, 29683039, 28587723, 30729963, 29558238, 28806517, 30143470
     29805368, 30043930, 31233430, 29780140, 29203443, 31862359, 29881478
     30758943, 25092651, 31765043, 29661722, 28941901, 30106748, 28567819
     30534827, 30533938, 31172642, 28874678, 29748513, 26739322, 30185852
     29473188, 28703812, 28395302, 29865473, 31572761, 29763158, 30114534
     28877252, 28985478, 29536794, 31484603, 26819036, 31008240, 29676089
     29821130, 29275461, 29820341, 21639146, 30213031, 30334484, 30460922
     31008907, 31165577, 29649652, 30336383, 31010976, 26499997, 30424347
     29483771, 29347106, 30651570, 25416731, 28454215, 30218044, 32121326
     30806984, 28572834, 30177597, 29233415, 28988864, 29798124, 30722705
     30225718, 29418341, 31111109, 31779513, 29635990, 30657875, 28271258
     30364481, 30257908, 28870496, 29053083, 28863432, 30528547, 31454972
     30477691, 28800508, 29385429, 31295991, 29269228, 29838740, 28565296
     30505497, 30357897, 30536579, 29869887, 29377086, 29784139, 29351386
     31445161, 30275786, 29694869, 31226448, 30068871, 30282918, 29337294
     30530585, 29399938, 30764663, 29922225, 30753138, 29542643, 30939317
     31357581, 30930149, 30663428, 29797626, 29268412, 29110526, 30349530
     29813650, 30509277, 29884958, 29831196, 30398754, 29947645, 29336843
     29027933, 30980317, 30890720, 29217828, 29169540, 30274324, 21232786
     30312094, 29899036, 30815852, 29318127, 29958570, 27760043, 30199890
     30790441, 30972947, 30327149, 29379932, 30277733, 29848084, 29875565
     30477685, 30196195, 30238211, 28747089, 29450162, 30524736, 30506794
     31002923, 30362850, 29481584, 30039800, 29273570, 29470291, 29524985
     29707493, 24669730, 30059106, 30381207, 30781041, 29768899, 29444282
     30699254, 30540407, 31551151, 29198913, 31477893, 30940869, 29382296
     29928564, 29172826, 29530440, 31293484, 29805654, 28442896, 31175365
     30102774, 30719327, 29205767, 29205463, 30085531, 31003659, 31560944
     24596874, 30447994, 30216942, 29885890, 31136241, 30946768, 30625121
     31548159, 29881050, 29181923, 30300363, 31570161, 28984313, 30254206
     30214769, 30767277, 29329042, 29126345, 29868857, 31331372, 31194264
     29352867, 31663189, 30595008, 31603199, 27423500, 28663289, 28125947
     28837979, 30749722, 29745288, 29448498, 29203166, 30517516, 30413294
     29202442, 29927756, 29437594, 31026591, 30162350, 30276144, 28572533
     29498198, 30414714, 30200132, 30018903, 31571712, 29177886, 26813848
     29782211, 30606451, 31491634, 30422388, 30474774, 30110224, 29688867
     31546864, 29907942, 29549429, 30313749, 30239575, 30860803, 29407488
     32061648, 29420825, 30549881, 31418685, 30936251, 30972966, 29492127
     30343189, 31649819, 29258980, 29503631, 29622936, 31668967, 29255616
     30911757, 30330123, 29869086, 29302614, 30495035, 31019249, 31114977
     30253608, 31626572, 30972841, 29141341, 31171096, 30786641, 31487441
     29699534, 31675568, 30408515, 30403902, 29471860, 31021157, 30289458
     30095952, 30513285, 28910586, 29436454, 29923452, 29210577, 30461123
     30033547, 28642899, 30749644, 25560538, 31025859, 29497588, 31026860
     29962248, 31852574, 31223382, 28985272, 31113249, 30614411, 29303918
     29658056, 30774873, 29192468, 30839451, 30696187, 30582159, 30041449
     30200758, 30329209, 31292298, 30039959, 31755245, 29549730, 29338628
     29227602, 29431402, 31559085, 29902299, 29266584, 27934711, 29338139
     31324863, 29726695, 30987088, 31510891, 31582073, 31942144, 30116203
     31751387, 31078391, 31139610, 30927821, 30484801, 28630381, 29216984
     30125765, 29657744, 31485386, 31062010, 29455773, 29018680, 31309379
     31312450, 30491341, 30404117, 30865805, 29947428, 28279456, 30952191
     28819640, 28899663, 28109326, 31409483, 31857840, 28889730, 30522998
     29180893, 31825446, 31156383, 29321689, 30513480, 29922461, 29846126
     31218837, 30179531, 31158380, 28697526, 29525467, 30403881, 29243958
     30957739, 29962927, 30293345, 28694639, 30345809, 31498559, 30472891
     29814993, 29407804, 31170143, 29051953, 29485756, 31758846, 30147195
     31548675, 29212611, 29541973, 29279751, 30461079, 29141685, 30206493
     30500297, 29615824, 29356711, 30650404, 29971951, 28673945, 30117593
     31681498, 31034794, 29034587, 29754951, 30751048, 30591475, 29886809
     31367364, 29382784, 29891916, 31393600, 29132938, 28740708, 30437043
     28815557, 29971936, 30829779, 28876926, 29052850, 30221298, 30083100
     31673723, 29815713, 29869052, 30685402, 31055142, 30364329, 30856358
     29312310, 30054980, 31512044, 29862652, 31254297, 28994307, 30001105
     30127904, 28643654, 31094183, 29039510, 30155489, 29112898, 29654615
     31153485, 31637607, 29270585, 29757264, 31359366, 31422525, 31239791
     29438150, 29010517, 29146157, 29282666, 30634548, 29136111, 29348176
     31142749, 31866141, 30510347, 29587299, 31849859, 22748979, 29522662
     29989783, 31029008, 29902330, 30327810, 29669413, 29301463, 29266899
     29739576, 29876989, 29744637, 31696577, 29382641, 29607136, 30489582
     29274627, 30210884, 28621543, 31097961, 30075037, 30970760, 27651535
     29043554, 31236680, 30305264, 29483685, 29037290, 29041775, 30285843
     29285503, 30718862, 29517825, 28597221, 30269428, 29816887, 29687718
     29516727, 29939795, 30252076, 29001305, 31686979, 30490578, 29623592
     29649626, 31407227, 31837923, 30314837, 29174753, 30015070, 30116854
     30076604, 29299830, 29378287, 30029519, 29455424, 31527199, 29961847
     29791880, 29123432, 29412066, 31376708, 31609828, 29201787, 31216995
     30084971, 31574244, 29592215, 29189889, 28907910, 29677173, 30086596
     31314885, 29805772, 30208723, 30066352, 29841267, 28881848, 29786909
     29551699, 29540165, 31377487, 29426241, 29772541, 31025520, 29205419
     29346943, 30480872, 29281112, 30059370, 31578994, 28925880, 29163156
     30269395, 29216746, 29989845, 29597754, 30042490, 30236372, 29477015
     30180643, 31331354, 30952356, 30519188, 31995480, 30009279, 30898939
     31572666, 31155574, 30223847, 29193207, 30235919, 30507032, 29514479
     31677460, 29720133, 29330791, 29721418, 31185224, 31360529, 27589260
     31836454, 30879708, 21374587, 30185718, 28958088, 29277317, 28715727
     30067565, 30295790, 28928462, 29441196, 31118809, 30224950, 30769856
     31066265, 30662937, 17468475, 31305114, 29255178, 31225187, 29851733
     30477588, 31048741, 30127522, 31887422, 29421059, 30528704, 30670437
     28762163, 29518767, 30536831, 28714461, 29699562, 29242017, 28612239
     30993518, 29853340, 30376986, 29131772, 29504103, 31190347, 30539011
     29739311, 29338453, 30889607, 30497057, 29009513, 28993689, 29485877
     29629745, 29469565, 30686131, 30026016, 29628647, 28302439, 31620748
     29110802, 28561704, 30532192, 30774907, 29814995, 31271032, 27954629
     31777242, 30623138, 31061644, 31839233, 28907196, 29529394, 31480077
     29429264, 31115502, 30233110, 28602253, 30090568, 30937391, 29382815
     30582221, 30375107, 29456538, 31063380, 30789904, 30677633, 28946233
     29112455, 29663838, 30671958, 31747935, 31010218, 29456714, 30939934
     30915682, 28863487, 28553487, 31753202, 28572407, 29297863, 29521862
     29307109, 31693766, 30240010, 30187866, 30450488, 30839017, 29181153
     29127957, 29173618, 29858121, 30968737, 29436727, 29398488, 30240972
     29885182, 29357821, 27998559, 30235979, 29259320, 31377129, 31549221
     30776929, 30477767, 28973989, 31485507, 29208260, 29367019, 29206109
     29313417, 30651674, 29463047, 29529147, 29632611, 30172925, 29549071
     29637215, 29006621, 28375150, 30642033, 29445982, 29129450, 30240547
     31706370, 31213549, 28578945, 30431698, 30637319, 30114477, 29190740
     29812084, 29338913, 29244495, 28639299, 31270711, 31354726, 30964194
     31132732, 31077117, 29635717, 31572267, 31837685, 31657416, 29366940
     30953836, 29769321, 31325584, 29867220, 30317397, 30431717, 31644775
     30165897, 30825656, 28871040, 29120223, 29754196, 31455597, 31450653
     27935374, 30277887, 29768487, 29050765, 29361801, 29552773, 31158341
     30727759, 28625580, 29518604, 29744400, 30551000, 29782866, 29174004
     29306713, 31533817, 31869601, 29601461, 30308947, 28925460, 30192691
     30009710, 28919145, 30473634, 28475242, 28952168, 31567441, 30408896
     30932867, 23763462, 30732711, 31119057, 29273539, 31496174, 30362710
     30421026, 29532532, 28696373, 31021324, 30580813, 30590023, 31258995
     29439522, 31943944, 29051269, 30858877, 31722646, 31335902, 30530865
     29169215, 29843831, 29620042, 29244766, 30804646, 29493122, 29245063
     30087509, 25804387, 30906407, 31851383, 30690686, 30655906, 29030927
     31986836, 29394140, 30821297, 29376346, 29400386, 30492380, 29352724
     29452365, 30389229, 29564593, 30973197, 29794174, 29423826, 29016294
     29536342, 29498957, 30264943, 29994370, 30598682, 29246163, 30545281
     31427866, 30619787, 30503923, 31310624, 29968289, 31047169, 29117435
     31431318, 30458568, 29970298, 31383396, 30032515, 29626253, 30392011
     31996264, 29170717, 31107076, 30956647, 32032887, 28765983, 29495171
     29812489, 30816760, 28749853, 30729044, 29799836, 31907565, 30446820
     31188038, 31355615, 28371123, 30689557, 28838385, 29378834, 30338260
     30998847, 29782823, 31339457, 30642161, 30896620, 30985027, 29483723
     30909596, 19080742, 29399336, 29122367, 30225844, 32017301, 29415493
     29273168, 28406374, 29362596, 29505022, 29254863, 31152741, 30150710
     31019729, 31909295, 30679595, 29182901, 26352615, 30593104, 30807888
     31249821, 25756945, 31512222, 29190663, 29548427, 32097882, 28960863
     30636188, 30479252, 30906274, 29870533, 29770750, 27101798, 25404117
     30364613, 29386557, 31309867, 31031955, 31404014, 31444353, 29972134
     31988079, 28302580, 29971481, 31442714, 29333500, 28594086, 31306927
     31544097, 30110370, 30036258, 29288842, 28547926, 30988444, 30825419
     29452936, 29997553, 29559981, 29746962, 29182517, 30257412, 29836096
     30623142, 31051075, 28677941, 31699081, 32221141, 28628631, 29809837
     29591343, 31526903, 30387628, 29648928, 30757495, 29511064, 31721880
     28977322, 28538439, 29703932, 28751498, 31162915, 30810765, 30657940
     29373418, 30629799, 29807964, 30136346, 31570054, 31524350, 29672162
     28917537, 28758722, 29052726, 30591555, 29299082, 31505672, 30384121
     29510278, 29205323, 28951332, 29761678, 29426320, 30594167, 29725781
     28867698, 26127355, 30009095, 27362994, 30922936, 30192853, 31757824
     31627854, 29626154, 29470298, 29507616, 29008669, 30479715, 30416603
     30057799, 29695964, 29920376, 30740997, 31043483, 30960150, 31623529
     28567875, 31126058, 26284288, 30389333, 29795712, 30278910, 30561737
     30761871, 30779240, 30671720, 29515834, 31338249, 29853256, 31244968
     24971456, 27967484, 19697993, 30946876, 25607406, 31974693, 30200680
     28837603, 29343086, 29036278, 29117526, 31766456, 30417648, 31335355
     29160462, 31728160, 30419024, 29499868, 29125786, 29040739, 28834364
     30331759, 29143516, 30381769, 30254576, 29669425, 28999046, 29542084
     29429566, 30734707, 29199163, 30421439, 29154631, 30132708, 29908777
     29329675, 29599530, 30821154, 32212635, 29372562, 29423003, 29442936
     29167352, 29914449, 30117209, 28790623, 31753425, 29408446, 29523216
     30789435, 31701910, 29444602, 29864203, 29182920, 30000227, 29522561
     29255973, 28072567, 28484299, 29865188, 30352532, 29149829, 29698779
     25997810, 31476093, 30998541, 30643660, 29053902, 29546817, 31120361
     30265523, 30284219, 31388650, 31087679, 31528962, 29932430, 29665168
     29916975, 30210753, 30184102, 29356547, 29684672, 29056560, 30202349
     28649123, 30300812, 29210610, 31468060, 29032276, 29323946, 30971094
     29409149, 30037106, 30765956, 29142609, 30159536, 30362003, 29523055
     29307638, 30748707, 29007775, 29542580, 29522358, 28986257, 31867037
     28007516, 30516868, 28605066, 30464655, 30221237, 30183696, 31833172
     31066554, 29450193, 29866585, 29599243, 29492939, 30046061, 28956908
     28697896, 29388830, 29260224, 29132869, 30825391, 31851266, 29012609
     29313039, 30210429, 29332395, 31871692, 31958958, 29457978, 30995520
     31249696, 29336899, 30186476, 29486181, 31500971, 30342878, 28463226
     29848849, 29388072, 28922227, 28954762, 29027940, 31326998, 30325407
     30893147, 29861075, 30095591, 30242724, 30977411, 30047710, 30396120
     31577569, 30940259, 28979734, 29903454, 28793062, 28844788, 25809128
     30190090, 28755846, 29003738, 28720204, 30203929, 31769373, 29948165
     30127805, 26305045, 30039843, 29462957, 29167374, 30198861, 31827605
     28498976, 31322720, 31091868, 29324568, 29161923, 29725476, 31390936
     29671651, 29606261, 30334608, 30782414, 29033280, 28850084, 28127569
     31056909, 30823744, 31327278, 29410311, 29771032, 29013832, 30439985
     28804517, 30083807, 29353960, 31127457, 28808656, 29342099, 29387073
     30074820, 30874337, 29932310, 30848028, 31494264, 29180559, 30390635
     30377668, 28805242, 30304977, 29379381, 29146810, 29860022, 31305541
     31374647, 29885967, 31377808, 31264160, 29904002, 30271114, 30373365
     30255143, 31203227, 29937236, 30979062, 30346330, 29007353, 29602831
     30763754, 30117168, 30938413, 30590095, 29248858, 29380527, 29155099
     31653080, 31888731, 28905457, 30219222, 32234161, 30619138, 29697928
     31825584, 29864061, 31344046, 30009884, 29276272, 30660505, 30723747
     29433282, 30254726, 29273847, 29943879, 30236554, 30537584, 30368534
     31325033, 29047850, 30534549, 29892960, 30126470, 30576393, 29397888
     28628592, 31064628, 30097092, 29368253, 28294563, 29515476, 30619525
     30560513, 29229164, 30116085, 30896920, 28940281, 30423135, 29909658
     31289115, 29423491, 31004719, 31141792, 29241651, 28986326, 30564898
     30604101, 29332763, 29152357, 30642847, 29748336, 29557756, 30153552
     30959735, 28942455, 29834506, 30099420, 30277451, 30137792, 30763305
     29056024, 31222780, 29470059, 31591384, 28589509, 30139392, 30118279
     30650885, 28938698, 31167566, 30146593, 31684494, 31798742, 31313444
     29615077, 30658094, 29962939, 31353610, 29970587, 29435652, 29450936
     29221942, 29402110, 30006937, 30956571, 30175291, 31885672, 30981240
     29432176, 31228670, 29056767, 31112530, 29922214, 28963036, 31092129
     31490604, 30657196, 29932202, 31401831, 29167111, 29892604, 28436414
     30565732, 30026596, 28933158, 29645349, 30051804, 30099454, 29635427
     29181231, 30898381, 30283296, 31061504, 30921136, 28390273, 29222784
     29505730, 29487189, 29254930, 29529973, 29385861, 27458357, 31974597
     28326928, 29531836, 30919587, 29313525, 30284369, 29149170, 29290110
     29262512, 30786449, 29388524, 29434869, 30161094, 31088115, 31796277
     31763707, 29348358, 30830555, 30352623, 31982869, 28492006, 29862693
     29663601, 29564592, 27359766, 30422487, 31013127, 29538631, 29391925
     30674959, 29969900, 29031452, 30998662, 29967223, 30126145, 27526265
     30826474, 31214119, 29161597, 29294753, 30300523, 29944159, 29253871
     28708400, 31670353, 30281428, 29337310, 31180519, 29822714, 28876639
     30724474, 29417719, 29351749, 29625876, 30062819, 28827682, 29791152
     30412885, 29871360, 29848987, 30637270, 29647176, 29623323, 31887130
     31484385, 31665159, 30361839, 28925634, 29312672, 30671813, 29298220
     28892794, 29952700, 30236964, 29501218, 30079949, 29851205, 29449852
     28995287, 31326608, 31394347, 29558975, 29963691, 30143593, 30382646
     31193936, 31906933, 31800757, 29961609, 30952104, 29176318, 31448680
     28740799, 29269171, 29399100, 29972176, 29765035, 31672605, 21965541
     29168433, 30913399, 29212433, 29719146, 31856656, 30208690, 31356601
     29588732, 28627033, 31783782, 30374345, 30576112, 29302565, 29287130
     30659940, 30252977, 29873665, 31335903, 28640772, 30773797, 29111631
     30857721, 31154257, 29541769, 29391301, 29942096, 29123444, 32003551
     32067106, 31596885, 29926466, 29687214, 30713448, 30032233, 30430921
     28960047, 29708830, 30200123, 31425761, 29030184, 31886695, 31315495
     31025531, 29351662, 31525783, 29331066, 30398422, 28643718, 30996991
     32174571, 30517214, 29516300, 29325105, 30893844, 29390435, 30328520
     29947897, 31467424, 31965542, 28431445, 29579919, 28932914, 31284440
     30765995, 29007321, 30012348, 29318410, 31440813, 29351716, 29961353
     29779338, 31105578, 29053783, 29844131, 29608000, 30633938, 31062167
     30058149, 30441277, 31327259, 29203041, 31788704, 30490575, 29657960
     29827852, 31952052, 28263142, 30335127, 29893587, 29265448, 30785101
     29363565, 30523601, 29450417, 30363621, 30338591, 30377692, 29603884
     30490014, 29471832, 30479074, 29624124, 29645167, 29686671, 27378053
     31477695, 29398863, 24957575, 31386890, 29378913, 27004828, 30729278
     31315876, 28955606, 29897418, 30394974, 29237538, 30750991, 31434805
     29901961, 29716227, 30685278, 30778855, 31953989, 23296836, 31709777
     31134430, 30630707, 30134453, 29443559, 29390900, 30051637, 30266960
     29839715, 31864173, 29032234, 29429087, 29722167, 30523538, 29503827
     29843692, 30806757, 30801296, 30388853, 29110790, 28988482, 31556991
     29234123, 30191807, 29452251, 31321092, 30213540, 31757357, 31420522
     31088341, 30851951, 29532112, 31237380, 28940179, 28144569, 30880913
     30633259, 29338780, 29031600, 31707454, 29159909, 28567417, 29267292
     30581448, 30032484, 29214960, 30506991, 30402930, 30500636, 30890971
     30074349, 28704073, 29738374, 29250317, 30972951, 29749453, 29129497
     28854733, 30155837, 29203425, 29417084, 30619728, 29856859, 31584305
     29872187, 30228567, 29465047, 31003463, 30889723, 30179644, 29345937
     28834743, 28915561, 29950220, 29377986, 28133903, 29217294, 30605676
     30300030, 30463938, 29707099, 31119846, 30328168, 29434301, 30840944
     28373960, 32169151, 30595860, 31757751, 29590813, 31581504, 30965649
     29450273, 31499700, 28745367, 29214561, 29868392, 30502415, 29910218
     30896685, 30658702, 28847541, 29055644, 29139727, 29392779, 29677927
     30076058, 30624792, 28815123, 30108012, 30040157, 29460252, 30363088
     29452953, 28948554, 29841704, 29056894, 29372541, 31215354, 29304692
     31717344, 31488316, 31752990, 31600023, 30883785, 29893839, 29651183
     29553141, 25986062, 29282233, 29689255, 29360252, 25093917, 29664161
     31040440, 31726832, 31263969, 29529530, 29488894, 30730026, 30266791
     30992597, 30833909, 30664978, 28722229, 30612199, 29429466, 30341713
     31572006, 26173091, 29350052, 29821582, 28620697, 29329087, 29115857
     29649694, 30114489, 29548592, 30635302, 30403763, 29216312, 30165493
     29431192, 29125374, 30067674, 29715220, 29251564, 30753432, 29839491
     29902659, 30536237, 30406709, 29748325, 29253184, 29217856, 29060216
     29908389, 30783395, 29599008, 31903523, 30008198, 29920804, 30237688
     31644786, 31602792, 30616738, 30208327, 30614124, 31358308, 32118727
     30373419, 30684902, 30224868, 31313117, 30263219, 28892095, 29339101
     29708324, 31234260, 31493468, 29416851, 29299049, 29234059, 30336032
     29882729, 29430524, 29364171, 31118637, 29196725, 31124914, 29411037
     29829339, 31386112, 29242906, 29396481, 30758854, 29846525, 29535802
     31536731, 31327349, 31165722, 30443393, 29670713, 28889389, 31128434
     29266248, 29700770, 31576738, 29201494, 29542449, 30397256, 31127043
     29411469, 28689483, 30218369, 29760705, 29549154, 29376616, 29913966
     29825525, 29471857, 29851066, 32057639, 30024618, 28271693, 30442749
     30846782, 31057336, 31661865, 29557768, 28814106, 29713810, 29331380
     30174401, 29473708, 29598233, 30573703, 29429017, 27261477, 30591151
     30848097, 30096511, 29914544, 31535955, 30183367, 31422620, 29517168
     29991257, 30274090, 29038728, 29528368, 31487491, 30622528, 31114671
     29525366, 29557336, 29232154, 29890740, 30421204, 31508712, 29360911
     30822642, 31125773, 30621255, 30577071, 29209545, 31838226, 30923517
     28865162, 31776994, 31404263, 29853485, 28940472, 31952210, 29430866
     28854004, 29260956, 29944035, 30122523, 30571307, 30012181, 29864261
     29912286, 29437712, 30194972, 29591641, 29647770, 31360146, 29653246
     29894021, 30147928, 30819340, 29758217, 31350348, 29165682, 30295549
     28752923, 30049966, 30305395, 30739835, 28772816, 29289634, 29765347
     31935022, 31352245, 27221350, 30116557, 32178524, 30937917, 30001331
     31702089, 31073586, 30450787, 29413382, 28402823, 29797504, 31546475
     30641755, 29769901, 29956222, 29889358, 30217982, 31907137, 30338499
     29436522, 31411163, 30457633, 29670782, 29462594, 31765257, 31048025
     27166935, 31758083, 30373550, 31601385, 30253090, 30923597, 30203000
     29250059, 30852954, 29374179, 29685276, 29198743, 28521330, 30670328
     30196865, 30614585, 31096846, 29912135, 31087361, 30056058, 29814770
     28375383, 31901236, 29837622, 32130504, 29317756, 29632615, 30588738
     31312976, 30874270, 31648120, 29633936, 30596488, 29616414, 31486557
     30973698, 29232653, 28740425, 31652641, 28535127, 30954829, 29469563
     28818063, 29248835, 30371909, 29268887, 29704429, 29754146, 29842369
     31466433, 30409590, 29599300, 31317880, 30703610, 30857501, 30835184
     29223967, 30431504, 29937655, 30712670, 30080266, 29507560, 30006985
     29416700, 31402036, 29324735, 29141886, 29355654, 31388288, 28836716
     29505668, 29504266, 31640240, 29353271, 29321965, 30360383, 30192729
     28572667, 31030898, 30181756, 30019681, 29449845, 30915781, 29945645
     29663494, 28531803, 31335711, 28350595, 28867992, 28569897, 27126938
     30659836, 31607937, 29213641, 30210185, 30200237, 28209985, 31991705
     29542152, 31011361, 29256426, 29862828, 30249432, 30573236, 30200034
     31756012, 30923514, 30650828, 29368310, 29203691, 29395657, 30741263
     29758661, 30662447, 29218185, 30165503, 30421476, 31249008, 30403412
     29871098, 29282898, 30283577, 29530812, 29840619, 29320900, 30371264
     30600184, 28901126, 29122254, 31533833, 28710663, 28593682, 29203227
     29177543, 30870843, 30599407, 29772761, 29388020, 30475115, 31718346
     31381403, 29423578, 29245137, 29273690, 31092581, 29377804, 30681516
     29314539, 29934052, 30523750, 31787655, 30675459, 29269825, 30053501
     29000000, 31417192, 31338673, 30557015, 30523200, 30685620, 31742408
     30088229, 29169739, 28672457, 28692275, 29186605, 30658533, 29062848
     29939400, 30028697, 30131286, 29657399, 30270744, 28942694, 29462767
     29755821, 29228869, 29758203, 28815355, 30447905, 31816631, 30978554
     30657566, 30848773, 29527610, 30631393, 29026154, 31683044, 27126122
     29487407, 29997226, 29386635, 30342956, 30496225, 29684518, 30769312
     29689145, 30352715, 29695841, 29457807, 30078675, 29852422, 30885598
     30517635, 30974813, 29329848, 30537533, 31381701, 29389408, 29350712
     29708876, 31541864, 29391030, 31106140, 31376095, 30595240, 29749471
     31783451, 29618190, 29695821, 29313347, 31927930, 29444072, 29516766
     29138641, 29671363, 31771370, 30692462, 29233953, 25792962, 28887675
     31788761, 29113282, 30776140, 29684609, 31255869, 29387274, 30728595
     29127491, 31794046, 29756274, 29679856, 29511611, 30628834, 27622946
     31775101, 30021600, 29224065, 30922996, 29361472, 29796378, 31481627
     30864607, 30196629, 31402334, 31567124, 30714045, 29504492, 29685228
     30240858, 29625804, 30159760, 30459504, 29116692, 31175879, 29910402
     30261630, 30879918, 31144248, 30522285, 29586143, 30234132, 30034456
     28993295, 30660412, 30782300, 29558926, 28918429, 30691857, 30154633
     30346838, 30595408, 31709739, 31883124, 29442400, 31494121, 29932780
     29024448, 29667527, 30251503, 30062364, 31094228, 30595114, 31553674
     29213775, 30159782, 30135396, 30554178, 31385167, 29865590, 29411007
     30329751, 29192419, 29163524, 30973113, 29275362, 29219273, 30101186
     31660439, 30807859, 29882427, 31707190, 28961428, 30613937, 31107577
     30188573, 29519131, 30408808, 29701720, 29281527, 29050804, 31006792
     29589544, 30412188, 22729345, 29550530, 30579051, 30891760, 25806201
     30294267, 31688978, 29580394, 30776416, 31419690, 29801164, 31863118
     31449354, 30033040, 28878865, 29454450, 30720844, 28846759, 29110797
     29048605, 29517883, 30960736, 28530171, 29205281, 29705793, 27411022
     29549104, 30155999, 31667323, 30558561, 30681462, 29623009, 29046482
     29847709, 31084921, 30534351, 30711370, 29039089, 30307814, 28911140
     29405012, 31043630, 28377940, 30193165, 29397954, 29218570, 29206605
     28661333, 29483452, 31455464, 29115917, 29407192, 30578221, 31357737
     29972138, 30989620, 31843292, 30159329, 29872401, 30944643, 30104378
     29296257, 28701011, 30404639, 29273735, 28987100, 30497765, 31469099
     30264214, 27254335, 30919691, 30394738, 29941227, 29761911, 29643721
     30223712, 29770719, 29943670, 31004077, 30269748, 30336742, 28379065
     30110518, 30155486, 29217848, 30300342, 31220881, 29507270, 31303032
     30446583, 30081546, 29614987, 29399046, 31477424, 29958925, 30259469
     31760592, 29302070, 30128047, 29413634, 30879169, 29237575, 29512890
     30342371, 28847572, 30487100, 29838773, 29903357, 24687075, 30074472
     30635219, 29761837, 28857552, 29683211, 29440651, 29490266, 30007797
     28968779, 29418165, 27846298, 31637680, 30086992, 27710072, 29760083
     29653132, 31793713, 29916357, 31775363, 30050890, 30283932, 31747989
     30528935, 29170232, 30305568, 30161113, 7391838, 29154725, 29039918
     31306248, 31038447, 31992593, 31408636, 29157051, 29849626, 30167787
     29353718, 29690422, 30559848, 29189302, 31900921, 29751644, 29915848
     30815495, 31458049, 29968085, 31097760, 31266530, 29411931, 29255435
     30382982, 30089658, 29150338, 30657365, 31536401, 31213034, 28370061
     29557261, 31718134, 30871716, 29925365, 30788973, 32082098, 29062860
     29002784, 28709063, 29779581, 30047765, 30655657, 31165693, 29774011
     29202850, 27629928, 29541742, 30350543, 29021063, 30458593, 30309798
     30308368, 31028986, 30953043, 29645874, 30316897, 29387212, 29125380
     29608023, 29935685, 30696566, 31536584, 30202388, 30156569, 28710385
     30187627, 31373843, 29780086, 29144995, 32009770, 28861861, 29721120
     31025251, 31236204, 29614206, 28900212, 29874761, 31092233, 29850930
     28742555, 30891792, 29183298, 30336996, 29551390, 30809087, 30751639
     30844839, 30931311, 30941056, 29375355, 30705448, 30297905, 29741589
     29297915, 30265917, 29631749, 30869943, 29520544, 30008214, 30564139
     30487313, 27113475, 31069059, 31637944, 29537829, 29200700, 29273812
     29417173, 29871312, 31240849, 31467034, 29327044, 29708915, 31037421
     31125280, 30661000, 14735102, 31430722, 29671851, 28802734, 25030027
     30295481, 28322973, 28771947, 30556326, 28645570, 25736599, 29225168
     29436514, 30422030, 31327391, 30529940, 31878314, 30602828, 28187837
     27392968, 29955305, 29236573, 31399131, 31499605, 30233934, 29351735
     29757651, 29463528, 31122876, 30883715, 30861988, 30834110, 29003407
     29515945, 26440142, 30000664, 29644464, 29327892, 31163379, 28993353
     28276054, 29644426, 31897854, 30838605, 30195668, 29457312, 30044720
     29537427, 29173957, 28996376, 27917085, 28781754, 28897512, 30437149
     30274188, 30960356, 29764644, 31008132, 30657624, 29311884, 30352581
     29444631, 30316667, 31450392, 29050357, 31071080, 27262781, 30880774
     29783142, 30443907, 29437701, 29846228, 27572040, 29583036, 31854692
     28888083, 29383352, 29203604, 28981871, 30662736, 30321076, 30866141
     28927452, 31387322, 27148384, 23606241, 29872937, 30350177, 30159752
     30387666, 31440426, 31265773, 31258101, 28811560, 29318169, 27222128
     30437003, 29695987, 28985362, 29585881, 30839977, 29418866, 30285251
     29350729, 30222669, 30644889, 29043651, 29614931, 29552763, 31326977
     29677733, 29663191, 30118261, 30377347, 31036365, 30272329, 30638048
     31070231, 30070902, 30816938, 29747648, 29675446, 31092921, 29202461
     29139070, 29032457, 30448788, 30288386, 29021352, 28547068, 30592859
     30099302, 29391664, 29527595, 31586381, 30229683, 30363716, 28774416
     30085897, 31513130, 31574267, 30347410, 29241345, 29051263, 30207473
     29180721, 30087165, 28719348, 31860193, 30714151, 30345805, 16664572
     29580769, 29061959, 31446431, 29486848, 31367769, 29219627, 31115201
     31372498, 30549789, 29487150, 30735736, 31298871, 28872645, 30611603
     32113113, 29402131, 29524627, 29428230, 30163243, 29962160, 28344129
     29482354, 30609799, 29261695, 30073422, 29314636, 29663368, 31547220
     31114265, 28694872, 29750673, 29751094, 29049673, 28912188, 29457370
     28381939, 31414524, 29544552, 29483672, 29413544, 31757775, 30226244
     30474167, 30217562, 29278218, 30345201, 29378029, 29173817, 30532811
     30936942, 28994542, 30047702, 28986696, 30801530, 29692674, 31027747
     28917080, 29050560, 30209736, 30225265, 29110805, 29031575, 30007536
     31796208, 27582210, 29597674, 29154829, 29586338, 30313989, 28912691
     30409207, 30260595, 29787292, 29584261, 31159382, 28435333, 29026582
     30688961, 29489436, 30657906, 29030106, 29464779, 31454822, 31584411
     29482021, 31215422, 24833686, 29972301, 29817547, 30691731, 29928210
     30544629, 29471399, 29223859, 30193584, 30323849, 29391438, 29062169
     29221891, 30153885, 30239480, 28852065, 31064025, 29301566, 28489419
     30072018, 28965231, 29344541, 29773205, 31245469, 29843277, 29350868
     30654558, 29367561, 29525886, 29359713, 29158899, 28961306, 30285540
     29163437, 30076951, 30645129, 28707931, 30060267, 29524859, 29529948
     30545556, 29956016, 31748000, 31413131, 30080111, 30092280, 29360467
     30051783, 30294465, 30632160, 30193262, 29851272, 32070452, 29961360
     30928663, 29351771, 29013475, 29311927, 29367971, 30142907, 31476736
     31182159, 29325765, 30751521, 31106577, 30582500, 30414679, 31077365
     29293574, 28777214, 29876358, 30409472, 30179038, 31380443, 30252458
     30812961, 30608583, 31532502, 31004844, 29467622, 27092095, 29511980
     30441687, 29665940, 29279658, 30147307, 29431485, 29641736, 30044507
     31987354, 29248552, 31668694, 29154636, 30651430, 31795055, 30471076
     30140896, 28881191, 28336118, 30997459, 29437029, 29672852, 28078186
     30098251, 28611527, 30566054, 29809792, 30243216, 30289074, 30165554
     29352947, 30361635, 31785445, 29247415, 29311528, 30323658, 30846063
     29547867, 31607561, 29113305, 30475421, 31742512, 29652809, 31625579
     31479272, 28129791, 29343156, 31973300, 30058453, 29772514, 29881643
     31935717, 31748944, 30865110, 30248128, 30843271, 30320029, 31182756
     30057718, 30194612, 30134541, 31201001, 29262887, 28791852, 28957723
     28983486, 28938422, 29915217, 29056270, 30074469, 32005048, 31304573
     31856488, 30487387, 29392966, 28813931, 31857137, 29909288, 31369444
     28710469, 30763272, 28769456, 29040641, 29483333, 28817449, 31340025
     29881575, 30814285, 28855520, 31395247, 31167720, 30062305, 29167342
     29062868, 31447105, 29413360, 29944963, 30253705, 30687047, 31539566
     30043398, 29629430, 29580395, 30816230, 29560075, 29527221, 29020252
     29319441, 31613535, 28181021, 31800358, 31709647, 31369602, 30041206
     29129712, 31170705, 29720373, 29687220, 29508681, 30222975, 29159216
     30186319, 31078757, 29515240, 29539413, 28138847, 31373825, 28995524
     30801510, 28855761, 30147473, 29332771, 31527103, 30620439, 31177221
     28833912, 29129691, 29548722, 30324590, 28844738, 31479772, 28873575
     29656400, 8476681, 29476870, 30123726, 29717659, 29454978, 31501139
     31347162, 29351297, 30985906, 31268557, 30598919, 30178250, 29624902
     29875200, 30106901, 30862339, 30637938, 31181380, 29358509, 30869952
     26872233, 31255369, 30932674, 31240145, 30295808, 31442332, 29616325
     28646939, 30195667, 30881407, 30041514, 29796335, 30480378, 31537521
     30267155, 30972887, 31807516, 30057972, 29135383, 31334606, 31396027
     30078934, 20867658, 28785531, 31711889, 30819629, 31086869, 30265608
     29695749, 28936114, 29038528, 26777814, 31509279, 30265615, 29503543
     29285788, 30930339, 29151520, 29194981, 28776811, 30253835, 30334563
     30931981, 29181568, 28882784, 31224644, 29293806, 29180313, 30464250
     29361319, 30006159, 31754887, 29705286, 30694947, 28989306, 29393291
     30204042, 30502264, 31766696, 30421706, 31431005, 31226406, 31339643
     31336298, 21888352, 28965095, 28845346, 30610406, 29133470, 31829617
     30324466, 31020503, 29515766, 29024732, 30413137, 30068792, 30240930
     31595632, 28462255, 31261641, 30150606, 31637904, 29217472, 31872230
     30914272, 30241807, 31402078, 29152752, 31615178, 30698289, 29387310
     31404130, 30389821, 29523511, 30295110, 30169254, 29701744, 30028676
     29390785, 29164376, 29388094, 30923940, 30146969, 30971842, 28625862
     30149035, 31670014, 30673082, 30193506, 30508100, 30307883, 30022613
     30288343, 29255718, 30620805, 29184666, 27369515, 30226726, 30330813
     29965603, 29841687, 29770006, 29185193, 30539675, 30486436, 29468589
     31815099, 30668407, 28718469, 30412921, 29395242, 29391849, 31220979
     29860994, 31080474, 30729744, 28319989, 30738976, 30814266, 29724658
     30972464, 29967574, 29157389, 30657706, 29515134, 30189516, 30777759
     29878076, 29936936, 31493840, 30781032, 30764405, 29753244, 27604329
     29584693, 30215351, 31376634, 29240307, 29655862, 27880025, 27873364
     29951759, 30158965, 29404483, 30720736, 31483949, 31045929, 29299844
     30262897, 31664039, 29405651, 30786655, 30495078, 29198092, 30874660
     29893148, 30178839, 29678166, 31871226, 29876493, 29655668, 29261547
     31588830, 31424838, 31489137, 31290300, 28655209, 29148799, 29251259
     30756046, 29338315, 30254525, 30469380, 30591028, 30076461, 28606598
     30264916, 29312753, 31643935, 30486896, 30140462, 30449211, 30285457
     29141316, 29721576, 30657466, 29500826, 30851448, 29229844, 29524599
     29343861, 29756444, 31014323, 29304781, 28897229, 29721974, 29604002
     29460775, 31626886, 28925250, 30692473, 31334961, 29413956, 29906678
     27195935, 31786838, 29465177, 30088792, 29766207, 30193736, 30691604
     31792465, 29559395, 29765219, 29180455, 29887045, 31700234, 31021068
     28687713, 30998035, 29304853, 31234765, 30914674, 31560592, 31697356
     29285197, 29806390, 31022858, 28730079, 29219205, 31396227, 28321248
     29385652, 29483626, 23734075, 30500344, 31735662, 29261906, 30577591
     31839779, 27742354, 29413448, 31098972, 30728561, 30248531, 29938225
     31202536, 28955883, 30714021, 29229839, 29565611, 29677500, 30180208
     32008586, 31520923, 31021750, 29391373, 29795957, 31081083, 29356704
     30565004, 30997375, 31249406, 31448087, 31163391, 31380511, 30876653
     29804875, 30053298, 31842545, 28403019, 28145995, 31748711, 30104555
     29716602, 31765296, 29230565, 30635326, 30235714, 30953266, 31090262
     30498824, 30593046, 31434870, 29026606, 29375941, 31336804, 29858376
     30051563, 29637560, 29163073, 28974083, 31016413, 29793318, 29128935
     28537481, 30485255, 31075323, 30041501, 30786237, 30251003, 29491784
     30751527, 30847442, 30641541, 30718841, 29386502, 29633753, 30942927
     31561886, 32101305, 31019017, 31178103, 30045273, 29293072, 29543956
     29747653, 30274662, 29321489, 30186706, 29244968, 31081558, 30629139
     29461791, 29360950, 29223833, 29225758, 29184297, 29010126, 32321765
     30299367, 29483712, 29490256, 29195279, 31796882, 31233064, 31921267
     28887933, 31265651, 31390370, 30825787, 31843462, 32007698, 29598039
     29285956, 29127489, 29024028, 31367188, 30513500, 30606345, 29687727
     31628798, 30244340, 31217946, 31475635, 30834068, 31029936, 28502773
     29292837, 30749641, 30319099, 30282591, 29495628, 28974999, 29210683
     29611020, 29408853, 30402386, 28900506, 29866596, 29051702, 30159511
     30148999, 29900824, 29058476, 29813671, 28546290, 28644549, 28808652
     30990034, 30194710, 29201695, 28313275, 29462569, 26611353, 30270647
     29500257, 29796916, 29274428, 29707896, 30555276, 29352298, 29393649
     29307090, 30676209, 29416688, 30605215, 30222512, 29339155, 31616104
     31154801, 28781599, 30663646, 30007337, 30549368, 30515886, 29637362
     29599431, 29797726, 28715655, 30686017, 31708133, 29692694, 29963428
     30461458, 29195758, 30381525, 29394014, 30032376, 28818513, 29231133
     31711997, 31193292, 30225439, 28636532, 30727701, 30513848, 30271965
     29766503, 28319114, 29461420, 30499905, 29791186, 29242884, 31347073
     29172618, 31316250, 29231008, 29237744, 20313356, 32033930, 29940373
     30518349, 29309698, 30501574, 31493961, 29870065, 31429770, 29464616
     30658016, 28951588, 29888621, 29122224, 29521748, 31185877, 28734355
     29437379, 29020423, 31403177, 31145804, 31614028, 27801144, 30173556
     31195090, 28825772, 31343110, 29547010, 29656819, 31889222, 30190314
     29353432, 29817598, 29891075, 29340414, 30053036, 30431867, 30283579
     31348711, 29391237, 29410215, 30189535, 26675491, 29347620, 29062692
     29928340, 29209972, 28622202, 29409455, 30936831, 30195027, 29748285
     29210624, 31387426, 30561590, 29194827, 30173370, 30206171, 31778138
     29828644, 30357463, 29651520, 30277120, 31338652, 29443250, 29158680
     30300538, 31537092, 31880154, 29044086, 30866988, 29032607, 30122583
     30641900, 30449837, 30021830, 31668061, 31900585, 29787766, 30436399
     31052809, 29461971, 29643818, 29306226, 30651231, 29452576, 29339084
     27130348, 29505225, 31046619, 29292232, 29896510, 30064268, 29351044
     31853401, 29350762, 31886547, 31609974, 29162095, 30239459, 29451085
     30294671, 31943497, 29260452, 28723237, 28965084, 29472618, 31044951
     29030056, 29168219, 29222031, 30863405, 29247183, 30374650, 30224725
     30133841, 28720418, 30647133, 31146826, 31366716, 30097115, 31125710
     29240759, 29123297, 30275174, 29889184, 30142644, 31165038, 29420834
     31262669, 29934048, 30972959, 28986231, 30758836, 30652515, 29211724
     31605119, 30441959, 30870439, 30576853, 30972817, 28542455, 30073314
     30549637, 29381000, 31820632, 29201539, 31753874, 31421316, 30344614
     17428816, 30389507, 29397841, 30993198, 28810381, 29708353, 30299817
     30412772, 30345926, 30939307, 30704826, 29792433, 31171631, 30264405
     30945005, 30482794, 29233810, 29901419, 29119077, 29497311, 28794230
     30616265, 31383464, 28705231, 31333156, 31628753, 28863263, 29386660
     26001677, 31685476, 29811616, 30833454, 29471633, 31437030, 29828755
     30252098, 28698087, 29338348, 29629681, 30719419, 30264950, 29941062
     30887777, 29637526, 29392554, 30609892, 29194367, 29235934, 29048289
     30559252, 30317209, 30940868, 29742223, 30371623, 30417732, 31042208
     31561819, 30218317, 31429838, 31360469, 31425167, 30359614, 29134447
     30120608, 29152603, 29186091, 29558452, 29815341, 29259119, 30640862
     29775393, 30318638, 29256021, 29597536, 31101386, 30662704, 29014076
     30565595, 30214826, 28721497, 29208732, 31219047, 29552402, 31510790
     30323118, 30444173, 30223217, 30527532, 31128119, 29656843, 27941110
     27935464, 29548687, 29457319, 30076197, 29346057, 30839836, 30285166
     30053748, 29820015, 31188398, 29526966, 31066082, 28849776, 29684210
     31235797, 29694497, 30198239, 29384864, 29356752, 29261171, 30331356
     30968781, 28910498, 30720136, 29168137, 29118754, 27666312, 31112972
     30448182, 29773842, 30898748, 30409339, 28921844, 30275548, 30255528
     31009545, 30292305, 30425441, 29249583, 22580355, 29131539, 29171683
     29559446, 29437506, 29286229, 30358416, 29792213, 29877608, 29250565
     29006318, 31219975, 28513333, 29379978, 29147849, 28204262, 29939698
     31040410, 30449194, 28808314, 29281796, 30994996, 29687763, 29882454
     29997804, 29757099, 30283581, 29530909, 31488381, 31538597, 29930457
     30367193, 30596993, 30059109, 27505699, 29128693, 31698938, 29741319
     29211457, 29332292, 29011936, 29033896, 29325993, 31033307, 29435474
     31867606, 31162711, 30158313, 30724679, 28564479, 30346867, 26668264
     29446319, 31126053, 30755348, 29554092, 30019864, 31621560, 31394341
     29838337, 30442266, 29822858, 29966768, 30224544, 31094688, 29929003
     31502268, 29356782, 30380907, 29130654, 30866727, 30836129, 30095414
     28410431, 28700945, 29281691, 30679771, 29896074, 29249289, 19138896
     30567372, 32089820, 29015118, 30165795, 31360323, 31077542, 30652453
     29891853, 29173140, 30048688, 31132515, 30992330, 29420254, 28847655
     30397100, 29167940, 30392870, 27439716, 30357364, 30803210, 29555663
     30602230, 28959493, 29111598, 29279854, 30495213, 30710807, 30008125
     30313848, 28692103, 29629650, 30780763, 29213351, 28785273, 29255705
     28816871, 29957493, 31503349, 29188255, 30721066, 29939536, 29618074
     29932617, 30318943, 29325257, 30571306, 30035598, 29463798, 30215302
     29722328, 31625618, 29802382, 29957412, 30681521, 30714715, 30828350
     29765393, 29008035, 30622755, 31658943, 29410834, 30665399, 28980448
     30241920, 30044108, 30033476, 31220912, 29505589, 30835853, 30170104
     30602851, 31396695, 29859068, 29135649, 30094929, 29221248, 30074296
     30409116, 29139761, 31163240, 30599405, 31444516, 29179097, 31650202
     30189609, 29312734, 29213613, 29163567, 30083216, 30375109, 30631523
     29212012, 30004856, 29664087, 30038392, 31827912, 30624128, 31066250
     29705711, 30368917, 29607797, 30811597, 31109506, 30025814, 30149658
     31191529, 29446669, 30413722, 30206675, 31230775, 28618343, 31633643
     29207073, 29129476, 30966990, 30372081, 28874529, 31014650, 31388087
     30029806, 31722457, 29229120, 30595728, 30858919, 31770289, 30305880
     30396946, 29458132, 30365745, 28092783, 31119131, 30045484, 30624243
     29838485, 29429895, 29385339, 29669299, 27661222, 31089270, 30148929
     29282090, 29773197, 30869131, 30319294, 31058548, 31829639, 28937717
     30413792, 31792615, 29213879, 30357698, 30629643, 28763291, 30790528
     27957203, 30368482, 28876253, 31098981, 30047931, 31398663, 31739518
     31600894, 30071446, 29274564, 32079739, 30416034, 29632265, 29657422
     29833984, 29178563, 29438277, 30483140, 30460095, 29041739, 31325216
     28824482, 28957292, 29384781, 30314198, 31124363, 31535792, 29616244
     29965888, 31001859, 29973012, 30723671, 29990779, 29495684, 31220549
     30246053, 30512690, 27700413, 31009792, 29504303, 32207088, 29330361
     29594744, 29671933, 30028540, 28887305, 31557663, 29641885, 28470673
     29311336, 31721863, 30103553, 30328690, 29695425, 30724881, 30447080
     30483521, 30735153, 29412269, 29240668, 31835699, 27044169, 30440651
     29132456, 31420488, 30374570, 31659563, 28966444, 29201143, 29611991
     29580983, 29946371, 29785831, 30084746, 29700125, 29634643, 29199733
     32137544, 30804716, 28951533, 30256542, 30871601, 30183920, 29489546
     30332505, 29443187, 31429590, 30839975, 29557556, 32069834, 29364177
     29329807, 30135731, 31849609, 29960884, 29033200, 29839229, 30434074
     30435957, 29971888, 29548413, 31009680, 31139643, 30773164, 29657866
     29903190, 31414282, 30399906, 30644530, 31065838, 29466674, 29372221
     28776431, 30772590, 29372069, 31904933, 31201366, 29397996, 31715935
     30466081, 30965554, 30276243, 29716871, 29331493, 31440709, 29543034
     30433177, 30505029, 25883179, 30234873, 29311588, 30113101, 29213850
     29942554, 29173373, 30417292, 29716491, 31306867, 29264772, 31195838
     28205555, 29290235, 29405462, 30391272, 30164714, 30539519, 29765493
     29423016, 31400353, 30447695, 30871792, 29195337, 30551123, 30319080
     31002223, 29273360, 30863115, 31756415, 31052735, 32150818, 30175587
     27244999, 29216723, 29598226, 29630212, 28646200, 29485099, 29557144
     28104176, 29124368, 29687459, 29424999, 31848063, 29581771, 29139956
     29247712, 29668005, 30461097, 30624864, 29286220, 30973877, 29346211
     29874090, 28649388, 30215130, 31691030, 31523548, 29457241, 29655164
     29190235, 31192039, 31658464, 30480015, 29785239, 29817278, 29521187
     29341209, 30495483, 29813503, 29587720, 28805475, 30973127, 29599552
     28338211, 31317198, 29293928, 31772216, 30523137, 30713133, 27406105
     27260704, 29189307, 30783551, 30080241, 28291441, 30973085, 26123054
     30131854, 30299934, 30569412, 31177193, 28789531, 30594946, 30904672
     30500582, 31881527, 31260692, 31327896, 32048412, 30469777, 29433434
     29677051, 29760252, 31233170, 29175638, 28663782, 29495057, 29225076
     29044954, 31347546, 30127145, 30335832, 29003617, 29048178, 29379750
     29838281, 30213406, 29287705, 31221757, 30368048, 29181620, 30431703
     28681153, 29920025, 30104348, 30321398, 30595969, 31540818, 31917192
     29220079, 31310564, 31433579, 29856890, 29125036, 30842277, 31257740
     31691947, 29802695, 29597716, 32290399, 27745728, 30444545, 31835854
     29384854, 29661028, 30739876, 29360672, 29530356, 30921995, 29169073
     31032904, 29018655, 29794462, 30076253, 30662651, 30883877, 29358828
     30191274, 30363311, 30645896, 30386318, 28935956, 30275569, 29337742
     23294761, 29929061, 30472602, 29593025, 30311826, 31145403, 29200316
     28386259, 30644766, 31447733, 30812574, 29970261, 29797209, 29276220
     31585789, 30715061, 29845530, 29181743, 30182498, 29528119, 29951585
     31403565, 30740669, 30208669, 29190474, 30447589, 31049215, 29531654
     30153463, 31063769, 29123482, 28855922, 30083488, 30937340, 31074032
     29937956, 28210681, 30822401, 31329006, 29360285, 28064977, 29205918
     31513011, 30130240, 29685137, 30100354, 30028599, 21629064, 28950868
     29502953, 30414491, 30561404, 31429501, 30028182, 30698651, 30849022
     29785001, 29946388, 29024552, 29413517, 29559187, 29145214, 29476473
     29672507, 30393110, 28554809, 31676941, 29399121, 28697242, 29285453
     30047157, 30442884, 29224294, 31153120, 30670584, 30246179, 30463747
     29002488, 30232638, 30303080, 30593863, 30284723, 29921318, 31706595
     30750568, 29304314, 29789911, 29225861, 31830466, 29931956, 31195430
     30431274, 31833948, 30003321, 31079204, 31876368, 29825944, 29875459
     29394749, 29050886, 29504682, 28905615, 29997326, 30389414, 30686289
     32266807, 30544595, 31767237, 31389598, 30540109, 31221454, 29363151
     29286300, 29001307, 30998759, 29549040, 30750219, 31204412, 29325087
     31790500, 31339744, 29738400, 31021542, 31913650, 30797842, 29476347
     31044145, 31545477, 29243749, 29191827, 29555105, 28772390, 30252005
     29022986, 29818625, 27036163, 29146077, 29618725, 29249991, 30598746
     31581627, 29255431, 28064731, 29893132, 27494830, 29633697, 30282501
     29229955, 31128452, 29590918, 29449477, 30082930, 30278402, 30204542
     29417884, 29900203, 29921525, 32130083, 31470893, 30404153, 31816158
     30027614, 31038220, 30209222, 29921907, 29626732, 29390011, 29603460
     29285621, 31067892, 30238715, 29249412, 30973143, 28690694, 29118543
     31254535, 27929509, 30225443, 30265703, 29716194, 29872983, 29869404
     30447060, 28865569, 29817784, 30494259, 31752502, 29171942, 29993717
     30259120, 31655807, 31961940, 31003137, 31051056



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

OPatch succeeded.

U:\software\19.11windows\32409154>opatch rollback -id 32067171
Oracle Interim Patch Installer version 12.2.0.1.24
Copyright (c) 2021, Oracle Corporation.  All rights reserved.


Oracle Home       : C:\oracle\product\19
Central Inventory : C:\Program Files\Oracle\Inventory
   from           :
OPatch version    : 12.2.0.1.24
OUI version       : 12.2.0.7.0
Log file location : C:\oracle\product\19\cfgtoollogs\opatch\opatch2021-07-02_14-29-21PM_1.log


Patches will be rolled back in the following order:
   32067171
The following patch(es) will be rolled back: 32067171

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = 'C:\oracle\product\19')


Is the local system ready for patching? [y|n]
y
User Responded with: Y

Rolling back patch 32067171...

RollbackSession rolling back interim patch '32067171' from OH 'C:\oracle\product\19'

Patching component oracle.rdbms, 19.0.0.0.0...

Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...

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

Patching component oracle.javavm.client, 19.0.0.0.0...
RollbackSession removing interim patch '32067171' from inventory
Log file location: C:\oracle\product\19\cfgtoollogs\opatch\opatch2021-07-02_14-29-21PM_1.log

OPatch succeeded.

U:\software\19.11windows\32409154>opatch apply
Oracle Interim Patch Installer version 12.2.0.1.24
Copyright (c) 2021, Oracle Corporation.  All rights reserved.


Oracle Home       : C:\oracle\product\19
Central Inventory : C:\Program Files\Oracle\Inventory
   from           :
OPatch version    : 12.2.0.1.24
OUI version       : 12.2.0.7.0
Log file location : C:\oracle\product\19\cfgtoollogs\opatch\opatch2021-07-02_14-29-56PM_1.log

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

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 = 'C:\oracle\product\19')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '32409154' to OH 'C:\oracle\product\19'
ApplySession: Optional component(s) [ oracle.assistants.usm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.has.deconfig, 19.0.0.0.0 ] , [ oracle.swd.oui, 19.0.0.0.0 ] , [ oracle.has.cfs, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.ons.daemon, 19.0.0.0.0 ] , [ oracle.options.olap.awm, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.usm, 19.0.0.0.0 ] , [ oracle.swd.oui.core.min, 19.0.0.0.0 ] , [ oracle.tomcat.crs, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.has.crs, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.has.cvu, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.sdo, 19.0.0.0.0...

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

Patching component oracle.aspnet_2, 19.0.0.0.0...

Patching component oracle.dbjava.ic, 19.0.0.0.0...

Patching component oracle.ons, 19.0.0.0.0...

Patching component oracle.ntoramts, 19.0.0.0.0...

Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...

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

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

Patching component oracle.rdbms, 19.0.0.0.0...

Patching component oracle.blaslapack, 19.0.0.0.0...

Patching component oracle.rdbms.oci, 19.0.0.0.0...

Patching component oracle.assistants.acf, 19.0.0.0.0...

Patching component oracle.duma, 19.0.0.0.0...

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

Patching component oracle.tfa.db, 19.0.0.0.0...

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

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

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

Patching component oracle.precomp.common, 19.0.0.0.0...

Patching component oracle.dbjava.jdbc, 19.0.0.0.0...

Patching component oracle.rdbms.hsodbc, 19.0.0.0.0...

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

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

Patching component oracle.rsf, 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.precomp.lang, 19.0.0.0.0...

Patching component oracle.install.deinstalltool, 19.0.0.0.0...

Patching component oracle.ctx, 19.0.0.0.0...

Patching component oracle.dbjava.ucp, 19.0.0.0.0...

Patching component oracle.javavm.client, 19.0.0.0.0...

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

Patching component oracle.ntoledb.odp_net_2, 19.0.0.0.0...

Patching component oracle.rdbms.util, 19.0.0.0.0...

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

Patching component oracle.usm.deconfig, 19.0.0.0.0...

Patching component oracle.assistants.server, 19.0.0.0.0...

Patching component oracle.rdbms.deconfig, 19.0.0.0.0...

Patching component oracle.ntoledb, 19.0.0.0.0...

Patching component oracle.has.common, 19.0.0.0.0...

Patching component oracle.assistants.deconfig, 19.0.0.0.0...

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

Patching component oracle.ovm, 19.0.0.0.0...

Patching component oracle.has.db, 19.0.0.0.0...

Patching component oracle.rdbms.plsql, 19.0.0.0.0...

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

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

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

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

Patching component oracle.rdbms.olap, 19.0.0.0.0...

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

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

Patching component oracle.ldap.owm, 19.0.0.0.0...

Patching component oracle.rdbms.rsf, 19.0.0.0.0...

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

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

Patching component oracle.oraolap, 19.0.0.0.0...

Patching component oracle.clrintg.ode_net_2, 19.0.0.0.0...

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

Patching component oracle.has.rsf, 19.0.0.0.0...

Patching component oracle.odbc.ic, 19.0.0.0.0...

Patching component oracle.sqlplus, 19.0.0.0.0...

Patching component oracle.has.common.cvu, 19.0.0.0.0...
Patch 32409154 successfully applied.
Sub-set patch [32062765] has become inactive due to the application of a super-set patch [32409154].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: C:\oracle\product\19\cfgtoollogs\opatch\opatch2021-07-02_14-29-56PM_1.log

OPatch succeeded.

U:\software\19.11windows\32409154>cd U:\software\19.11windows_jvm\32399816

U:\software\19.11windows_jvm\32399816>opatch apply
Oracle Interim Patch Installer version 12.2.0.1.24
Copyright (c) 2021, Oracle Corporation.  All rights reserved.


Oracle Home       : C:\oracle\product\19
Central Inventory : C:\Program Files\Oracle\Inventory
   from           :
OPatch version    : 12.2.0.1.24
OUI version       : 12.2.0.7.0
Log file location : C:\oracle\product\19\cfgtoollogs\opatch\opatch2021-07-02_14-33-47PM_1.log

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

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 = 'C:\oracle\product\19')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '32399816' to OH 'C:\oracle\product\19'

Patching component oracle.rdbms, 19.0.0.0.0...

Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...

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

Patching component oracle.javavm.client, 19.0.0.0.0...
Patch 32399816 successfully applied.
Log file location: C:\oracle\product\19\cfgtoollogs\opatch\opatch2021-07-02_14-33-47PM_1.log

OPatch succeeded.

U:\software\19.11windows_jvm\32399816>c:

C:\oracle\product\19\OPatch>set ORACLE_SID
ORACLE_SID=db19
-- started the database via services.msc

C:\oracle\product\19\OPatch>sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jul 2 14:37:00 2021
Version 19.11.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.11.0.0.0

SQL> alter pluggable database all open;

Pluggable database altered.

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.11.0.0.0

C:\oracle\product\19\OPatch>datapatch -verbose
SQL Patching tool version 19.3.0.0.0 Production on Fri Jul  2 14:37:13 2021
Copyright (c) 2012, 2019, Oracle.  All rights reserved.

Log file for this invocation: C:\oracle\cfgtoollogs\sqlpatch\sqlpatch_52744_2021_07_02_14_37_13\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:
Interim patch 30805684 (OJVM RELEASE UPDATE: 19.7.0.0.200414 (30805684)):
  Binary registry: Not installed
  PDB CDB$ROOT: Rolled back successfully on 18-AUG-20 03.01.52.708000 PM
  PDB PDB$SEED: Rolled back successfully on 18-AUG-20 03.01.53.936000 PM
  PDB PDB1: Rolled back successfully on 18-AUG-20 03.01.55.164000 PM
Interim patch 31219897 (OJVM RELEASE UPDATE: 19.8.0.0.200714 (31219897)):
  Binary registry: Not installed
  PDB CDB$ROOT: Rolled back successfully on 27-APR-21 12.22.18.235000 PM
  PDB PDB$SEED: Rolled back successfully on 27-APR-21 12.22.20.889000 PM
  PDB PDB1: Rolled back successfully on 27-APR-21 12.22.23.524000 PM
Interim patch 32067171 (OJVM RELEASE UPDATE 19.10.0.0.0 (32067171)):
  Binary registry: Not installed
  PDB CDB$ROOT: Applied successfully on 27-APR-21 12.22.20.866000 PM
  PDB PDB$SEED: Applied successfully on 27-APR-21 12.22.23.509000 PM
  PDB PDB1: Applied successfully on 27-APR-21 12.22.25.497000 PM
Interim patch 32399816 (OJVM RELEASE UPDATE 19.11.0.0.0 (32399816)):
  Binary registry: Installed
  PDB CDB$ROOT: Not installed
  PDB PDB$SEED: Not installed
  PDB PDB1: Not installed

Current state of release update SQL patches:
  Binary registry:
    19.11.0.0.0 Release_Update 210417094636: Installed
  PDB CDB$ROOT:
    Applied 19.10.0.0.0 Release_Update 210122180248 successfully on 27-APR-21 12.22.20.859000 PM
  PDB PDB$SEED:
    Applied 19.10.0.0.0 Release_Update 210122180248 successfully on 27-APR-21 12.22.23.502000 PM
  PDB PDB1:
    Applied 19.10.0.0.0 Release_Update 210122180248 successfully on 27-APR-21 12.22.25.494000 PM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED
    The following interim patches will be rolled back:
      32067171 (OJVM RELEASE UPDATE 19.10.0.0.0 (32067171))
    Patch 32409154 (Windows Database Bundle Patch : 19.11.0.0.210420 (32409154)):
      Apply from 19.10.0.0.0 Release_Update 210122180248 to 19.11.0.0.0 Release_Update 210417094636
    The following interim patches will be applied:
      32399816 (OJVM RELEASE UPDATE 19.11.0.0.0 (32399816))
  For the following PDBs: PDB1
    The following interim patches will be rolled back:
      32067171 (OJVM RELEASE UPDATE 19.10.0.0.0 (32067171))
    Patch 32409154 (Windows Database Bundle Patch : 19.11.0.0.210420 (32409154)):
      Apply from 19.10.0.0.0 Release_Update 210122180248 to 19.11.0.0.0 Release_Update 210417094636
    The following interim patches will be applied:
      32399816 (OJVM RELEASE UPDATE 19.11.0.0.0 (32399816))

Installing patches...
Patch installation complete.  Total patches installed: 9

Validating logfiles...done
Patch 32067171 rollback (pdb CDB$ROOT): SUCCESS
  logfile: C:\oracle\cfgtoollogs\sqlpatch\32067171\24096715/32067171_rollback_DB19_CDBROOT_2021Jul02_14_37_57.log (no errors)
Patch 32409154 apply (pdb CDB$ROOT): SUCCESS
  logfile: C:\oracle\cfgtoollogs\sqlpatch\32409154\24073904/32409154_apply_DB19_CDBROOT_2021Jul02_14_38_31.log (no errors)
Patch 32399816 apply (pdb CDB$ROOT): SUCCESS
  logfile: C:\oracle\cfgtoollogs\sqlpatch\32399816\24198329/32399816_apply_DB19_CDBROOT_2021Jul02_14_38_31.log (no errors)
Patch 32067171 rollback (pdb PDB$SEED): SUCCESS
  logfile: C:\oracle\cfgtoollogs\sqlpatch\32067171\24096715/32067171_rollback_DB19_PDBSEED_2021Jul02_14_39_51.log (no errors)
Patch 32409154 apply (pdb PDB$SEED): SUCCESS
  logfile: C:\oracle\cfgtoollogs\sqlpatch\32409154\24073904/32409154_apply_DB19_PDBSEED_2021Jul02_14_40_01.log (no errors)
Patch 32399816 apply (pdb PDB$SEED): SUCCESS
  logfile: C:\oracle\cfgtoollogs\sqlpatch\32399816\24198329/32399816_apply_DB19_PDBSEED_2021Jul02_14_40_01.log (no errors)
Patch 32067171 rollback (pdb PDB1): SUCCESS
  logfile: C:\oracle\cfgtoollogs\sqlpatch\32067171\24096715/32067171_rollback_DB19_PDB1_2021Jul02_14_40_39.log (no errors)
Patch 32409154 apply (pdb PDB1): SUCCESS
  logfile: C:\oracle\cfgtoollogs\sqlpatch\32409154\24073904/32409154_apply_DB19_PDB1_2021Jul02_14_40_49.log (no errors)
Patch 32399816 apply (pdb PDB1): SUCCESS
  logfile: C:\oracle\cfgtoollogs\sqlpatch\32399816\24198329/32399816_apply_DB19_PDB1_2021Jul02_14_40_49.log (no errors)

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

SQL Patching tool complete on Fri Jul  2 14:41:37 2021
C:\oracle\product\19\OPatch>cd ..\rdbms\admin

C:\oracle\product\19\rdbms\admin>sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jul 2 14:42:27 2021
Version 19.11.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.11.0.0.0

SQL> @utlrp.sql

Session altered.


TIMESTAMP
----------------------------------------------------------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN              2021-07-02 14:42:34

DOC>   The following PL/SQL block invokes UTL_RECOMP to recompile invalid
DOC>   objects in the database. Recompilation time is proportional to the
DOC>   number of invalid objects in the database, so this command may take
DOC>   a long time to execute on a database with a large number of invalid
DOC>   objects.
DOC>
DOC>   Use the following queries to track recompilation progress:
DOC>
DOC>   1. Query returning the number of invalid objects remaining. This
DOC>      number should decrease with time.
DOC>         SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);
DOC>
DOC>   2. Query returning the number of objects compiled so far. This number
DOC>      should increase with time.
DOC>         SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC>   This script automatically chooses serial or parallel recompilation
DOC>   based on the number of CPUs available (parameter cpu_count) multiplied
DOC>   by the number of threads per CPU (parameter parallel_threads_per_cpu).
DOC>   On RAC, this number is added across all RAC nodes.
DOC>
DOC>   UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel
DOC>   recompilation. Jobs are created without instance affinity so that they
DOC>   can migrate across RAC nodes. Use the following queries to verify
DOC>   whether UTL_RECOMP jobs are being created and run correctly:
DOC>
DOC>   1. Query showing jobs created by UTL_RECOMP
DOC>         SELECT job_name FROM dba_scheduler_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>
DOC>   2. Query showing UTL_RECOMP jobs that are running
DOC>         SELECT job_name FROM dba_scheduler_running_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#

PL/SQL procedure successfully completed.


TIMESTAMP
----------------------------------------------------------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END              2021-07-02 14:42:35

DOC> The following query reports the number of invalid objects.
DOC>
DOC> If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#

OBJECTS WITH ERRORS
-------------------
                  0

DOC> The following query reports the number of exceptions caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC> Note: Typical compilation errors (due to coding errors) are not
DOC>       logged into this table: they go into DBA_ERRORS instead.
DOC>#

ERRORS DURING RECOMPILATION
---------------------------
                          0


Function created.


PL/SQL procedure successfully completed.


Function dropped.


PL/SQL procedure successfully completed.

SQL> alter session set container = pdb1;

Session altered.

SQL> @utlrp.sql

Session altered.


TIMESTAMP
----------------------------------------------------------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN              2021-07-02 14:42:44

DOC>   The following PL/SQL block invokes UTL_RECOMP to recompile invalid
DOC>   objects in the database. Recompilation time is proportional to the
DOC>   number of invalid objects in the database, so this command may take
DOC>   a long time to execute on a database with a large number of invalid
DOC>   objects.
DOC>
DOC>   Use the following queries to track recompilation progress:
DOC>
DOC>   1. Query returning the number of invalid objects remaining. This
DOC>      number should decrease with time.
DOC>         SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);
DOC>
DOC>   2. Query returning the number of objects compiled so far. This number
DOC>      should increase with time.
DOC>         SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC>   This script automatically chooses serial or parallel recompilation
DOC>   based on the number of CPUs available (parameter cpu_count) multiplied
DOC>   by the number of threads per CPU (parameter parallel_threads_per_cpu).
DOC>   On RAC, this number is added across all RAC nodes.
DOC>
DOC>   UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel
DOC>   recompilation. Jobs are created without instance affinity so that they
DOC>   can migrate across RAC nodes. Use the following queries to verify
DOC>   whether UTL_RECOMP jobs are being created and run correctly:
DOC>
DOC>   1. Query showing jobs created by UTL_RECOMP
DOC>         SELECT job_name FROM dba_scheduler_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>
DOC>   2. Query showing UTL_RECOMP jobs that are running
DOC>         SELECT job_name FROM dba_scheduler_running_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#

PL/SQL procedure successfully completed.


TIMESTAMP
----------------------------------------------------------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END              2021-07-02 14:42:48

DOC> The following query reports the number of invalid objects.
DOC>
DOC> If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#

OBJECTS WITH ERRORS
-------------------
                 51

DOC> The following query reports the number of exceptions caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC> Note: Typical compilation errors (due to coding errors) are not
DOC>       logged into this table: they go into DBA_ERRORS instead.
DOC>#

ERRORS DURING RECOMPILATION
---------------------------
                          0


Function created.


PL/SQL procedure successfully completed.


Function dropped.


PL/SQL procedure successfully completed.

SQL>

One comment

  1. Hi Connor, thanks for this amazing post and video. However i am stuck with unusable FDA history data because of the persistent ora 8181 error each time i try to retrieve data using the scn to timestamp conversion. I wish you take this issue also with the development team. In my opinion the design is improper to have FDA look for already deleted records from the scn to timestamp mapping table with scn values are still present in fda history tables which than generates this error. I have seen some workarounds for this which should have come out of the box. E.g create your own mapping table.
    Thanks in advance.

Got some thoughts? Leave a comment

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

WordPress.com Logo

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

Google photo

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

Twitter picture

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

Facebook photo

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

Connecting to %s

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