Oracle GoldenGate（19.1.0.0）安装补丁操作手册

最新推荐文章于 2024-05-11 09:48:02 发布

君子不怨天

最新推荐文章于 2024-05-11 09:48:02 发布

阅读量821

点赞数

分类专栏： OGG 文章标签： oracle 数据库 ogg

本文链接：https://blog.csdn.net/ly7472712/article/details/127003912

版权

OGG 专栏收录该内容

6 篇文章 1 订阅

订阅专栏

OGG（19.1.0.0）安装22年第二季度补丁（34008763）

一、安装补丁操作

1、设置环境变量

su - ggate

执行以下命令，临时设置即可

export ORACLE_HOME=/ggate
export PATH=$PATH:/u01/app/oracle/product/19.3.0/dbhome_1/bin:/ggate/OPatch
export LD_LIBRARY_PATH=/u01/app/oracle/product/19.3.0/dbhome_1/lib

$ORACLE_HOME和$LD_LIBRARY_PATH必须更改，否则会导致安装失败

未配置ORACLE_HOME

$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.32
Copyright (c) 2022, 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.32
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2022-09-21_16-47-09PM_1.log

OPatch failed to lock and get an Inventory Session for the given Oracle Home /u01/app/oracle/product/19.3.0/dbhome_1
Possible causes are:
   No read or write permission to $ORACLE_HOME, cannot create $ORACLE_HOME/.patch_storage
   No read or write permission to $ORACLE_HOME/.patch_storage
   OPatch cannot proceed further because system will not be able to backup files, or read the backup area for rollback/restore.
UtilSession failed: IPMRWServices::verifyPatchStorageDirectory() cannot read or write to /u01/app/oracle/product/19.3.0/dbhome_1/.patch_storage
Log file location: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2022-09-21_16-47-09PM_1.log

OPatch failed with error code 73

未配置LD_LIBRARY_PATH

$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.32
Copyright (c) 2022, Oracle Corporation.  All rights reserved.


Oracle Home       : /ggate
Central Inventory : /u01/app/oraInventory
   from           : /ggate/oraInst.loc
OPatch version    : 12.2.0.1.32
OUI version       : 12.2.0.4.0
Log file location : /ggate/cfgtoollogs/opatch/opatch2022-09-21_16-48-02PM_1.log

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

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 = '/ggate')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '34008763' to OH '/ggate'

Patching component oracle.oggcore.ora19c, 19.1.0.0.0...
Patch 34008763 successfully applied.
Log file location: /ggate/cfgtoollogs/opatch/opatch2022-09-21_16-48-02PM_1.log
pure virtual method called
terminate called without an active exception
/ggate/OPatch/opatch: line 1367: 15369 Aborted                 $JAVA $JAVA_AGENT_OPTION $otherOpt $JAVA_VM_OPTION $JRE_MEMORY_OPTIONS -cp $opatchClassPath -DCommonLog.LOG_SESSION_ID="$LOG_SESSION_ID" -DCommonLog.COMMAND_NAME="$OPATCH_COMMAND" -DOPatch.ORACLE_HOME="$OH" -DOPatch.DEBUG="$DEBUGVAL" -DOPatch.MAKE="$MAKEVAL" -DOPatch.RUNNING_DIR="$BASE" -DOPatch.MW_HOME="$MWH" -DOPatch.WL_HOME="$WL_HOME" -DOPatch.COMMON_COMPONENTS_HOME="$COMMON_COMPONENTS_HOME" -DOPatch.OUI_LOCATION=$OUI_LOCATION -DOPatch.FMW_COMPONENT_HOME="$FMW_COMPONENT_HOME" -DOPatch.OPATCH_CLASSPATH="$CLASSPATH" -DOPatch.WEBLOGIC_CLASSPATH="$WEBLOGIC_CLASSPATH" -DOPatch.SKIP_OUI_VERSION_CHECK="$SKIP_OUI_VERSION_CHECK" -DOPatch.NEXTGEN_HOME_CHECK="$IS_NEXTGEN_HOME" -DOPatch.PARALLEL_ON_FMW_OH=$PARALLEL_ON_FMW_OH $FUSION_TRUST_OPTION ${oracleOcmService} ${_bootClassPath} oracle/opatch/OPatch $args $invptr

OPatch failed with error code 134

2、升级OPatch

上传opatch和补丁到/u01/software/目录

su - ggate

mv $ORACLE_HOME/OPatch /$ORACLE_HOME/OPatch_bak20220922

unzip /u01/software/p6880880* -d $ORACLE_HOME/

$ORACLE_HOME/OPatch/opatch version

3、停止OGG进程

cd $ORACLE_HOME
./ggsci
stop mgr
stop *

4、备份OGG目录

cd $ORACLE_HOME
tar -pvcvf ogg-20220921.tar *

5、查看补丁

$ opatch lspatches
There are no Interim patches installed in this Oracle Home "/ggate".

OPatch succeeded.

$ opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.32
Copyright (c) 2022, Oracle Corporation.  All rights reserved.


Oracle Home       : /ggate
Central Inventory : /u01/app/oraInventory
   from           : /ggate/oraInst.loc
OPatch version    : 12.2.0.1.32
OUI version       : 12.2.0.4.0
Log file location : /ggate/cfgtoollogs/opatch/opatch2022-09-21_17-09-12PM_1.log

Lsinventory Output file location : /ggate/cfgtoollogs/opatch/lsinv/lsinventory2022-09-21_17-09-12PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: ocp19c
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.


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

OPatch succeeded.

6、解压补丁

$ unzip /u01/software/p34008763_19100220419_Linux-x86-64.zip -d /u01/software

7、应用补丁

$ cd <PATCH_TOP_DIR>/<Patch_number>
$ opatch apply

操作如下：

$ cd /u01/software/34008763
$ pwd
/u01/software/34008763
$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.32
Copyright (c) 2022, Oracle Corporation.  All rights reserved.


Oracle Home       : /ggate
Central Inventory : /u01/app/oraInventory
   from           : /ggate/oraInst.loc
OPatch version    : 12.2.0.1.32
OUI version       : 12.2.0.4.0
Log file location : /ggate/cfgtoollogs/opatch/opatch2022-09-21_17-09-53PM_1.log

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

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 = '/ggate')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '34008763' to OH '/ggate'

Patching component oracle.oggcore.ora19c, 19.1.0.0.0...
Patch 34008763 successfully applied.
Log file location: /ggate/cfgtoollogs/opatch/opatch2022-09-21_17-09-53PM_1.log

OPatch succeeded.

8、校验补丁

$ opatch lspatches
34008763;

OPatch succeeded.

$ opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.32
Copyright (c) 2022, Oracle Corporation.  All rights reserved.


Oracle Home       : /ggate
Central Inventory : /u01/app/oraInventory
   from           : /ggate/oraInst.loc
OPatch version    : 12.2.0.1.32
OUI version       : 12.2.0.4.0
Log file location : /ggate/cfgtoollogs/opatch/opatch2022-09-21_17-10-23PM_1.log

Lsinventory Output file location : /ggate/cfgtoollogs/opatch/lsinv/lsinventory2022-09-21_17-10-23PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: ocp19c
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  34008763     : applied on Wed Sep 21 17:10:03 CST 2022
Unique Patch ID:  24739706
   Created on 11 Apr 2022, 23:09:19 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.

9、更新环境变量

此操作使配置文件中环境变量生效

$ source ~/.bash_profile

因为之前为了安装补丁，更改了三个ggate用户环境变量，但是升级后不更改为原来的环境变量将导致mgr进程无法启动，报错如下：
2022-09-21T17:12:10.840+0800  ERROR   OGG-00303  Oracle GoldenGate Manager for Oracle, mgr.prm:  Failed to initialize timezone information. Check location of ORACLE_HOME.
2022-09-21T17:12:10.840+0800  ERROR   OGG-01668  Oracle GoldenGate Manager for Oracle, mgr.prm:  PROCESS ABENDING.

10、启动OGG

$ cd $GGATE_HOME
$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 19.1.0.0.220419 OGGCORE_19.1.0.0.0OGGBP_PLATFORMS_220410.0713_FBO
Linux, x64, 64bit (optimized), Oracle 19c  on Apr 10 2022 10:51:05
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2022, Oracle and/or its affiliates. All rights reserved.



GGSCI (ocp19c) 1> start mgr
Manager started.
#其他进程按需启动

注：用户配置文件中：$GGATE_HOME=/ggate

二、回滚补丁操作

1、设置环境变量

执行以下命令，临时设置即可

export ORACLE_HOME=/ggate
export PATH=$PATH:/u01/app/oracle/product/19.3.0/dbhome_1/bin:/ggate/OPatch
export LD_LIBRARY_PATH=/u01/app/oracle/product/19.3.0/dbhome_1/lib

2、回滚补丁

$ cd <PATCH_TOP_DIR>/<Patch_number>
$ opatch rollback -id <Patch_number>

操作如下：

$ cd /u01/software/34008763
$ pwd
/u01/software/34008763
$ opatch rollback -id 34008763
Oracle Interim Patch Installer version 12.2.0.1.18
Copyright (c) 2022, Oracle Corporation.  All rights reserved.


Oracle Home       : /ggate
Central Inventory : /u01/app/oraInventory
   from           : /ggate/oraInst.loc
OPatch version    : 12.2.0.1.18
OUI version       : 12.2.0.4.0
Log file location : /ggate/cfgtoollogs/opatch/opatch2022-09-21_16-01-39PM_1.log


Patches will be rolled back in the following order: 
   34008763
The following patch(es) will be rolled back: 34008763  

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/ggate')


Is the local system ready for patching? [y|n]
y
User Responded with: Y

Rolling back patch 34008763...

RollbackSession rolling back interim patch '34008763' from OH '/ggate'

Patching component oracle.oggcore.ora19c, 19.1.0.0.0...
RollbackSession removing interim patch '34008763' from inventory
Log file location: /ggate/cfgtoollogs/opatch/opatch2022-09-21_16-01-39PM_1.log

OPatch succeeded.
$

3、校验补丁

$ opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.18
Copyright (c) 2022, Oracle Corporation.  All rights reserved.


Oracle Home       : /ggate
Central Inventory : /u01/app/oraInventory
   from           : /ggate/oraInst.loc
OPatch version    : 12.2.0.1.18
OUI version       : 12.2.0.4.0
Log file location : /ggate/cfgtoollogs/opatch/opatch2022-09-21_16-07-44PM_1.log

Lsinventory Output file location : /ggate/cfgtoollogs/opatch/lsinv/lsinventory2022-09-21_16-07-44PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: ocp19c
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.


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

OPatch succeeded.

参考官方文档：

Primary Note for Oracle GoldenGate Core Product Patch Sets (Doc ID 1645495.1)
Oracle GoldenGate 19.1.0.0.220419 Patch Set Availability (Doc ID 2885849.1)
OPatch - Where Can I Find the Latest Version of OPatch(6880880)? [Video] (Doc ID 224346.1)