19.11 Database Release Update
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.
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>