> 下载相关补丁并上传至服务器 #### 1、环境检查 ``` --检查环境是否正常 $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh /u02/app/oracle/product/19.0.0/db_1 --根据补丁包，检查是否有冲突 --grid $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/grid/soft/30501910/30557433 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/grid/soft/30501910/30489227 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/grid/soft/30501910/30489632 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/grid/soft/30501910/ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/grid/soft/30501910/30655595 --oracle $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/grid/soft/30501910/30557433 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/grid/soft/30501910/30489227 ``` > 系统空间检查 ``` --系统空间检查 cat /tmp/patch_list_gihome.txt /u01/app/grid/soft/30501910/30557433 /u01/app/grid/soft/30501910/30489227 /u01/app/grid/soft/30501910/30489632 /u01/app/grid/soft/30501910/ /u01/app/grid/soft/30501910/30655595 $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt cat /tmp/patch_list_dbhome.txt /u01/app/grid/soft/30501910/30557433 /u01/app/grid/soft/30501910/30489227 $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt ``` > 安装前分析 ``` --每个节点执行 /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/app/grid/soft/30501910 -analyze ``` #### 2.安装 ``` --安装 每个节点执行，如数据库未开启，需手动应用sql /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/app/grid/soft/30501910 -nonrolling --or --指定gi home，仅升级gi /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/app/grid/soft/30501910 -oh /u01/app/19.0.0/grid -nonrolling --指定oracle home /u02/app/oracle/product/19.0.0/db_1/OPatch/opatchauto apply /u01/app/grid/soft/30501910 -oh /u02/app/oracle/product/19.0.0/db_1 -nonrolling --应用sql sqlplus / as sysdba startup alter pluggable database all open; cd $ORACLE_HOME/OPatch ./datapatch -verbose cd $ORACLE_HOME/rdbms/admin sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> @utlrp.sql ``` ###3.回滚 ``` --停机状态回滚,gi home ,oracle home /u01/app/19.0.0/grid/OPatch/opatchauto rollback /u01/app/grid/soft/30501910 -nonrolling -oh /u01/app/19.0.0/grid /u02/app/oracle/product/19.0.0/db_1/OPatch/opatchauto rollback /u01/app/grid/soft/30501910 -nonrolling -oh /u02/app/oracle/product/19.0.0/db_1 ``` ### 4.升级日志 ``` [root@rac19c bin]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/app/grid/soft/30501910 -nonrolling OPatchauto session is initiated at Tue Mar 10 14:03:30 2020 System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2020-03-10_02-03-37PM.log. Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2020-03-10_02-03-49PM.log The id for this session is M46H Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid Executing OPatch prereq operations to verify patch applicability on home /u02/app/oracle/product/19.0.0/db_1 Patch applicability verified successfully on home /u02/app/oracle/product/19.0.0/db_1 Patch applicability verified successfully on home /u01/app/19.0.0/grid Verifying SQL patch applicability on home /u02/app/oracle/product/19.0.0/db_1 SQL patch applicability verified successfully on home /u02/app/oracle/product/19.0.0/db_1 Preparing to bring down database service on home /u02/app/oracle/product/19.0.0/db_1 Successfully prepared home /u02/app/oracle/product/19.0.0/db_1 to bring down database service Bringing down database service on home /u02/app/oracle/product/19.0.0/db_1 Database service successfully brought down on home /u02/app/oracle/product/19.0.0/db_1 Bringing down CRS service on home /u01/app/19.0.0/grid CRS service brought down successfully on home /u01/app/19.0.0/grid Performing prepatch operation on home /u02/app/oracle/product/19.0.0/db_1 Perpatch operation completed successfully on home /u02/app/oracle/product/19.0.0/db_1 Start applying binary patch on home /u02/app/oracle/product/19.0.0/db_1 Binary patch applied successfully on home /u02/app/oracle/product/19.0.0/db_1 Performing postpatch operation on home /u02/app/oracle/product/19.0.0/db_1 Postpatch operation completed successfully on home /u02/app/oracle/product/19.0.0/db_1 Start applying binary patch on home /u01/app/19.0.0/grid Binary patch applied successfully on home /u01/app/19.0.0/grid Starting CRS service on home /u01/app/19.0.0/grid CRS service started successfully on home /u01/app/19.0.0/grid Starting database service on home /u02/app/oracle/product/19.0.0/db_1 Database service successfully started on home /u02/app/oracle/product/19.0.0/db_1 Preparing home /u02/app/oracle/product/19.0.0/db_1 after database service restarted No step execution required......... Trying to apply SQL patch on home /u02/app/oracle/product/19.0.0/db_1 SQL patch applied successfully on home /u02/app/oracle/product/19.0.0/db_1 OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:rac19c RAC Home:/u02/app/oracle/product/19.0.0/db_1 Version:19.0.0.0.0 Summary: ==Following patches were SKIPPED: Patch: /u01/app/grid/soft/30501910/30489632 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /u01/app/grid/soft/30501910/30655595 Reason: This patch is not applicable to this specified target type - "rac_database" ==Following patches were SUCCESSFULLY applied: Patch: /u01/app/grid/soft/30501910/30489227 Log: /u02/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_14-06-03PM_1.log Patch: /u01/app/grid/soft/30501910/30557433 Log: /u02/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_14-06-03PM_1.log Host:rac19c CRS Home:/u01/app/19.0.0/grid Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /u01/app/grid/soft/30501910/30489227 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_14-11-42PM_1.log Patch: /u01/app/grid/soft/30501910/30489632 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_14-11-42PM_1.log Patch: /u01/app/grid/soft/30501910/30557433 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_14-11-42PM_1.log Patch: /u01/app/grid/soft/30501910/30655595 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_14-11-42PM_1.log Patching session reported following warning(s): _________________________________________________ [WARNING] The database instance 'testdb1' from '/u02/app/oracle/product/19.0.0/db_1', in host'rac19c' is not running. SQL changes, if any, will not be applied. To apply. the SQL changes, bring up the database instance and run the command manually from any one node (run as oracle). Refer to the readme to get the correct steps for applying the sql changes. OPatchauto session completed at Tue Mar 10 14:23:18 2020 Time taken to complete the session 19 minutes, 49 seconds [oracle@rac19c OPatch]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Tue Mar 10 14:25:21 2020 Version 19.6.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 2466250400 bytes Fixed Size 9137824 bytes Variable Size 754974720 bytes Database Buffers 1694498816 bytes Redo Buffers 7639040 bytes Database mounted. Database opened. SQL> alter pluggable database all open; Pluggable database altered. SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.6.0.0.0 cd $ORACLE_HOME/OPatch [oracle@rac19c OPatch]$ cd $ORACLE_HOME/OPatch [oracle@rac19c OPatch]$ ./datapatch -verbose SQL Patching tool version 19.6.0.0.0 Production on Tue Mar 10 14:27:37 2020 Copyright (c) 2012, 2019, Oracle. All rights reserved. Log file for this invocation: /u02/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_49511_2020_03_10_14_27_37/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.6.0.0.0 Release_Update 191217155004: Installed PDB CDB$ROOT: Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 07-JAN-20 01.14.24.263477 PM PDB MYPDB: Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 07-JAN-20 01.30.58.580298 PM PDB PDB$SEED: Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 07-JAN-20 01.30.58.580298 PM Adding patches to installation queue and performing prereq checks...done Installation queue: For the following PDBs: CDB$ROOT PDB$SEED MYPDB No interim patches need to be rolled back Patch 30557433 (Database Release Update : 19.6.0.0.200114 (30557433)): Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.6.0.0.0 Release_Update 191217155004 No interim patches need to be applied Installing patches... Patch installation complete. Total patches installed: 3 Validating logfiles...done Patch 30557433 apply (pdb CDB$ROOT): SUCCESS logfile: /u02/app/oracle/cfgtoollogs/sqlpatch/30557433/23305305/30557433_apply_TESTDB_CDBROOT_2020Mar10_14_28_58.log (no errors) Patch 30557433 apply (pdb PDB$SEED): SUCCESS logfile: /u02/app/oracle/cfgtoollogs/sqlpatch/30557433/23305305/30557433_apply_TESTDB_PDBSEED_2020Mar10_14_35_01.log (no errors) Patch 30557433 apply (pdb MYPDB): SUCCESS logfile: /u02/app/oracle/cfgtoollogs/sqlpatch/30557433/23305305/30557433_apply_TESTDB_MYPDB_2020Mar10_14_35_01.log (no errors) SQL Patching tool complete on Tue Mar 10 14:41:42 2020 [oracle@rac19c OPatch]$ ./opatch lsinventory Oracle Interim Patch Installer version 12.2.0.1.19 Copyright (c) 2020, Oracle Corporation. All rights reserved. Oracle Home : /u02/app/oracle/product/19.0.0/db_1 Central Inventory : /u01/app/oraInventory from : /u02/app/oracle/product/19.0.0/db_1/oraInst.loc OPatch version : 12.2.0.1.19 OUI version : 12.2.0.7.0 Log file location : /u02/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2020-03-10_14-25-09PM_1.log Lsinventory Output file location : /u02/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2020-03-10_14-25-09PM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: rac19c 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 30557433 : applied on Tue Mar 10 14:08:14 CST 2020 Unique Patch ID: 23305305 Patch description: "Database Release Update : 19.6.0.0.200114 (30557433)" Created on 6 Jan 2020, 19:07:34 hrs PST8PDT Bugs fixed: 30545281, 8476681, 14735102, 17428816, 19080742, 19697993, 20313356 21374587, 21965541, 23296836, 23606241, 24687075, 25756945, 25806201 25883179, 25986062, 25997810, 26476244, 26611353, 26739322, 26777814 26872233, 27036163, 27044169, 27101798, 27126938, 27195935, 27244999 27254335, 27359766, 27369515, 27406105, 27411022, 27423500, 27439716 27453490, 27458357, 27489107, 27666312, 27710072, 27729678, 27846298 27880025, 27934711, 27935464, 27941110, 27957203, 27967484, 28064977 28072567, 28109326, 28125947, 28129791, 28181021, 28189466, 28204262 28205555, 28209985, 28210681, 28271258, 28271693, 28279456, 28294563 28313275, 28319114, 28326928, 28350595, 28371123, 28373960, 28375383 28379065, 28381939, 28386259, 28390273, 28395302, 28397317, 28402823 28410431, 28431445, 28435333, 28454215, 28463226, 28475242, 28484299 28489419, 28492006, 28498976, 28502773, 28513333, 28521330, 28530171 28534475, 28538439, 28542455, 28546290, 28547068, 28547926, 28558645 28561704, 28567417, 28567819, 28569897, 28572407, 28572533, 28572544 28572667, 28572834, 28578945, 28587723, 28589509, 28593682, 28594086 28597221, 28601957, 28605066, 28606598, 28612239, 28620697, 28625862 28627033, 28636532, 28639299, 28643718, 28644549, 28645570, 28646200 28646939, 28649388, 28655209, 28663782, 28672457, 28673945, 28692103 28692275, 28694872, 28696373, 28705231, 28710385, 28710734, 28714461 28715727, 28718469, 28719348, 28720204, 28720418, 28721497, 28722229 28730079, 28734355, 28740708, 28742555, 28749853, 28752923, 28755011 28758722, 28760206, 28765983, 28767240, 28769456, 28772390, 28774416 28776811, 28777214, 28781754, 28785531, 28789531, 28791852, 28795551 28795734, 28802734, 28804517, 28810381, 28811560, 28815123, 28815355 28817449, 28819640, 28820669, 28821847, 28824482, 28827682, 28831971 28833912, 28835937, 28836716, 28844738, 28849776, 28854004, 28855520 28855922, 28857552, 28862532, 28863432, 28863487, 28867992, 28873575 28875089, 28876253, 28876639, 28878865, 28882784, 28884931, 28887305 28888327, 28889730, 28892794, 28897512, 28899663, 28901126, 28905457 28905615, 28907196, 28912691, 28915561, 28917080, 28918429, 28919145 28922227, 28922532, 28922608, 28925634, 28925880, 28927452, 28932914 28933158, 28935293, 28936114, 28937717, 28938698, 28940179, 28940281 28941901, 28942455, 28945421, 28945994, 28949888, 28950868, 28951533 28952168, 28954762, 28955606, 28955883, 28956908, 28957292, 28957723 28958088, 28959493, 28960863, 28962775, 28965084, 28965095, 28965231 28965376, 28966444, 28974083, 28977322, 28983095, 28983486, 28985478 28986207, 28986231, 28986257, 28986326, 28986481, 28988482, 28989306 28993295, 28993353, 28994307, 28996376, 29000000, 29001305, 29001888 29002488, 29002784, 29002927, 29003407, 29003738, 29006318, 29006621 29007321, 29007353, 29007775, 29008035, 29008669, 29009513, 29010126 29011936, 29012609, 29013475, 29013832, 29014076, 29015118, 29017265 29018655, 29019121, 29021063, 29021352, 29022986, 29024054, 29024552 29024732, 29026582, 29026606, 29027456, 29027694, 29027940, 29031575 29031600, 29032234, 29032276, 29032457, 29032607, 29033052, 29033145 29033200, 29033280, 29034587, 29037290, 29038528, 29038728, 29039089 29039510, 29040739, 29043554, 29043651, 29043725, 29044763, 29044954 29046482, 29047850, 29048178, 29048289, 29048498, 29048605, 29050357 29050560, 29050765, 29050886, 29051702, 29051953, 29052726, 29053783 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, 29123297, 29123432, 29123482, 29124368, 29125036 29125374, 29125380, 29126345, 29127957, 29128693, 29128935, 29129450 29129497, 29129712, 29130219, 29131539, 29132869, 29132938, 29133470 29134447, 29135383, 29135649, 29136111, 29138641, 29139956, 29141316 29141341, 29141685, 29142609, 29142667, 29143516, 29144995, 29145214 29145730, 29149829, 29150338, 29151520, 29152357, 29155099, 29157051 29157389, 29158680, 29158899, 29159909, 29159936, 29160174, 29162095 29163156, 29163415, 29163437, 29163524, 29163567, 29167111, 29167342 29167374, 29167940, 29168137, 29168219, 29168433, 29169073, 29169215 29170232, 29171683, 29171942, 29172618, 29172826, 29173140, 29173373 29173817, 29174004, 29176318, 29177466, 29177543, 29177886, 29178385 29180313, 29180455, 29180559, 29180893, 29181153, 29181231, 29181620 29181743, 29181923, 29182019, 29182517, 29182901, 29183912, 29184297 29184666, 29185193, 29186456, 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, 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, 29233415, 29233810, 29233953 29234123, 29236573, 29237538, 29237575, 29237744, 29240307, 29240759 29241345, 29241651, 29242017, 29242884, 29243958, 29245137, 29245160 29246163, 29247415, 29247712, 29247906, 29248495, 29248552, 29248835 29248858, 29249412, 29249991, 29250059, 29250317, 29251259, 29253184 29253871, 29254031, 29254930, 29255178, 29255273, 29255431, 29255435 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, 29292837 29293072, 29293574, 29297863, 29297915, 29298220, 29299049, 29299082 29299844, 29301463, 29301566, 29302963, 29303918, 29304781, 29306226 29306713, 29307638, 29311528, 29311588, 29312310, 29312672, 29312734 29312753, 29312889, 29313347, 29313417, 29313525, 29314539, 29314636 29317756, 29318410, 29319441, 29321489, 29323946, 29324568, 29324735 29325087, 29325105, 29325257, 29325765, 29325993, 29327044, 29329042 29329087, 29329807, 29330361, 29331066, 29331209, 29331380, 29331493 29332292, 29332395, 29332763, 29332771, 29333500, 29336843, 29337310 29337742, 29338315, 29338348, 29338453, 29338780, 29338913, 29339101 29339155, 29341209, 29343086, 29343861, 29345937, 29346057, 29346211 29346943, 29347620, 29348176, 29350052, 29350762, 29351386, 29351662 29351716, 29351735, 29351749, 29352298, 29352724, 29352867, 29352947 29353271, 29353432, 29353821, 29353960, 29355654, 29356547, 29356704 29356711, 29356752, 29358509, 29358828, 29360252, 29360285, 29360672 29360911, 29360950, 29361319, 29361472, 29361801, 29363151, 29364171 29364177, 29366940, 29367019, 29367561, 29368253, 29368310, 29372541 29373418, 29373588, 29374179, 29375355, 29375941, 29375984, 29376346 29377804, 29377986, 29378029, 29378834, 29378913, 29379978, 29382641 29382784, 29382815, 29383695, 29384781, 29384854, 29384864, 29385429 29385652, 29386502, 29386635, 29386660, 29387073, 29387274, 29388020 29388072, 29388094, 29388524, 29388830, 29389889, 29390011, 29390435 29390785, 29391030, 29391237, 29391849, 29391925, 29392966, 29393291 29394014, 29394140, 29394749, 29395657, 29397954, 29397996, 29398488 29398863, 29399046, 29399100, 29399121, 29399336, 29399938, 29402131 29404483, 29405012, 29405462, 29405651, 29405996, 29407804, 29408853 29409149, 29409455, 29410311, 29410834, 29411037, 29411469, 29412066 29412269, 29416688, 29417173, 29417719, 29417884, 29418165, 29420834 29421059, 29423003, 29423016, 29423156, 29423826, 29424999, 29426241 29429017, 29429264, 29429466, 29429566, 29430524, 29430866, 29431192 29431485, 29432176, 29434301, 29435474, 29435652, 29436454, 29436514 29436727, 29437594, 29437712, 29438277, 29438736, 29439522, 29441196 29443187, 29443250, 29444072, 29444282, 29444602, 29446669, 29448498 29449477, 29449845, 29449852, 29450193, 29450421, 29450812, 29450936 29451386, 29452251, 29452576, 29452936, 29452953, 29454978, 29455424 29456714, 29457312, 29457370, 29457502, 29457807, 29457978, 29460252 29461420, 29461791, 29462594, 29462767, 29462957, 29463047, 29463528 29464616, 29464779, 29465177, 29467622, 29469565, 29470291, 29471860 29472618, 29476473, 29481584, 29483452, 29483532, 29483626, 29483672 29483685, 29483712, 29483723, 29483771, 29485099, 29486181, 29488894 29489436, 29489546, 29490256, 29492127, 29492939, 29493122, 29494245 29495057, 29495684, 29497311, 29497588, 29497696, 29498198, 29500257 29500826, 29502561, 29503543, 29503631, 29503827, 29504492, 29504682 29505668, 29507270, 29507616, 29508681, 29509777, 29510278, 29511611 29514479, 29515134, 29515240, 29515476, 29515766, 29515834, 29516300 29516727, 29516766, 29517168, 29517883, 29521187, 29521688, 29521748 29521862, 29522358, 29522561, 29522662, 29523055, 29523511, 29524599 29525467, 29525886, 29526966, 29527595, 29527610, 29528368, 29529147 29530440, 29530515, 29530812, 29530909, 29531654, 29531836, 29532532 29536342, 29536445, 29538631, 29541742, 29541769, 29542084, 29542449 29542643, 29543034, 29543956, 29546817, 29547010, 29547867, 29548427 29548687, 29548722, 29549071, 29549104, 29549154, 29549730, 29552773 29553141, 29557144, 29557261, 29557336, 29557556, 29558238, 29558975 29559187, 29559446, 29559908, 29559981, 29564592, 29564593, 29565611 29580394, 29580983, 29581771, 29584261, 29584693, 29586143, 29587765 29597536, 29597754, 29598039, 29598046, 29598233, 29599008, 29599300 29601461, 29602831, 29603460, 29603884, 29604002, 29604257, 29607136 29607797, 29608000, 29610506, 29611020, 29611991, 29615824, 29616244 29616414, 29618074, 29618190, 29620042, 29622936, 29625065, 29625804 29625876, 29626154, 29626732, 29628200, 29629430, 29629650, 29629681 29629745, 29631749, 29632095, 29632265, 29632611, 29633697, 29633753 29633936, 29634643, 29635427, 29635717, 29635990, 29637362, 29637526 29638285, 29641736, 29643721, 29645349, 29648928, 29651183, 29651520 29653132, 29653246, 29655668, 29656819, 29657422, 29657960, 29661028 29661065, 29661722, 29663368, 29664087, 29664161, 29665940, 29667994 29668005, 29669413, 29670782, 29671363, 29672507, 29676089, 29677051 29677173, 29677733, 29677927, 29679856, 29681987, 29683039, 29687214 29687459, 29687718, 29687763, 29689145, 29689255, 29692694, 29694869 29695425, 29695841, 29696310, 29700125, 29700460, 29700770, 29703932 29707099, 29707896, 29708915, 29710188, 29710858, 29713810, 29715220 29716194, 29716491, 29717659, 29719146, 29720133, 29721418, 29725476 29725781, 29726695, 29739576, 29741976, 29742223, 29746962, 29747493 29747648, 29747653, 29748285, 29748336, 29748513, 29749471, 29750673 29751094, 29753244, 29754951, 29755821, 29756274, 29756444, 29757099 29757264, 29757651, 29758217, 29758661, 29761678, 29761837, 29761911 29765393, 29766207, 29766503, 29766679, 29768899, 29770750, 29771032 29771242, 29773197, 29773842, 29775393, 29779196, 29782211, 29782823 29782866, 29784106, 29785239, 29787292, 29787766, 29791152, 29791880 29793318, 29794462, 29795712, 29795957, 29796378, 29797726, 29802695 29804875, 29805772, 29809837, 29812489, 29813503, 29815713, 29817278 29821582, 29825525, 29827852, 29831196, 29834506, 29836096, 29838485 29838773, 29839715, 29840619, 29841267, 29841687, 29843277, 29843692 29844226, 29845530, 29846126, 29846645, 29848084, 29848849, 29849100 29850930, 29851733, 29853485, 29858121, 29858376, 29865188, 29865658 29869086, 29869404, 29869887, 29870065, 29871098, 29873665, 29875459 29875565, 29877608, 29878076, 29881478, 29881839, 29882729, 29884958 29887111, 29888621, 29890740, 29891916, 29893132, 29897418, 29897863 29900203, 29902327, 29902330, 29903299, 29903454, 29906678, 29907942 29909658, 29912286, 29914449, 29915217, 29915848, 29916975, 29920025 29921318, 29926466, 29927756, 29928210, 29937565, 29938225, 29940373 29942096, 29942554, 29943670, 29944035, 29944660, 29945645, 29946388 29951620, 29956016, 29957493, 29961609, 29962248, 29962927, 29962939 29966768, 29967223, 29968085, 29970298, 29971027, 29971888, 29989783 29989845, 29991257, 29997326, 30003187, 30006159, 30006985, 30007797 30008125, 30008214, 30009710, 30015070, 30019864, 30024618, 30029806 30032376, 30033547, 30034456, 30035598, 30038392, 30040157, 30042490 30043610, 30044507, 30047702, 30047765, 30051176, 30051783, 30053036 30058149, 30058453, 30059106, 30059109, 30066352, 30074349, 30074472 30075037, 30076197, 30078675, 30079949, 30080266, 30081580, 30083488 30084971, 30085897, 30086992, 30090568, 30092859, 30095591, 30095952 30097092, 30098251, 30099454, 30101186, 30104555, 30106748, 30110224 30110370, 30110518, 30114489, 30114534, 30127522, 30127904, 30131645 30135396, 30142907, 30149658, 30150606, 30154633, 30155837, 30159329 30164714, 30165493, 30165503, 30170104, 30174401, 30175291, 30177597 30178250, 30187866, 30189516, 30191274, 30193165, 30206493, 30218044 30223712, 30223847, 30224950, 30235919, 30246179, 30247305, 30252098 30252156, 30253608, 30255143, 30264405, 30266791, 30269428, 30274188 30282591, 30299817, 30312094, 30318638, 30324180, 30342878, 30365745 30389229, 30402386, 30408515, 30412188, 30453442, 30458593, 30474167 30474774, 30485255, 30534827, 30641755 Patch 30489227 : applied on Tue Mar 10 14:06:26 CST 2020 Unique Patch ID: 23305624 Patch description: "OCW RELEASE UPDATE 19.6.0.0.0 (30489227)" Created on 7 Jan 2020, 03:37:45 hrs PST8PDT Bugs fixed: 17787434, 25736599, 26675491, 27148384, 27222128, 27262781, 27572040 27604329, 27760043, 27877830, 28302580, 28319989, 28406406, 28441307 28470673, 28554809, 28621543, 28628631, 28642469, 28697242, 28697896 28699321, 28704073, 28710663, 28747089, 28755846, 28762163, 28772816 28785321, 28800508, 28805158, 28808652, 28815557, 28847541, 28847572 28847655, 28852065, 28865162, 28870111, 28870496, 28871040, 28874416 28874529, 28874678, 28877252, 28881191, 28881848, 28887933, 28888083 28892095, 28911140, 28912188, 28917537, 28925250, 28925460, 28935956 28940472, 28942694, 28951332, 28958624, 28963036, 28968779, 28973989 28980448, 28984430, 28987100, 28995287, 29003207, 29003617, 29016294 29018680, 29024876, 29026154, 29027933, 29030056, 29047127, 29051269 29052850, 29053083, 29058476, 29111631, 29112455, 29117337, 29118754 29123444, 29125708, 29125786, 29129476, 29130169, 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, 29202442, 29209545, 29209972, 29210577 29210610, 29210624, 29210683, 29213641, 29218185, 29219627, 29224294 29225861, 29229839, 29231008, 29235934, 29242906, 29243749, 29244495 29244766, 29244968, 29248723, 29249583, 29251564, 29254863, 29255616 29257308, 29260224, 29261171, 29261695, 29266584, 29268887, 29271019 29273360, 29274911, 29275362, 29276220, 29280752, 29282090, 29282666 29285453, 29285621, 29288842, 29289634, 29290235, 29292232, 29293806 29293928, 29294753, 29299830, 29307090, 29307109, 29311336, 29318127 29329675, 29330791, 29338139, 29339299, 29342966, 29347106, 29351297 29351881, 29357821, 29359713, 29360467, 29360775, 29367971, 29368725 29376616, 29377086, 29379299, 29379381, 29380201, 29380253, 29380496 29380527, 29381000, 29382296, 29385861, 29387212, 29390900, 29391301 29392779, 29393649, 29395961, 29397888, 29398418, 29402110, 29407192 29411931, 29413360, 29413448, 29416851, 29433434, 29438073, 29445982 29450417, 29452365, 29457241, 29457319, 29460775, 29462569, 29465047 29468589, 29470298, 29471399, 29473188, 29478378, 29485756, 29490266 29495628, 29498957, 29499868, 29502953, 29504266, 29505022, 29505730 29507560, 29510452, 29518947, 29524627, 29528119, 29529127, 29529530 29529973, 29535802, 29537427, 29540165, 29542152, 29545235, 29549429 29552763, 29555663, 29583036, 29585881, 29592188, 29593025, 29599431 29599530, 29600906, 29601549, 29605539, 29618725, 29623009, 29632615 29637215, 29641885, 29645874, 29655862, 29657866, 29659031, 29663838 29671651, 29671851, 29671933, 29672162, 29672852, 29684210, 29684609 29684672, 29686671, 29690422, 29692674, 29694497, 29721974, 29722328 29741589, 29754146, 29760252, 29760705, 29769321, 29770006, 29770719 29772541, 29780086, 29786752, 29797504, 29797626, 29798124, 29799836 29805654, 29814993, 29817598, 29825944, 29828755, 29838281, 29839229 29841704, 29851066, 29852422, 29853256, 29862652, 29862828, 29866585 29867220, 29868392, 29876493, 29885967, 29893587, 29896074, 29909288 29910893, 29921525, 29936936, 29939536, 29958570, 29972301, 29997804 30006937, 30007337, 30009279, 30009884, 30012348, 30022613, 30028540 30028697, 30032515, 30033476, 30039843, 30043518, 30047157, 30076461 30080241, 30085531, 30123264, 30140462, 30142644, 30155486, 30159782 30165554, 30191807, 30203000, 30210185, 30216942, 30226726, 30252076 30300812, 30303080, 30422030, 30461079, 30461097, 30472602, 30482794 30499905, 30559848, 3 -------------------------------------------------------------------------------- OPatch succeeded. [oracle@rac19c admin]$ sql SQL*Plus: Release 19.0.0.0.0 - Production on Tue Mar 10 14:54:27 2020 Version 19.6.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.6.0.0.0 SQL> select PATCH_ID,PATCH_TYPE,ACTION,STATUS,TARGET_VERSION from dba_registry_sqlpatch; PATCH_ID PATCH_TYPE ACTION STATUS TARGET_VERSION ---------- ---------- --------------- ------------------------- --------------- 29517242 RU APPLY SUCCESS 19.3.0.0.0 30557433 RU APPLY SUCCESS 19.6.0.0.0 SQL> SQL> select banner from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production SQL> ```