如何升级OracleDatabase为OracleDatabase19.3?

1. 背景介绍
由于Oracle Database 19c会作为Oracle长期支持的版本,官方也建议大家选择19c这个版本。而最新推出的20c会作为一个全新的发布序列,当前版本是20.1,此版本的生命周期也会比较短,因此可以再观望一下20c的后续版本。我安装了在Oracle官网可以下载到的19.3的版本,完成了升级到19.6版本的操作过程,给此项目工作提供文档支持。

创新互联公司坚信:善待客户,将会成为终身客户。我们能坚持多年,是因为我们一直可值得信赖。我们从不忽悠初访客户,我们用心做好本职工作,不忘初心,方得始终。10余年网站建设经验创新互联公司是成都老牌网站营销服务商,为您提供成都网站设计、成都网站制作、外贸网站建设、网站设计、H5建站、网站制作、品牌网站建设成都小程序开发服务,给众多知名企业提供过好品质的建站服务。

2. 升级过程
可以从MOS获得 Database 19.6 的 patch,名称如下:

Patch 30463595: COMBO OF OJVM RU COMPONENT 19.6.0.0.200114 DB RU 19.6.0.0.200114

安装Patch的时候,建议大家先阅读Patch中的README文档,文档中详细介绍了该patch的安装方法和其他使用方法等内容;由于Patch 30463595是两个补丁的合并,因此要分别安装其中的 30463595 和 30557433。

先检查当前Oracle数据库的补丁安装情况,使用opatch lsinv命令可以看到现在补丁是19.3的版本。

[oracle@sdedu 30463595]$ /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch lsinv
Oracle Interim Patch Installer version 12.2.0.1.17
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.17
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch3020-03-03_11-01-49AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2020-03-03_11-01-49AM.txt

---------------------------------------------------------------------------
Local Machine Information::
Hostname: sdedu.sandata.com.cn
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 15:21:33 CST 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 15:21:17 CST 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.

然后进入补丁目录30484981;

[oracle@sdedu 30463595]$ cd 30484981/
[oracle@sdedu 30484981]$ ls
etc files README.html README.txt

查看要安装的补丁和现有补丁是否存在冲突;

[oracle@sdedu 30484981]$ /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.17
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.17
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch3020-03-03_11-00-59AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

使用opatch apply命令开始应用 30484981补丁

[oracle@sdedu 30484981]$ /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.17
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.17
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch3020-03-03_11-14-00AM_1.log

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

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 '30484981' to OH '/u01/app/oracle/product/19.3.0/dbhome_1'

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

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

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

Patching component oracle.rdbms, 19.0.0.0.0...
Patch 30484981 successfully applied.
Log file location: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch3020-03-03_11-14-00AM_1.log

OPatch succeeded.

安装完成后,再次检查补丁的列表,可以看到JVM 19.6的补丁已经安装好:

[oracle@sdedu 30484981]$ /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch lsinv
Oracle Interim Patch Installer version 12.2.0.1.17
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.17
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch3020-03-03_11-48-05AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2020-03-03_11-48-05AM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: sdedu.sandata.com.cn
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 (3) :

Patch 30484981 : applied on Tue Mar 03 11:14:31 CST 2020
Unique Patch ID: 23248235
Patch description: "OJVM RELEASE UPDATE: 19.6.0.0.200114 (30484981)"
Created on 5 Dec 2019, 05:10:10 hrs PST8PDT
Bugs fixed:
29540327, 29254623, 29445548, 29774362, 30134746, 30160625, 29942275
30534662, 29512125
Patch 29585399 : applied on Thu Apr 18 15:21:33 CST 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 15:21:17 CST 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.

接下来,关闭数据库后使用datapatch工具在数据库中应用SQL文件;

[oracle@sdedu ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Mar 3 13:59:56 2020
Version 19.3.0.0.0

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

Connected to an idle instance.

SQL> startup upgrade
ORACLE instance started.

Total System Global Area 1543500832 bytes
Fixed Size 9135136 bytes
Variable Size 973078528 bytes
Database Buffers 553648128 bytes
Redo Buffers 7639040 bytes
Database mounted.
Database opened.
SQL> alter pluggable database all open upgrade;

Pluggable database altered.

SQL> quit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@sdedu ~]$ cd $ORACLE_HOME/OPatch
[oracle@sdedu OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.3.0.0.0 Production on Tue Mar 3 14:02:02 2020
Copyright (c) 2012, 2019, Oracle. All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_23535_2020_03_03_14_02_02/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 30484981 (OJVM RELEASE UPDATE: 19.6.0.0.200114 (30484981)):
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.3.0.0.0 Release_Update 190410122720: Installed
PDB CDB$ROOT:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 13-MAY-19 11.43.02.621425 PM
PDB PDB$SEED:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 13-MAY-19 11.43.08.787211 PM
PDB PDB1:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 13-MAY-19 11.43.08.787211 PM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED PDB1
No interim patches need to be rolled back
No release update patches need to be installed
The following interim patches will be applied:
30484981 (OJVM RELEASE UPDATE: 19.6.0.0.200114 (30484981))

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

Validating logfiles...done
Patch 30484981 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30484981/23248235/30484981_apply_SS19C_CDBROOT_2020Mar03_14_02_48.log (no errors)
Patch 30484981 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30484981/23248235/30484981_apply_SS19C_PDBSEED_2020Mar03_14_04_27.log (no errors)
Patch 30484981 apply (pdb PDB1): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30484981/23248235/30484981_apply_SS19C_PDB1_2020Mar03_14_04_27.log (no errors)
SQL Patching tool complete on Tue Mar 3 14:05:01 2020

最后,使用utlrp脚本来重新编译失败的对象;

[oracle@sdedu 30484981]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Mar 3 11:43:20 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> select PATCH_ID,PATCH_TYPE,ACTION,STATUS,SOURCE_VERSION from dba_registry_sqlpatch;
PATCH_ID PATCH_TYPE ACTION STATUS SOURCE_VERSION
---------- ---------- ------------ ------------------- ---------------
29517242 RU APPLY SUCCESS 19.1.0.0.0
30484981 INTERIM APPLY SUCCESS 19.3.0.0.0
SQL> @?/rdbms/admin/utlrp
Session altered.
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN 2020-03-03 11:44:52
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 2020-03-03 11:44:55
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.

至此,30484981补丁已经安装完毕。

下一步,就要来安装30557433补丁,整个过程和之前的安装过程类似,首先检查补丁是否存在冲突;

[oracle@sdedu 30463595]$ cd 30557433/
[oracle@sdedu 30557433]$ ls
custom etc files README.html README.txt
[oracle@sdedu 30557433]$ /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.17
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.17
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch3020-03-03_14-43-18PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

接下来开始应用补丁;

[oracle@sdedu 30557433]$ /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.17
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.17
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch3020-03-03_14-44-12PM_1.log

Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:

Following active executables are not used by opatch process :
/u01/app/oracle/product/19.3.0/dbhome_1/bin/oracle

Following active executables are used by opatch process :

/u01/app/oracle/product/19.3.0/dbhome_1/lib/libclntsh.so.19.1
/u01/app/oracle/product/19.3.0/dbhome_1/lib/libsqlplus.so
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch3020-03-03_14-44-12PM_1.log

OPatch failed with error code 73
[oracle@sdedu 30557433]$ /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.17
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.17
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch3020-03-03_14-46-05PM_1.log

Verifying environment and performing prerequisite checks...

--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...

Oracle Interim Patch Installer version 12.2.0.1.17
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.17
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch3020-03-03_14-46-35PM_1.log

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

Do you want to proceed? [y|n]
Y (auto-answered by -silent)
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 (auto-answered by -silent)
User Responded with: Y
Backing up files...
Applying interim patch '30557433' 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.xdk.parser.java.jaxb2, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.assistants.usm, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.options.olap.awm, 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.util, 19.0.0.0.0...

Patching component oracle.rdbms, 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.ldap.rsf, 19.0.0.0.0...

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

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

Patching component oracle.sdo, 19.0.0.0.0...

Patching component oracle.sqlplus, 19.0.0.0.0...

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

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

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

Patching component oracle.odbc, 19.0.0.0.0...

Patching component oracle.ovm, 19.0.0.0.0...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Patching component oracle.duma, 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.dbjava.jdbc, 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.ldap.rsf.ic, 19.0.0.0.0...

Patching component oracle.dbdev, 19.0.0.0.0...

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

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

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

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

Patching component oracle.jdk, 1.8.0.201.0...
Patch 30557433 successfully applied.
Sub-set patch [29517242] has become inactive due to the application of a super-set patch [30557433].
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/opatch3020-03-03_14-46-35PM_1.log

OPatch succeeded.

补丁应用完成后,使用datapatch工具在数据库中应用SQL文件

[oracle@sdedu 30463595]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Mar 3 11:50:51 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 1543500832 bytes
Fixed Size 9135136 bytes
Variable Size 973078528 bytes
Database Buffers 553648128 bytes
Redo Buffers 7639040 bytes
Database mounted.
Database opened.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED MIGRATE YES
3 PDB1 MOUNTED
SQL> alter pluggable database all open upgrade;
Pluggable database altered.
SQL> quit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

[oracle@sdedu 30463595]$ cd $ORACLE_HOME/OPatch
[oracle@sdedu OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.3.0.0.0 Production on Tue Mar 3 11:54:09 2020
Copyright (c) 2012, 2019, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_29704_2020_03_03_11_54_09/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 30484981 (OJVM RELEASE UPDATE: 19.6.0.0.200114 (30484981)):
Binary registry: Installed
PDB CDB$ROOT: Applied successfully on 03-MAR-20 11.22.13.371425 AM
PDB PDB$SEED: Applied successfully on 03-MAR-20 11.22.13.498532 AM
PDB PDB1: Not installed
Current state of release update SQL patches:
Binary registry:
19.3.0.0.0 Release_Update 190410122720: Installed
PDB CDB$ROOT:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 13-MAY-19 11.43.02.621425 PM
PDB PDB$SEED:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 13-MAY-19 11.43.08.787211 PM
PDB PDB1:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 13-MAY-19 11.43.08.787211 PM
Adding patches to installation queue and performing prereq checks...done
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED
No interim patches need to be rolled back
No release update patches need to be installed
No interim patches need to be applied
For the following PDBs: PDB1
No interim patches need to be rolled back
No release update patches need to be installed
The following interim patches will be applied:
30484981 (OJVM RELEASE UPDATE: 19.6.0.0.200114 (30484981))
Installing patches...
Patch installation complete. Total patches installed: 1
Validating logfiles...done
Patch 30484981 apply (pdb PDB1): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30484981/23248235/30484981_apply_SS19C_PDB1_2020Mar03_11_54_44.log (no errors)
SQL Patching tool complete on Tue Mar 3 11:55:06 2020

继续使用utlrp脚本来编译失败的对象;

[oracle@sdedu OPatch]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Mar 3 11:55:24 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1543500832 bytes
Fixed Size 9135136 bytes
Variable Size 973078528 bytes
Database Buffers 553648128 bytes
Redo Buffers 7639040 bytes
Database mounted.
Database opened.
SQL> alter pluggable database all open;
Pluggable database altered.
SQL> @?/rdbms/admin/utlrp
Session altered.
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN 2020-03-03 11:57:15
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 2020-03-03 11:57:17
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>

我们通过dba_registry_sqlpatch视图来验证补丁的应用状态是否为“SUCCESS”;

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
30484981 INTERIM APPLY SUCCESS 19.3.0.0.0
30557433 RU APPLY SUCCESS 19.6.0.0.0

最后使用opatch lsinv来查看补丁最终状态。

[oracle@sdedu 30557433]$ /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch lsinv
Oracle Interim Patch Installer version 12.2.0.1.17
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.17
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch3020-03-03_16-57-39PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2020-03-03_16-57-39PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: sdedu.sandata.com.cn
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 (3) :

Patch 30557433 : applied on Tue Mar 03 14:48:18 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 30484981 : applied on Tue Mar 03 13:56:38 CST 2020
Unique Patch ID: 23248235
Patch description: "OJVM RELEASE UPDATE: 19.6.0.0.200114 (30484981)"
Created on 5 Dec 2019, 05:10:10 hrs PST8PDT
Bugs fixed:
29540327, 29254623, 29445548, 29774362, 30134746, 30160625, 29942275
30534662, 29512125

Patch 29585399 : applied on Thu Apr 18 15:21:33 CST 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.

3. 总结

通过OPatch工具,我们可以很方便的将Oracle Database 19.3 升级到Oracle Database 19.6。对于公开下载的19.3版本来说,尽快安装patch来解决Bug和安全问题,是非常必要的措施。

4. 注意
如果没有关闭实例就进行补丁的安装,就会报如下错误:

[oracle@sdedu 30557433]$ /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.17
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.17
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch3020-03-03_12-00-34PM_1.log

Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:

Following active executables are not used by opatch process :
/u01/app/oracle/product/19.3.0/dbhome_1/bin/oracle

Following active executables are used by opatch process :

/u01/app/oracle/product/19.3.0/dbhome_1/lib/libclntsh.so.19.1
/u01/app/oracle/product/19.3.0/dbhome_1/lib/libsqlplus.so
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch3020-03-03_12-00-34PM_1.log

OPatch failed with error code 73


分享文章:如何升级OracleDatabase为OracleDatabase19.3?
标题链接:http://pwwzsj.com/article/jhphpd.html