OGG从12.1.2开始,已经变成图形界面安装, 类似于ORACLE软件安装。 针对OGG的补丁安装也与ORACLE软件基本一致。
(1)、更新OPATCH。
OGG软件目录中自带的OPATCH版本太老了,需要更新OPATCH。可从MOS上下载6880880.
(2)、设置ORACLE_HOME变量。
ORACLE_HOME变量已经指向了ORACLE软件的主目录,但现在需要给OGG软件安装补丁,所以需要临时设置ORACLE_HOME为OGG主目录。
export ORACLE_HOME=/u01/app/goldengate/
(3)、当前补丁情况:
[oracle@ggdb01 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.32
Copyright (c) 2022, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/goldengate
Central Inventory : /u01/app/oraInventory
from : /u01/app/goldengate//oraInst.loc
OPatch version : 12.2.0.1.32
OUI version : 12.2.0.4.0
Log file location : /u01/app/goldengate/cfgtoollogs/opatch/opatch2022-09-01_13-34-27PM_1.log
Lsinventory Output file location : /u01/app/goldengate/cfgtoollogs/opatch/lsinv/lsinventory2022-09-01_13-34-27PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: ggdb01.oracle.com
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle GoldenGate Core 19.1.0.0.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
(4)、安装19.1.0.0.220419补丁。
opatch apply
(5)、查看补丁安装情况。
[oracle@ggdb01 34008737]$ /u01/app/goldengate/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.32
Copyright (c) 2022, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/goldengate
Central Inventory : /u01/app/oraInventory
from : /u01/app/goldengate//oraInst.loc
OPatch version : 12.2.0.1.32
OUI version : 12.2.0.4.0
Log file location : /u01/app/goldengate/cfgtoollogs/opatch/opatch2022-09-01_13-35-42PM_1.log
Lsinventory Output file location : /u01/app/goldengate/cfgtoollogs/opatch/lsinv/lsinventory2022-09-01_13-35-42PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: ggdb01.oracle.com
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle GoldenGate Core 19.1.0.0.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 34008737 : applied on Thu Sep 01 13:35:32 CST 2022
Unique Patch ID: 24739710
Created on 11 Apr 2022, 22:50:49 hrs PST8PDT
Bugs fixed:
34010553, 31669209, 31840929, 31928529, 32368584, 32796406, 32876526
32950446, 33089380, 33110174, 33200367, 33201508, 33272560, 33287206
33324312, 33400286, 33444318, 33524433, 33525319, 33540234, 33560573
33629511, 33655208, 33659079, 33659088, 33697211, 33733412, 33744616
33746251, 33779437, 33789068, 33823869, 33847292, 33872891, 33884867
33231336, 33834951, 33807421, 33756665, 33794237, 20513471, 33793099
33634810, 33495042, 32177752, 33621809, 32154847, 33527471, 33588242
33239354, 33152226, 32899188, 33478888, 33403607, 33480347, 32114112
32368065, 31323568, 33282334, 32904384, 32619862, 33033338, 32885359
31866454, 32871540, 30995568, 32978874, 31734485, 33267201, 32857040
32878204, 32431397, 33211298, 33080986, 33182639, 33193847, 31976112
33048061, 32852905, 32113080, 33113885, 33092381, 32464892, 32440880
31319298, 32778763, 33059836, 33069120, 33206894, 30952137, 33060154
33195381, 33134621, 33407390, 33407415, 33211396, 32708834, 33421004
33431184, 33292741, 33462670, 33323998, 33384768, 33270938, 33364702
33191472, 33327100, 31909148, 32348659, 32586512, 30861257, 30651192
32705059, 31994709, 32078541, 33011343, 32752676, 33211145, 32405411
29751899, 32718671, 32590699, 32602192, 33132559, 33165985, 30641360
33282235, 32601895, 32210667, 32305971, 31936711, 31798796, 33216300
30987480, 30657209, 33127470, 32900977, 32520627, 31129752, 31027089
32531117, 32516591, 32323766, 31767879, 32175024, 32919984, 33090993
30739999, 32909984, 31350053, 33007616, 32874901, 33020556, 31188252
32979114, 32829671, 32730840, 32730263, 32619120, 32793561, 32671982
32672061, 32877044, 32962259, 32957391, 31849679, 32588349, 32668506
32827405, 32733950, 30404574, 32254188, 32356789, 32425602, 31647619
32079019, 31798180, 32108804, 32576955, 32344132, 32460606, 30207560
32795888, 32847295, 32902439, 32512903, 32516012, 32466410, 32644918
32724986, 32761570, 32521947, 32559664, 32704396, 30811831, 32357955
31907806, 32197412, 32751728, 32369125, 32368515, 32532812, 31711659
31507455, 32356954, 32588385, 32486154, 32746863, 31071409, 32530878
31215503, 32503876, 32503834, 30246124, 32608486, 32440848, 32219607
32605331, 32654488, 32203093, 32640131, 31596830, 31015014, 31852517
32435985, 32138403, 32668289, 32252041, 32501929, 31729354, 31730873
32715896, 31226166, 32177770, 32619614, 31993851, 32560038, 32560240
32570276, 32560018, 32531211, 32559610, 32556409, 32550253, 32525298
32224574, 32500414, 31456379, 32253327, 32619823, 32250849, 32175609
32384829, 32594048, 31425300, 32036730, 32532571, 31507116, 31957005
32131349, 31965449, 32049242, 32402946, 31680465, 32228256, 32244769
32123618, 32465455, 32364995, 32442374, 32401716, 32351396, 32267972
32079454, 32113199, 32208663, 31770164, 32152343, 32143512, 32142819
32120542, 32063871, 31758036, 31541257, 31607315, 31607165, 31923063
30964666, 31832926, 31879230, 32211393, 32211410, 32125404, 32247110
31841413, 31627080, 32113491, 31456620, 32444005, 32385426, 32382366
32255371, 32230744, 31994726, 31097457, 29225584, 31924044, 31507736
29926335, 31460112, 31227988, 32052808, 31528537, 31941089, 31738301
31433207, 32048254, 32447395, 30484169, 31626902, 32130140, 31980534
31940189, 30680081, 31960849, 32319245, 32013705, 32005136, 31898626
31871467, 31892350, 29742654, 31098304, 31551177, 31650786, 31487146
31518720, 31278701, 31881852, 31606636, 31828895, 31838905, 29488053
30473302, 31801133, 31556722, 31601988, 31682817, 31760611, 31625576
31782581, 31738375, 31507433, 31228480, 31668277, 31547747, 30680613
31578150, 31561710, 31536652, 31779859, 31142667, 30693987, 31839093
31839081, 31703323, 31606188, 31587315, 31517762, 31627129, 31582715
31581443, 31521735, 31440697, 29909549, 31791789, 31780877, 31801459
31704543, 31659809, 31563090, 31561650, 30662222, 31458308, 31709430
30663522, 30917522, 31644179, 31656230, 31653611, 31484993, 31449007
31560266, 31601424, 31427347, 31418833, 29271448, 31616216, 31780135
31575532, 31779959, 31828792, 31000610, 31587607, 28725556, 30920035
29910461, 31596246, 31526548, 31794343, 16814471, 31131773, 30623521
31637694, 30076679, 31591273, 31689380, 30806586, 31695862, 30572581
31792776, 31780753, 31709315, 31346319, 29209870, 31386231, 30446367
31122004, 31548760, 31482479, 31516459, 31454801, 31381479, 31401692
31451676, 31497291, 30301634, 31476229, 30006961, 31461836, 30638977
31441364, 30902327, 31107854, 31113468, 31303118, 30911868, 31143243
29902799, 31350725, 31431124, 29156819, 30903305, 30342778, 30493260
30609604, 30048129, 25475406, 30494732, 29915014, 30897196, 30815503
31175237, 31346587, 31139595, 31367923, 30832255, 31198252, 30955351
31157419, 31139615, 30310568, 31336850, 30600473, 30587460, 30548038
30875325, 30826774, 31232100, 30950624, 30846419, 30812800, 30873300
30846594, 30889577, 30685842, 30990596, 26752745, 30333176, 31206379
31175842, 31202227, 31256737, 31311503, 31323928, 31323909, 31318412
30473323, 31118592, 31176144, 31170155, 28480385, 31240314, 31349966
30838154, 31373499, 31373504, 30926412, 31099592, 31367261, 30972344
31172278, 30975972, 31219406, 29166143, 31208886, 31209070, 31178248
31189911, 18294101, 30791492, 30797198, 29920698, 29856640, 30080233
31192285, 30494822, 30818727, 31410995, 31326414, 31329767, 31326425
31168595, 30827735, 31177621, 30883131, 31066223, 31222222, 31374076
31271859, 31045117, 31165352, 31072446, 31039410, 30994687, 30988993
30973776, 30973756, 30310604, 30737450, 30719897, 30719522, 30713018
30700666, 30693366, 30682568, 30665877, 30637766, 30635206, 30601520
30601512, 30594864, 30577266, 30358775, 30342450, 30818230, 30753086
30938120, 30905623, 30962699, 30945407, 30905759, 30905753, 30612519
30030259, 30030081, 30823432, 30786365, 16564626, 31040380, 31062378
31040907, 31114345, 31441320, 31381472, 31213929, 31225570, 31305105
31208291, 31316835, 31123944, 31158148, 31175404, 31190369, 31003735
30903771, 31013450, 31010508, 30861743, 26812342, 30633479, 26078270
29227058, 29314744, 29346116, 29376018, 29585511, 29774881, 29805211
30017628, 30024507, 30032166, 30102893, 30233950, 30275490, 30286459
30321894, 30340476, 30446832, 30473280, 30484525, 30503529, 30507570
30517837, 30539518, 30579002, 30598252, 30614202, 30622854, 30622974
30650848, 30663342, 30680258, 30680756, 30680818, 30686209, 30688349
30696013, 30703607, 30717771, 30722842, 30724310, 30729495, 30729766
30731018, 30734990, 30738970, 30763551, 30778094, 30782649, 30796546
30797378, 30818690, 30823108, 30827972, 30838254, 30845653, 30851346
30856970, 30864484, 30865197, 30865462, 30871350, 30877853, 30880051
30881232, 30881572, 30884891, 30890481, 30892202, 30896679, 30897713
30906693, 30911601, 30913807, 30932343, 30944394, 30947828, 30966524
30966604, 30966810, 30979167, 30990451, 30993340, 31027128, 31027137
31056957, 31071657, 29706933, 27313577, 29299615, 29358314, 29500119
29557298, 29809446, 29814575, 29869207, 29916615, 30033430, 30033958
30043836, 30102653, 30150540, 30162025, 30265723, 30267467, 30283060
30404307, 30427030, 30453041, 30453885, 30458313, 30468226, 30475749
30485152, 30494573, 30494613, 30511946, 30523539, 30534012, 30540184
30582001, 30585160, 30585161, 30618355, 30634544, 30634903, 30640908
30651405, 30651501, 30651691, 30669929, 30681006, 30441555
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@ggdb01 34008737]$
可见,OGG的补丁已经安装成功。
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@ggdb01 OPatch]$