oracle goldengate monitor,goldengate monitor 11.1安装配置四——OGG Monitor配置

goldengate monitor 11.1安装配置一——OGG配置

[url]http://www.orasql.com/blog/archives/2014/01/15/ogg_monitor_1.htm [/url]

goldengate monitor 11.1安装配置二——OGG测试

[url]http://www.orasql.com/blog/archives/2014/01/16/ogg_monitor_2.htm[/url]

goldengate monitor 11.1安装配置三——OGG Monitor安装部署

[url]http://www.orasql.com/blog/archives/2014/01/17/ogg_monitor_3.htm[/url]

本节主要是配置OGG Monitor，来监控ogg的所有进程。

关于配置过程中遇到的错误，以及trouble shooting的过程详见：

[url]http://www.orasql.com/blog/archives/2013/08/24/ogg_monitor_ts.htm[/url]

另外如果登录ogg Monitor web时帐号密码错误，页面会出现400错误：The requested resource (/monitor/errorPage.jspx) is not available，输入正确的帐号密码即可。

如果在配置过程中还有其他问题，可以和我交流。

官方文档中对环境有如下要求：

* Install a release of Java 1.6 Java Development Kit (JDK) on each system where Oracle GoldenGate is installed.

❍ This must be the JDK, not a Java Runtime Environment (JRE).

❍ For the Windows x64 platform, you must use the x64 version of JDK or the

Manager will not be able to load the Java agent.

* ● Set the environmental variables to point to the JDK: For example on Windows: Set the JAVA_HOME variable to the location of the JDK installation.

* ❍Set the PATH variable to the \\jre\\bin of the JDK installation location %JAVA_HOME%\\jre\\bin

* ❍ Set the PATH variable to the location of jvm.dll (the \\jre\\bin\\server directory of the JDK installation location) %JAVA_HOME%\\jre\\bin\\server

配置过程如下:

1、安装JAVA，配置环境变量

[code][root@localhost u01]# chmod a+x java1.6_linux_x86_32.bin

[root@localhost u01]# ls -l

total 67132

-rwxr-xr-x 1 oracle dba 68637258 Aug 22 16:12 java1.6_linux_x86_32.bin

drwx------ 2 root root 16384 Aug 21 10:33 lost+found

drwxr-xr-x 4 oracle dba 4096 Aug 22 10:41 ogg

drwxr-xr-x 2 root root 4096 Aug 21 10:46 swap

drwxrwxr-x 4 oracle dba 4096 Aug 21 13:34 TimesTen

[root@localhost u01]# ./java1.6_linux_x86_32.bin

Unpacking...

Checksumming...

Extracting...

UnZipSFX 5.50 of 17 February 2002, by Info-ZIP (Zip-Bugs@lists.wku.edu).

inflating: jdk-6u45-linux-i586.rpm

inflating: sun-javadb-common-10.6.2-1.1.i386.rpm

inflating: sun-javadb-core-10.6.2-1.1.i386.rpm

inflating: sun-javadb-client-10.6.2-1.1.i386.rpm

inflating: sun-javadb-demo-10.6.2-1.1.i386.rpm

inflating: sun-javadb-docs-10.6.2-1.1.i386.rpm

inflating: sun-javadb-javadoc-10.6.2-1.1.i386.rpm

Preparing... ########################################### [100%]

1:jdk ########################################### [100%]

Unpacking JAR files...

rt.jar...

jsse.jar...

charsets.jar...

tools.jar...

localedata.jar...

plugin.jar...

javaws.jar...

deploy.jar...

Installing JavaDB

Preparing... ########################################### [100%]

1:sun-javadb-common ########################################### [ 17%]

2:sun-javadb-core ########################################### [ 33%]

3:sun-javadb-client ########################################### [ 50%]

4:sun-javadb-demo ########################################### [ 67%]

5:sun-javadb-docs ########################################### [ 83%]

6:sun-javadb-javadoc ########################################### [100%]

Done.

[root@localhost u01]# vim /home/oracle/.bash_profile

export JAVA_HOME=/usr/java/jdk1.6.0_45

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib:/u01/TimesTen/tt11/lib:/usr/java/jdk1.6.0_45/jre/lib/i386/server/

export PATH=$ORACLE_HOME/bin:/u01/TimesTen/tt11/bin:/usr/java/jdk1.6.0_45/jre/bin:/usr/java/jdk1.6.0_45/jre/bin/server:$PATH

[root@localhost u01]# source /home/oracle/.bash_profile

[root@localhost jdk1.6.0_45]# java -version

java version "1.6.0_45"

Java(TM) SE Runtime Environment (build 1.6.0_45-b06)

Java HotSpot(TM) Client VM (build 20.45-b01, mixed mode, sharing)[/code]

2、修改ogg目录权限，打开监听

[code][root@localhost ~]# chown -R oracle:dba /u01/ogg

[oracle@localhost ~]$ lsnrctl start

[oracle@localhost ~]$ sqlplus / as sysdba

SQL> alter system register; [/code]

3、配置GLOBALS参数ENABLEMONITORAGENT

[code]GGSCI (localhost.localdomain) 3> edit param ./GLOBALS

GGSCHEMA ogguser

CHECKPOINTTABLE ogguser.checkpoint

ENABLEMONITORAGENT

GGSCI (localhost.localdomain) 5> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

JAGENT STOPPED

EXTRACT STOPPED AWEN_EXT 00:00:00 28:21:32

EXTRACT STOPPED AWEN_PMP 00:00:00 28:21:31

REPLICAT STOPPED AWEN_REP 00:00:00 28:21:30 [/code]

4、配置Config.properties参数

[code][oracle@localhost cfg]$ pwd

/u01/ogg/ogghome/cfg

[oracle@localhost cfg]$ vim Config.properties

jagent.host =192.168.3.142

monitor.host =192.168.3.142

monitor.jmx.username =jmxuser

agent.type.enabled=OGGMON

jagent.username=oggmonitor

jagent.jmx.port=5588[/code]

5、创建密钥

[code][oracle@localhost ogghome]$ ./pw_agent_util.sh -create

Please create a password for Java Agent:

Please confirm password for Java Agent:

Please enter Monitor Server JMX password:

Please confirm Monitor Server JMX password:

Wallet is created successfully.[/code]

6、运行monitor.sh脚本

[code][oracle@localhost bin]$ ./monitor.sh stop

Using CATALINA_BASE: /u01/ogg/oggmonitor/tomcat

Using CATALINA_HOME: /u01/ogg/oggmonitor/tomcat

Using CATALINA_TMPDIR: /u01/ogg/oggmonitor/tomcat/temp

Using JRE_HOME: /u01/ogg/oggmonitor/jre

[oracle@localhost bin]$ ./monitor.sh start

Using CATALINA_BASE: /u01/ogg/oggmonitor/tomcat

Using CATALINA_HOME: /u01/ogg/oggmonitor/tomcat

Using CATALINA_TMPDIR: /u01/ogg/oggmonitor/tomcat/temp

Using JRE_HOME: /u01/ogg/oggmonitor/jre[/code]

7、运行jagent进程

[code]GGSCI (localhost.localdomain) 55> stop JAGENT

JAgent process is required by other GGS processes.

Are you sure you want to stop it (y/n)? y

Sending STOP request to GGCMD JAGENT ...

Request processed.

JAgent stopped.

GGSCI (localhost.localdomain) 56> start JAGENT

GGCMD JAGENT started

GGSCI (localhost.localdomain) 57> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

JAGENT RUNNING

EXTRACT RUNNING AWEN_EXT 00:00:00 00:00:00

EXTRACT RUNNING AWEN_PMP 00:00:00 00:00:07

REPLICAT RUNNING AWEN_REP 00:00:00 00:00:04

GGSCI (localhost.localdomain) 58> view report JAGENT

***********************************************************************

Oracle GoldenGate Command Tool for Oracle

Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230

Linux, x86, 32bit (optimized) on Apr 23 2012 04:36:58

Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.

Starting at 2013-08-23 23:00:48

***********************************************************************

Operating System Version:

Linux

Version #1 SMP Tue Aug 18 15:51:54 EDT 2009, Release 2.6.18-164.el5

Node: localhost.localdomain

Machine: i686

soft limit hard limit

Address Space Size : unlimited unlimited

Heap Size : unlimited unlimited

File Size : unlimited unlimited

CPU Time : unlimited unlimited

Process id: 4138

Parameters...

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

Program is 'java', arguments are '-jar -Xms64m -Xmx512m dirjar/jagent.jar'

***********************************************************************

** Run Time Messages **

***********************************************************************

2013-08-23 23:00:48 INFO OGG-00978 GGCMD JAGENT is running.

2013-08-23 23:00:48 INFO OGG-01927 Child process started, process ID 4142, command line 'java -jar -Xms64m -Xmx512m dirjar/jagent.jar'.[/code]

8、登录到WEB界面，查看进程状态

http://192.168.3.142:5555/monitor

账户密码：oggmonitor oracle

不仅可以清楚的看到整个系统的拓扑结构，还可以查看每个进程的状态

[img]http://www.orasql.com/blog//uploadfiles/l8~hu{jxv48yd226hr8a8iv_17355.jpg[/img]

「喜欢文章，快来给作者赞赏墨值吧」 赞赏

【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源(墨天轮)，文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。

评论

请登录后发表评论