天萃荷净
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使用笔记