Skip to content
Home » Oracle Database » How to Patch Oracle Database 19c on Linux (DBRU 19.9)

How to Patch Oracle Database 19c on Linux (DBRU 19.9)

Here are steps to apply Database Release Update (DBRU) 19.9 (p31771877) on Oracle database 19.3.

  1. Upload Patches
  2. Update Opatch utility
  3. Backup Oracle Home
  4. Apply Release Update
  5. Post-installation
  6. Recompile Invalid Stored Procedure

Upload Patches

We should download the newest Opatch utility and release update for Oracle database 19.3 form MOS, and then upload them to the server.

> sftp [email protected]:/sources/patches
sftp> put p6880880_190000_Linux-x86-64.zip
sftp> put p31771877_190000_Linux-x86-64.zip

In which, p6880880 is the latest OPatch utility.

Update Opatch utility

Here we follow a practical procedure to update Opatch utility.

opatch version

Let's see what version of OPatch we have after updating it.

[oracle@test ~]$ opatch version
OPatch Version: 12.2.0.1.23

OPatch succeeded.

If you saw error opatch: command not found in the last command, you should add path $ORACLE_HOME/OPatch to $PATH environment variable.

[oracle@test ~]$ export PATH=$PATH:$ORACLE_HOME/OPatch

Adding the path to the user's profile is recommended.

Backup Oracle Home

Stop Database

Before backing up Oracle home and applying patches, please stop Oracle database, then make sure the instance is idle.

[oracle@test ~]$ ps -ef | grep smon | grep -v grep
[oracle@test ~]$ echo $?
1

1 means that the instance does not exist.

Backup Oracle Home

In case that you need to restore Oracle home back to the original state, we should take a backup on Oracle home by tar or zip command.

Apply Release Update

Unzip Patch

Unzip the DBRU p31771877. We aim at updating the database to release 19.9.

[oracle@test ~]$ unzip -q /sources/patches/p31771877_190000_Linux-x86-64.zip -d /sources/patches

Check current inventory of Oracle home.

opatch lspatches

[oracle@test ~]$ opatch lspatches
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)

OPatch succeeded.

opatch lsinventory

[oracle@test ~]$ opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.23
Copyright (c) 2020, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/19.3.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.23
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2020-12-15_23-52-57PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2020-12-15_23-52-57PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: test
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 19c                                                  19.0.0.0.0
There are 1 products installed in this Oracle Home.


Interim patches (2) :

Patch  29585399     : applied on Thu Apr 18 03:21:33 EDT 2019
Unique Patch ID:  22840393
Patch description:  "OCW RELEASE UPDATE 19.3.0.0.0 (29585399)"
   Created on 9 Apr 2019, 19:12:47 hrs PST8PDT
   Bugs fixed:
     27222128, 27572040, 27604329, 27760043, 27877830, 28302580, 28470673
     28621543, 28642469, 28699321, 28710663, 28755846, 28772816, 28785321
     28800508, 28808652, 28815557, 28847541, 28847572, 28870496, 28871040
     28874416, 28877252, 28881191, 28881848, 28888083, 28911140, 28925250
     28925460, 28935956, 28940472, 3, 28942694, 28951332, 28963036, 28968779
     28980448, 28995287, 29003207, 29003617, 29016294, 29018680, 29024876
     29026154, 29027933, 29047127, 29052850, 29058476, 29111631, 29112455
     29117337, 29123444, 29125708, 29125786, 29129476, 29131772, 29132456
     29139727, 29146157, 29147849, 29149170, 29152603, 29152752, 29154631
     29154636, 29154829, 29159216, 29159661, 29160462, 29161923, 29169540
     29169739, 29170717, 29173618, 29181568, 29182920, 29183298, 29186091
     29191827, 29201143, 29201695, 29209545, 29210577, 29210610, 29210624
     29210683, 29213641, 29219627, 29224294, 29225861, 29229839, 29235934
     29242906, 29243749, 29244495, 29244766, 29244968, 29248723, 29249583
     29251564, 29255616, 29260224, 29261695, 29271019, 29273360, 29282090
     29282666, 29285453, 29285621, 29290235, 29292232, 29293806, 29294753
     29299830, 29307090, 29307109, 29311336, 29329675, 29330791, 29339299
     29357821, 29360467, 29360775, 29367971, 29368725, 29379299, 29379381
     29380527, 29381000, 29382296, 29391301, 29393649, 29402110, 29411931
     29413360, 29457319, 29465047

Patch  29517242     : applied on Thu Apr 18 03:21:17 EDT 2019
Unique Patch ID:  22862832
Patch description:  "Database Release Update : 19.3.0.0.190416 (29517242)"
   Created on 17 Apr 2019, 23:27:10 hrs PST8PDT
   Bugs fixed:
     29515240, 14735102, 19697993, 20313356, 21965541, 25806201, 25883179
     25986062, 26476244, 26611353, 26872233, 27369515, 27423500, 27666312
     27710072, 27846298, 27957203, 28064977, 28072567, 28129791, 28181021
     28210681, 28279456, 28313275, 28350595, 28371123, 28379065, 28431445
     28463226, 28489419, 28502773, 28513333, 28534475, 28561704, 28569897
     28572533, 28572544, 28587723, 28593682, 28594086, 28597221, 28601957
     28605066, 28606598, 28625862, 28627033, 28636532, 28643718, 28644549
     28645570, 28646200, 28646939, 28649388, 28655209, 28663782, 28673945
     28692275, 28694872, 28696373, 28705231, 28710385, 28710734, 28714461
     28718469, 28730079, 28740708, 28760206, 28772390, 28774416, 28777214
     28789531, 28791852, 28795551, 28802734, 28804517, 28810381, 28811560
     28815123, 28815355, 28819640, 28824482, 28833912, 28835937, 28862532
     28863432, 28873575, 28876253, 28876639, 28884931, 28888327, 28892794
     28897512, 28899663, 28901126, 28905457, 28907196, 28912691, 28915561
     28917080, 28918429, 28919145, 28922227, 28922532, 28922608, 28925634
     28925880, 28933158, 28936114, 28937717, 28938698, 28940179, 28940281
     28941901, 28942455, 28945421, 28945994, 28951533, 28952168, 28954762
     28955606, 28957292, 28957723, 28962775, 28965231, 28966444, 28974083
     28977322, 28983095, 28983486, 28986326, 28986481, 28988482, 28989306
     28993295, 28994307, 28996376, 29000000, 29001888, 29002927, 29003738
     29006318, 29006621, 29007321, 29007775, 29008035, 29011936, 29013475
     29014076, 29015118, 29017265, 29018655, 29019121, 29021063, 29021352
     29024552, 29026582, 29026606, 29027456, 29027694, 29027940, 29031575
     29031600, 29032234, 29032457, 29032607, 29033052, 29033145, 29033200
     29033280, 29034587, 29037290, 29038528, 29039089, 29039510, 29043554
     29043651, 29043725, 29044763, 29044954, 29047850, 29048289, 29048498
     29048605, 29050560, 29050765, 29051702, 29052726, 29053783, 29056024
     29056270, 29056560, 29059011, 29061959, 29062692, 29062848, 29062860
     29062868, 29110526, 29110783, 29110790, 29110797, 29110802, 29110805
     29111598, 29113282, 29113305, 29117526, 29117642, 29119077, 29120223
     29122224, 29122254, 29123297, 29123432, 29123482, 29124368, 29125380
     29126345, 29127957, 29128935, 29129450, 29129497, 29129712, 29130219
     29131539, 29132938, 29134447, 29136111, 29138641, 29141316, 29141341
     29141685, 29142667, 29144995, 29145214, 29145730, 29149829, 29150338
     29151520, 29152357, 29155099, 29157389, 29158680, 29158899, 29159909
     29159936, 29160174, 29162095, 29163415, 29163437, 29163524, 29163567
     29167111, 29167342, 29167374, 29167940, 29168219, 29168433, 29169073
     29169215, 29171942, 29172618, 29172826, 29173140, 29173373, 29173817
     29174004, 29176318, 29177466, 29177543, 29177886, 29178385, 29180313
     29180455, 29180559, 29180893, 29181153, 29181231, 29181620, 29181743
     29181923, 29182019, 29183912, 29184297, 29184666, 29185193, 29186456
     29189302, 29189307, 29189889, 29190235, 29190474, 29190740, 29191541
     29192419, 29192468, 29192685, 29193207, 29194205, 29194367, 29194493
     29194827, 29195279, 29195337, 29195758, 29196725, 29199635, 29199733
     29200316, 29200700, 29201494, 29201539, 29202104, 29202850, 29203122
     29203166, 29203425, 29203443, 29203604, 29205281, 29205323, 29205419
     29205463, 29205767, 29205918, 29206109, 29206605, 29207073, 29208260
     29208732, 29211457, 29211724, 29212012, 29212433, 29212611, 29213351
     29213775, 29213850, 29213879, 29214561, 29214960, 29216746, 29216984
     29217294, 29217472, 29217828, 29217848, 29218570, 29219205, 29219273
     29220079, 29221248, 29221891, 29222031, 29222784, 29223833, 29223859
     29223967, 29224065, 29224605, 29225076, 29227602, 29228869, 29229164
     29229754, 29229844, 29229955, 29230252, 29230565, 29231133, 29232117
     29232154, 29234123, 29237538, 29240307, 29241345, 29242017, 29242884
     29243958, 29245137, 29245160, 29246163, 29247415, 29247712, 29247906
     29248552, 29248835, 29248858, 29249991, 29250059, 29251259, 29253184
     29253871, 29254031, 29254930, 29255178, 29255273, 29255431, 29255435
     29256426, 29259119, 29259320, 29261906, 29262512, 29262887, 29265448
     29266248, 29266899, 29267292, 29268412, 29269171, 29270585, 29273539
     29273735, 29273847, 29274428, 29274564, 29274627, 29275461, 29278218
     29279658, 29279751, 29279854, 29282898, 29285503, 29285788, 29285956
     29286037, 29287130, 29287705, 29292837, 29293072, 29297863, 29297915
     29298220, 29299049, 29299082, 29299844, 29301566, 29302963, 29303918
     29304781, 29311588, 29312310, 29312734, 29312753, 29313347, 29313417
     29313525, 29314539, 29318410, 29319441, 29321489, 29323946, 29324568
     29325087, 29325105, 29325257, 29325993, 29327044, 29329087, 29331209
     29331380, 29331493, 29332771, 29333500, 29337310, 29338315, 29338453
     29338780, 29338913, 29339155, 29341209, 29343086, 29346943, 29347620
     29348176, 29350052, 29351386, 29351716, 29351749, 29352867, 29353271
     29355654, 29356547, 29356752, 29358828, 29360672, 29361801, 29363151
     29364171, 29364177, 29367019, 29367561, 29368253, 29373418, 29373588
     29374179, 29377986, 29378029, 29379978, 29382784, 29385652, 29386502
     29386635, 29386660, 29387274, 29388094, 29388524, 29388830, 29389889
     29390435, 29394140, 29394749, 29397954, 29398863, 29399100, 29399121
     29405012, 29405651, 29412066, 29412269, 29417884, 29423826, 29429264
     29429566, 29431485, 29435652, 29438736, 29439522, 29450421, 29451386
     29452576, 29452953, 29457807, 29460252, 29462957, 29486181, 29507616
     29521748, 29530812, 29531654, 29557336, 29558975, 29601461



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

OPatch succeeded.

opatch prereq

We switch directory to the patch, then perform a prerequisite check to detect any conflict.

[oracle@test ~]$ cd /sources/patches/31771877/
[oracle@test 31771877]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.23
Copyright (c) 2020, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/19.3.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.23
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2020-12-15_23-52-09PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

opatch apply

Start to apply release update.

[oracle@test 31771877]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.23
Copyright (c) 2020, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/19.3.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.23
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2020-12-16_00-53-49AM_1.log

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

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/19.3.0/dbhome_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '31771877' to OH '/u01/app/oracle/product/19.3.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.options.olap.awm, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.assistants.usm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.sqlj, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ]  not present in the Oracle Home or a higher version is found.

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

Patching component oracle.rdbms, 19.0.0.0.0...

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

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

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

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

Patching component oracle.buildtools.rsf, 19.0.0.0.0...

Patching component oracle.ctx, 19.0.0.0.0...

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

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

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

Patching component oracle.dbtoolslistener, 19.0.0.0.0...

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

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

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

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

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

Patching component oracle.sdo, 19.0.0.0.0...

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

Patching component oracle.sqlplus, 19.0.0.0.0...

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

Patching component oracle.rdbms.crs, 19.0.0.0.0...

Patching component oracle.oraolap, 19.0.0.0.0...

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

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

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

Patching component oracle.network.client, 19.0.0.0.0...

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

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

Patching component oracle.marvel, 19.0.0.0.0...

Patching component oracle.oraolap.dbscripts, 19.0.0.0.0...

Patching component oracle.ovm, 19.0.0.0.0...

Patching component oracle.bali.ice, 11.1.1.7.0...

Patching component oracle.ctx.rsf, 19.0.0.0.0...

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

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

Patching component oracle.odbc, 19.0.0.0.0...

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

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

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

Patching component oracle.rdbms.drdaas, 19.0.0.0.0...

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

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

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

Patching component oracle.ons, 19.0.0.0.0...

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

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

Patching component oracle.xdk, 19.0.0.0.0...

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

Patching component oracle.dbdev, 19.0.0.0.0...

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

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

Patching component oracle.duma, 19.0.0.0.0...

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

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

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

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

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

Patching component oracle.precomp.lang, 19.0.0.0.0...

Patching component oracle.jdk, 1.8.0.201.0...
Patch 31771877 successfully applied.
Sub-set patch [29517242] has become inactive due to the application of a super-set patch [31771877].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2020-12-16_00-53-49AM_1.log

OPatch succeeded.

opatch lspatches

We may check current patch level.

[oracle@test 31771877]$ opatch lspatches
31771877;Database Release Update : 19.9.0.0.201020 (31771877)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)

OPatch succeeded.

opatch lsinventory

Check current inventory again.

[oracle@test 31771877]$ opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.23
Copyright (c) 2020, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/19.3.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.23
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2020-12-16_01-01-19AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2020-12-16_01-01-19AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: test
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 19c                                                  19.0.0.0.0
There are 1 products installed in this Oracle Home.


Interim patches (2) :

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

Patch  29585399     : applied on Thu Apr 18 03:21:33 EDT 2019
Unique Patch ID:  22840393
Patch description:  "OCW RELEASE UPDATE 19.3.0.0.0 (29585399)"
   Created on 9 Apr 2019, 19:12:47 hrs PST8PDT
   Bugs fixed:
     27222128, 27572040, 27604329, 27760043, 27877830, 28302580, 28470673
     28621543, 28642469, 28699321, 28710663, 28755846, 28772816, 28785321
     28800508, 28808652, 28815557, 28847541, 28847572, 28870496, 28871040
     28874416, 28877252, 28881191, 28881848, 28888083, 28911140, 28925250
     28925460, 28935956, 28940472, 3, 28942694, 28951332, 28963036, 28968779
     28980448, 28995287, 29003207, 29003617, 29016294, 29018680, 29024876
     29026154, 29027933, 29047127, 29052850, 29058476, 29111631, 29112455
     29117337, 29123444, 29125708, 29125786, 29129476, 29131772, 29132456
     29139727, 29146157, 29147849, 29149170, 29152603, 29152752, 29154631
     29154636, 29154829, 29159216, 29159661, 29160462, 29161923, 29169540
     29169739, 29170717, 29173618, 29181568, 29182920, 29183298, 29186091
     29191827, 29201143, 29201695, 29209545, 29210577, 29210610, 29210624
     29210683, 29213641, 29219627, 29224294, 29225861, 29229839, 29235934
     29242906, 29243749, 29244495, 29244766, 29244968, 29248723, 29249583
     29251564, 29255616, 29260224, 29261695, 29271019, 29273360, 29282090
     29282666, 29285453, 29285621, 29290235, 29292232, 29293806, 29294753
     29299830, 29307090, 29307109, 29311336, 29329675, 29330791, 29339299
     29357821, 29360467, 29360775, 29367971, 29368725, 29379299, 29379381
     29380527, 29381000, 29382296, 29391301, 29393649, 29402110, 29411931
     29413360, 29457319, 29465047



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

OPatch succeeded.

Post-installation

Start Database

Here we use dbstart to startup the database.

[oracle@test 31771877]$ dbstart $ORACLE_HOME
Processing Database instance "ORCLCDB": log file /u01/app/oracle/product/19.3.0/dbhome_1/rdbms/log/startup.log

Alter Pluggable Database All Open

Open all pluggable database.

SQL> conn / as sysdba
Connected.
SQL> alter pluggable database all open;

Pluggable database altered.

datapatch -verbose

Load modified SQL data. It may take a while to complete.

[oracle@test 31771877]$ datapatch -verbose
SQL Patching tool version 19.9.0.0.0 Production on Wed Dec 16 01:27:26 2020
Copyright (c) 2012, 2020, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_5669_2020_12_16_01_27_26/sqlpatch_invocation.log

Connecting to database...OK
Gathering database info...done

Note:  Datapatch will only apply or rollback SQL fixes for PDBs
       that are in an open state, no patches will be applied to closed PDBs.
       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
       (Doc ID 1585822.1)

Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of interim SQL patches:
  No interim patches found

Current state of release update SQL patches:
  Binary registry:
    19.9.0.0.0 Release_Update 200930183249: Installed
  PDB CDB$ROOT:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 14-JUL-20 11.10.04.101479 PM
  PDB ORCLPDB1:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 14-JUL-20 11.17.37.129206 PM
  PDB PDB$SEED:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 14-JUL-20 11.17.37.129206 PM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED ORCLPDB1
    No interim patches need to be rolled back
    Patch 31771877 (Database Release Update : 19.9.0.0.201020 (31771877)):
      Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.9.0.0.0 Release_Update 200930183249
    No interim patches need to be applied

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

Validating logfiles...done
Patch 31771877 apply (pdb CDB$ROOT): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/31771877/23869227/31771877_apply_ORCLCDB_CDBROOT_2020Dec16_01_28_03.log (no errors)
Patch 31771877 apply (pdb PDB$SEED): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/31771877/23869227/31771877_apply_ORCLCDB_PDBSEED_2020Dec16_01_35_32.log (no errors)
Patch 31771877 apply (pdb ORCLPDB1): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/31771877/23869227/31771877_apply_ORCLCDB_ORCLPDB1_2020Dec16_01_35_32.log (no errors)
SQL Patching tool complete on Wed Dec 16 01:47:23 2020

Check SQL Patch Level

Just like we said in how to check database version, we can check the SQL patch level by querying DBA_REGISTRY_SQLPATCH:

SQL> select description from dba_registry_sqlpatch order by action_time desc;

DESCRIPTION
--------------------------------------------------------------------------------
Database Release Update : 19.9.0.0.201020 (31771877)
Database Release Update : 19.3.0.0.190416 (29517242)

Recompile Invalid Stored Procedure

Recompile Invalid Objects

We use utlrp.sql to recompile invalid objects in all databases, including CDB and all PDB.

SQL> @?/rdbms/admin/utlrp.sql
...
SQL> alter session set container=ORCLPDB;

Session altered.

SQL> @?/rdbms/admin/utlrp.sql
...

Done!

4 thoughts on “How to Patch Oracle Database 19c on Linux (DBRU 19.9)”

Leave a Reply

Your email address will not be published. Required fields are marked *