问题现象:Oracle GoldenGate Monitor agent正常安装后,info all中查看JAGENT 进程已经存在,进程也可以正常启动,但是OEM的OGG插件自动搜索始终无法搜索到OGG组件;
问题排查:使用ORACLE MOS文档How To Run jagentdebug.jar Debug Script To Help with GoldenGate Monitoring Issues (OEM/OGG Monitor Server)? (Doc ID 2410209.1)中的jagentdebug.jar DEBUG,整个ogg monitor客户端的安装也是正常的;后经排查,ogg monitor的日志,有OGGMON-20603、OGGMON-20609等报错,进一步分析排查,需要安装补丁29684138(ogg monitor监控OGG 18C以上版本时需要,本次使用的是OGG 19.1.0.0.210720 版本),安装此补丁后可以从OEM13.2版本中搜索到OGG并加入监控;
ogg monitor客户端日志信息:
[2021-10-15T10:29:53.650+08:00] [JAGENT] [ERROR] [OGGMON-20603] [com.goldengate.monitor.jagent.comm.ws.ManagerService] [tid: MessageCollector] [ecid: 0000Nm1gtXy0rm^_xTs1yW1XQE8n000002,0] RESTful Web Service with name messages/last has become unresponsive [2021-10-15T10:29:58.607+08:00] [JAGENT] [ERROR] [OGGMON-20494] [com.goldengate.monitor.jagent.comm.ws.NotificationsCollector] [tid: StatusCollector] [ecid: 0000Nm1gtXx0rm^_xTs1yW1XQE8n000001,0] Error occurred while registering the OGG process. Exception: [[ source parameter must not be null ]] [2021-10-15T10:29:58.651+08:00] [JAGENT] [ERROR] [OGGMON-20609] [com.goldengate.monitor.jagent.comm.ws.ManagerService] [tid: MessageCollector] [ecid: 0000Nm1gtXy0rm^_xTs1yW1XQE8n000002,0] Unsuccessful connection response from Message Web Service. Query String: messages/last ; Response Code: 404 ; Response Message: Not Found [2021-10-15T10:29:58.652+08:00] [JAGENT] [ERROR] [OGGMON-20603] [com.goldengate.monitor.jagent.comm.ws.ManagerService] [tid: MessageCollector] [ecid: 0000Nm1gtXy0rm^_xTs1yW1XQE8n000002,0] RESTful Web Service with name messages/last has become unresponsive [2021-10-15T10:29:58.652+08:00] [JAGENT] [ERROR] [OGGMON-20609] [com.goldengate.monitor.jagent.comm.ws.ManagerService] [tid: MessageCollector] [ecid: 0000Nm1gtXy0rm^_xTs1yW1XQE8n000002,0] Unsuccessful connection response from Message Web Service. Query String: messages/last ; Response Code: 404 ; Response Message: Not Found
打补丁过程:
GGSCI (oracle12c) 4> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING JAGENT STOPPED PMSRVR STOPPED EXTRACT RUNNING EXT1 00:00:00 00:00:00 EXTRACT RUNNING PUMP1 00:00:00 00:00:04 先关闭JAGNET进程,这样OGG MONITOR目录就没有活动进程,可以ps -ef确认,之后才能打补丁,与ORACLE数据库软件打补丁一样道理。 $export ORACLE_HOME=/oracle/wls ===>>要设置OGG安装路径 [oracle@oracle12c:/home/oracle/29684138]$/oracle/wls/OPatch/opatch lsinv Oracle Interim Patch Installer version 13.9.1.0.0 Copyright (c) 2021, Oracle Corporation. All rights reserved. Oracle Home : /oracle/wls Central Inventory : /oracle/oraInventoryogg from : /oracle/wls/oraInst.loc OPatch version : 13.9.1.0.0 OUI version : 13.9.1.0.0 Log file location : /oracle/wls/cfgtoollogs/opatch/opatch2021-10-15_13-37-51PM_1.log OPatch detects the Middleware Home as "/oracle/wls" Lsinventory Output file location : /oracle/wls/cfgtoollogs/opatch/lsinv/lsinventory2021-10-15_13-37-51PM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: oracle12c ARU platform id: 226 ARU platform description:: Linux x86-64 Interim patches (6) : Patch 22754279 : applied on Thu Oct 14 21:09:29 CST 2021 Unique Patch ID: 20383951 Patch description: "One-off" Created on 9 Jul 2016, 00:36:58 hrs UTC Bugs fixed: 22754279 Patch 21663638 : applied on Thu Oct 14 21:09:02 CST 2021 Unique Patch ID: 20477024 Patch description: "One-off" Created on 31 Aug 2016, 21:01:13 hrs UTC Bugs fixed: 21663638 Patch 19795066 : applied on Thu Oct 14 21:08:34 CST 2021 Unique Patch ID: 19149348 Patch description: "One-off" Created on 16 Jul 2015, 15:51:43 hrs UTC Bugs fixed: 19795066 Patch 19632480 : applied on Thu Oct 14 21:08:08 CST 2021 Unique Patch ID: 19278519 Patch description: "One-off" Created on 25 Aug 2015, 07:19:43 hrs UTC Bugs fixed: 19632480 Patch 19154304 : applied on Thu Oct 14 21:07:41 CST 2021 Unique Patch ID: 19278518 Patch description: "One-off" Created on 25 Aug 2015, 07:10:13 hrs UTC Bugs fixed: 19154304 Patch 19030178 : applied on Thu Oct 14 21:07:14 CST 2021 Unique Patch ID: 19234068 Patch description: "One-off" Created on 4 Aug 2015, 05:40:22 hrs UTC Bugs fixed: 19030178 -------------------------------------------------------------------------------- OPatch succeeded. [oracle@oracle12c:/home/oracle/29684138]$/oracle/wls/OPatch/opatch apply Oracle Interim Patch Installer version 13.9.1.0.0 Copyright (c) 2021, Oracle Corporation. All rights reserved. Oracle Home : /oracle/wls Central Inventory : /oracle/oraInventoryogg from : /oracle/wls/oraInst.loc OPatch version : 13.9.1.0.0 OUI version : 13.9.1.0.0 Log file location : /oracle/wls/cfgtoollogs/opatch/opatch2021-10-15_13-38-00PM_1.log OPatch detects the Middleware Home as "/oracle/wls" Verifying environment and performing prerequisite checks... OPatch continues with these patches: 29684138 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 = '/oracle/wls') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '29684138' to OH '/oracle/wls' Patching component oracle.ogg.monitor.agent, 12.2.1.2.0... Patching component oracle.ogg.monitor.agent, 12.2.1.2.0... Patch 29684138 successfully applied. Log file location: /oracle/wls/cfgtoollogs/opatch/opatch2021-10-15_13-38-00PM_1.log OPatch succeeded.