问题现象: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.