Goldengate 12c生产环境抽取进程遇到一个故障,上mos查了下报错,发现是ogg的一个bug,需要打psu补丁解决。ogg打补丁的步骤如下:
1.验证opatch是否正常显示相关信息
1.1 切换到设置ogg的ORACLE_HOME
export ORACLE_HOME=/opt/app/OGG_12
1.2 执行 optch lsinventory
/opt/app/OGG_12/OPatch/optch lsinventory
oracle@bd-dev-oracle-104:/opt/app/oraInventory/ContentsXML$/opt/app/OGG_12/OPatch/opatch lsinventory
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation. All rights reserved.
Oracle Home : /opt/app/OGG_12
Central Inventory : /opt/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /opt/app/OGG_12/cfgtoollogs/opatch/opatch2018-12-18_13-52-07PM.log
Lsinventory Output file location : /opt/app/OGG_12/cfgtoollogs/opatch/lsinv/lsinventory2018-12-18_13-52-07PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle GoldenGate Core 12.2.0.0.0
There are 1 products installed in this