sitemap

RSS地图

收藏本站

设为首页

Oracle研究中心

当前位置:Oracle研究中心 > 产品DBA > Oracle GG >

【学习笔记】Oracle goldengate monitor使用笔记

时间:2016-12-07 20:46   来源:Oracle研究中心   作者:网络   点击:

天萃荷净 Oracle研究中心学习笔记:分享一篇关于Oracle数据库goldengate monitor的使用笔记。

本站文章除注明转载外,均为本站原创: 转载自love wife & love life —Roger 的Oracle技术博客
本文链接地址: Goldengate monitor v11.1 –How to Use

1. 如何启停monitor serOracleoracleplus.netver ?

[ggs@10gasm bin]$ pwd
/home/ggs/ggs_monitor/monitor_linux86/bin
[ggs@10gasm bin]$ ls -ltr
total 20
-r-xr----- 1 ggs oinstall 1068 Aug 24  2011 pw_server_util.sh
-rwxr----- 1 ggs oinstall 1031 Aug 24  2011 pw_server_util.bat
-r-xr----- 1 ggs oinstall  821 Aug 24  2011 monitor.sh
-rwxr----- 1 ggs oinstall 2528 Aug 24  2011 monitor-service.bat
-rwxr----- 1 ggs oinstall 1937 Aug 22 22:47 monitor.bat

unix/linux 平台执行 ./monitor.sh start/stop 即可。windows平台执行bat脚本就行了。

2. 如何更改相关的密码?

如果你需要定期更改jmxuser等用户的密码,可以使用上面的pw_server_util.sh脚本,如下:
[ggs@10gasm bin]$ ./pw_server_util.sh -h
Invalid options.
USAGE: pw_server_util -updateJMX | -updateJPA | -updateSMTP
[ggs@10gasm bin]$

3. 如何更改java启动内存?

可以直接修改monitor脚本,修改如下部分即可:
JAVA_OPTS='-Xms512m -Xmx1024m -XX:PermSize=256m -XX:MaxPermSize=512m -Djava.awt.headless=true'

4. 如何更改jagent 端的java内存分配?

直接进行ggsci命令行,编辑如下部分即可:
GGSCI (killdb.com) 63> view param jagent

COMMAND java -jar -Xms64m -Xmx512m dirjar/jagent.jar

注意更改以后需要重启下jagent服务。

5. 如何配置email alert告警?

该选项意为如果监控发放ogg出现异常会通过email的方式告知你。

直接修改cfg目录下的monitor.properties文件即可。例如我这里:
#Whether internal components are exposed as MBeans - useful for troubleshooting
#monitor.jmx.internal.mbeans.enabled=false

#Sender's name/email Mr. Postman
monitor.smtp.from=Oracle GoldenGate Monitor

#SMTP server's hostname/ip
monitor.smtp.host=smtp.live.com

具体更多详细的配置,大家去参考官方文档。

6. 关于monitor和jagent的日志 ?

针对源端,monitor server,在安装home目录下面有一个logs目前,我这里是:
[ggs@10gasm logs]$ pwd
/home/ggs/ggs_monitor/monitor_linux86/logs
[ggs@10gasm logs]$
[ggs@10gasm logs]$ tail -10 monitor.log
08-26 06:51:40 684455 [AgentConnectionKeeper(agentId=106,oldName=pool-2-thread-3)] INFO  com.goldengate.monitor.backend.objects.impl.AgentConnectionKeeperImpl  -
Failed to connected to AgentEntity(id=106, info=JmxConnectionInfoEntity(killdb.com:5555))
08-26 06:51:40 684455 [AgentConnectionKeeper(agentId=106,oldName=pool-2-thread-3)] INFO  com.goldengate.monitor.backend.objects.impl.AgentConnectionKeeperImpl  -
Sleeping 30 seconds before another attempt
08-26 06:52:18 722908 [AgentConnectionKeeper(agentId=106,oldName=pool-2-thread-3)] INFO  com.goldengate.monitor.backend.objects.impl.AgentConnectionKeeperImpl  -
Attempt 9/10 of connecting to AgentEntity(id=106, info=JmxConnectionInfoEntity(killdb.com:5555))
08-26 06:53:10 774903 [AgentConnectionKeeper(agentId=106,oldName=pool-2-thread-3)] WARN  com.goldengate.monitor.backend.objects.impl.AgentConnectionKeeperImpl  -
Connection to JmxConnectionInfoEntity(killdb.com:5555) failed: com.goldengate.monitor.model.AgentCommunicationException: java.net.UnknownHostException: killdb.com
08-26 06:53:10 774909 [AgentConnectionKeeper(agentId=106,oldName=pool-2-thread-3)] INFO  com.goldengate.monitor.backend.objects.impl.AgentConnectionKeeperImpl  -
Failed to connected to AgentEntity(id=106, info=JmxConnectionInfoEntity(killdb.com:5555))
08-26 06:53:10 774909 [AgentConnectionKeeper(agentId=106,oldName=pool-2-thread-3)] INFO  com.goldengate.monitor.backend.objects.impl.AgentConnectionKeeperImpl  -
Sleeping 30 seconds before another attempt

针对目标端端,在ogg软件的安装目录下有一个jagent.log,该文件记录了目标端jagent服务的具体信息,例如:
-bash-3.00$ pwd
/home/ggs/ggs_home
-bash-3.00$ tail -10 jagent.log
2012-08-26 06:40:46 [agentRegistration] INFO  ManagerWSApi - WS getMps with id: trail:192.168.0.115---7809---./dirdat---rm
2012-08-26 06:40:46 [agentRegistration] INFO  ManagerWSApi - Getting MP's for trail:192.168.0.115---7809---./dirdat---rm
2012-08-26 06:40:46 [agentRegistration] INFO  ManagerWSApi - +++++++++++ getMonitoringPoints localId=trail:192.168.0.115---7809---./dirdat---rm, running=true, prevRunning=false
2012-08-26 06:40:46 [agentRegistration] INFO  ManagerWSApi - getMonitoringPoints() ---------- Getting Monitoring Points for processName REP2
2012-08-26 06:40:46 [agentRegistration] INFO  ManagerWSApi - getMonitoringPoints() +++++++++ GgsObjectType = TRAIL
2012-08-26 06:40:46 [agentRegistration] INFO  MonitoringPointsHelper - loadTrailMonitoringPoints REP2 for localId=trail:192.168.0.115---7809---./dirdat---rm, running=true, prevRunning=false
2012-08-26 06:40:46 [agentRegistration] INFO  MonitoringPointsHelper - Loaded REP2 Trail Output monitoring points MpListImpl[id:trail:192.168.0.115---7809---./dirdat---rm,mps:
[MpValueImpl[name:name,value:rm], MpValueImpl[name:path,value:./dirdat]]]
2012-08-26 06:41:11 [agentRegistration] INFO  CmDelegateImpl - Agent incrementalRegistration complete
2012-08-26 06:47:22 [MessageCollector] INFO  MessageCollector - Processing message for REP2 Sequence 191
2012-08-26 06:47:22 [MessageCollector] INFO  MessageCollector - Flushing messages for REP2
-bash-3.00$

7. 关于具体如何使用,我想不用多说了吧,gui界面,直接点点就清楚了,我晒几张图,简单的描述下功能。










--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之【学习笔记】Oracle goldengate monitor使用笔记

本文由大师惜分飞原创分享,网址:http://www.oracleplus.net/arch/1374.html

Oracle研究中心

关键词:

goldengate monitor

goldengate monitor 11.1.1

goldengate monitor的使用案例