可以使用Goldengate Monitor来监控和管理Goldengate。
本文目录结构为：

1、环境

用途	monitor server	monitor agent31	monitor agent38
IP	192.168.36.31	192.168.10.31	192.168.12.38
用户	oracle	oracle	oracle
JDK	jdk-8u51-linux-x64.tar.gz	jdk-8u51-linux-x64.tar.gz	jdk-8u51-linux-x64.tar.gz
中间件	fmw_12.2.1.0.0_infrastructure_Disk1_1of1
数据库	Oracle 11.2.0.4
monitor	fmw_12.2.1.0.0_ogg.jar
agent		fmw_12.2.1.0.0_ogg.jar	fmw_12.2.1.0.0_ogg.jar
goldengate		12.2.0.1.1	12.2.0.1.1

2、基础软件安装

参考http://blog.itpub.net/28536251/viewspace-2139643/安装和创建数据库，作为monitor的数据仓库。

参考http://blog.itpub.net/28536251/viewspace-2136343/安装配置OGG同步环境，作为被监控的对象。

3、server上安装JDK

[oracle@D2-OGGM31 ~]$ tar -xvzf jdk-8u51-linux-x64.tar.gz

[oracle@D2-OGGM31 ~]$ tail -4 .bash_profile

export JAVA_HOME=/home/oracle/jdk1.8.0_51

export JRE_HOME=${JAVA_HOME}/jre

export CLASSPATH=.:%{JAVA_HOME}/lib:%{JRE_HOME}/lib

export PATH=${JAVA_HOME}/bin:$PATH

[oracle@D2-OGGM31 ~]$ source .bash_profile

[oracle@D2-OGGM31 ~]$ java -version

java version "1.8.0_51"

Java(TM) SE Runtime Environment (build 1.8.0_51-b16)

Java HotSpot(TM) 64-Bit Server VM (build 25.51-b03, mixed mode)

4、server上安装中间件

[oracle@D2-OGGM31 ~]$ unzip fmw_12.2.1.0.0_infrastructure_Disk1_1of1.zip

[oracle@D2-OGGM31 ~]$ export DISPLAY=192.168.17.100:0.0

[oracle@D2-OGGM31 ~]$ java -jar fmw_12.2.1.0.0_infrastructure.jar

5、server上安装monitor server

[oracle@D2-OGGM31 ~]$ unzip V78177-01.zip

[oracle@D2-OGGM31 ~]$ java -jar fmw_12.2.1.0.0_ogg.jar

6、server上创建RCU

首先确认数据库字符集

SQL> select userenv('language') from dual;

USERENV('LANGUAGE')

----------------------------------------------------

AMERICAN_AMERICA.AL32UTF8

[oracle@D2-OGGM31 ~]$ cd /u01/app/Middleware/Oracle_Home/oracle_common/bin/

[oracle@D2-OGGM31 bin]$ ./rcu

密码：Aaaa1111

7、server上配置Domain

[oracle@D2-OGGM31 bin]$ cd /u01/app/Middleware/Oracle_Home/wlserver/common/bin/

[oracle@D2-OGGM31 bin]$ ./config.sh

密码：Aaaa1111

密码统一为：Aaaa1111

8、server上Configure the JMX Server Properties

[oracle@D2-OGGM31 ~]$ cd /u01/app/Middleware/Oracle_Home/oggmon/monitor_server/bin

[oracle@D2-OGGM31 bin]$ ./updateOGGMonitorConfig.sh

This script utility is used to update configuration information for monitor server. All feilds are mandatory. Press Ctrl+C to exit.

Enter absolute path for oggmon domain:

/u01/app/Middleware/Oracle_Home/user_projects/domains/oggmon1221_domain

You have entered the domain path as : /u01/app/Middleware/Oracle_Home/user_projects/domains/oggmon1221_domain

Enter JMX HOST NAME/IP:192.168.36.31

Enter JMX Server Port:5502

Enter JMX Server Username:jmxuser

Enter the database type for Monitor Installation.

For Oracle Database, Press 1. For SQL Server, Press 2:1

Mar 13, 2017 5:56:24 PM oracle.security.jps.JpsStartup start

INFO: Jps initializing.

Mar 13, 2017 5:56:25 PM org.hibernate.validator.internal.util.Version

INFO: HV000001: Hibernate Validator 5.1.3.Final

Mar 13, 2017 5:56:30 PM oracle.security.jps.JpsStartup start

INFO: Jps started.

Mar 13, 2017 5:56:31 PM oracle.security.audit.Auditor init

WARNING: IAU:IAU-6012: Unable to determine the audit log directory. No log directory specified.

Mar 13, 2017 5:56:31 PM oracle.security.jps.util.JpsUtil disableAudit

INFO: JpsUtil: isAuditDisabled set to true

Mar 13, 2017 5:56:31 PM oracle.security.jps.internal.audit.AuditServiceImpl validateLogPossible

WARNING: No audit log directory is set. Cannot perform audit operations for component JPS.

Created Secure Key properties file.

Added Secure Key into Monitor Server Oracle Wallet.

After successful execution of this script, the Secure Key properties file, oggmon.properties, is created in encoded format, and contains all of the configuration information you just provided. This Secure Key is added to your Oracle GoldenGate Monitor Server Oracle wallet.

Copy the oggmon.properties file to the cfg directory of your Oracle GoldenGate Monitor Agent instance. For Oracle GoldenGate Monitor Server, the directory is MonitorServer_WLS_Domain/config/monitorserver/cfg; for Monitor Agent, the directory is MonitorAgent_Instance_Home/cfg.

9、server上启动WebLogic Administration Server

配置启动文件：

[oracle@D2-OGGM31 bin]$ cd /u01/app/Middleware/Oracle_Home/user_projects/domains/oggmon1221_domain/

[oracle@D2-OGGM31 oggmon1221_domain]$ mkdir -p servers/AdminServer/security

[oracle@D2-OGGM31 oggmon1221_domain]$ echo "username=weblogic" > servers/AdminServer/security/boot.properties

[oracle@D2-OGGM31 oggmon1221_domain]$ echo "password=Aaaa1111" >> servers/AdminServer/security/boot.properties

[oracle@D2-OGGM31 oggmon1221_domain]$ cat servers/AdminServer/security/boot.properties

username=weblogic

password=Aaaa1111

[oracle@D2-OGGM31 oggmon1221_domain]$ ./startWebLogic.sh &

10、server上创建monitor专用用户

http://192.168.36.31:7001/console登录weblogic：

用户名：weblogic；密码：Aaaa1111

用户名：oggmonitor；密码：Aaaa1111

11、server上启动WebLogic Managed Server

[oracle@D2-OGGM31 ~]$ cd /u01/app/Middleware/Oracle_Home/user_projects/domains/oggmon1221_domain/bin/

[oracle@D2-OGGM31 bin]$ cp startManagedWebLogic.sh startManagedWebLogic.sh.bak

[oracle@D2-OGGM31 bin]$ vim startManagedWebLogic.sh

[oracle@D2-OGGM31 bin]$ grep -E 'WLS_USER=|WLS_PW=' startManagedWebLogic.sh

WLS_USER="oggmonitor"

WLS_PW="Aaaa1111"

[oracle@D2-OGGM31 bin]$ vim setStartupEnv.sh

# 64 bit JVM memory settings

SERVER_MEM_ARGS_64="-Xms256m -Xmx1024m"

export SERVER_MEM_ARGS_64

SERVER_MEM_ARGS_64HotSpot="-Xms256m -Xmx4096m"

export SERVER_MEM_ARGS_64HotSpot

SERVER_MEM_ARGS_64JRockit="-Xms256m -Xmx1024m"

export SERVER_MEM_ARGS_64JRockit

[oracle@D2-OGGM31 bin]$ ./startManagedWebLogic.sh MONITORSERVER_server1 http://192.168.36.31:7001 &

http://192.168.36.31:7003/monitor/faces/loginPage.jspx启动后就可以进入monitor web页面：

用户名：oggmonitor；密码：Aaaa1111

12、agent31上安装monitor agent

需要先安装JDK

[oracle@ORACLEDG31 ~]$ tar -xvzf jdk-8u51-linux-x64.tar.gz

[oracle@ORACLEDG31 ~]$ tail -4 .bash_profile

export JAVA_HOME=/home/oracle/jdk1.8.0_51

export JRE_HOME=${JAVA_HOME}/jre

export CLASSPATH=.:%{JAVA_HOME}/lib:%{JRE_HOME}/lib

export PATH=${JAVA_HOME}/bin:$PATH

[oracle@ORACLEDG31 ~]$ source .bash_profile

[oracle@ORACLEDG31 ~]$ java -version

java version "1.8.0_51"

Java(TM) SE Runtime Environment (build 1.8.0_51-b16)

Java HotSpot(TM) 64-Bit Server VM (build 25.51-b03, mixed mode)

安装agent

[oracle@ORACLEDG31 ~]$ unzip V78177-01.zip

[oracle@ORACLEDG31 ~]$ export DISPLAY=192.168.17.100:0.0

[oracle@ORACLEDG31 ~]$ java -jar fmw_12.2.1.0.0_ogg.jar

13、agent31上创建agent 实例

[oracle@ORACLEDG31 ~]$ mkdir -p /u01/app/Oracle/Middleware/Oracle_Home/oggmon/agent1

[oracle@ORACLEDG31 ~]$ cd /u01/app/Oracle/Middleware/Oracle_Home/oggmon/ogg_agent/

[oracle@ORACLEDG31 ogg_agent]$ ./createMonitorAgentInstance.sh

Please enter absolute path of Oracle GoldenGate home directory : /u01/app/goldengate/

Please enter absolute path of OGG Agent instance : /u01/app/Oracle/Middleware/Oracle_Home/oggmon/agent1/

Please enter unique name to replace timestamp in startMonitorAgent script (startMonitorAgentInstance_20170314101536.sh) : 01

Sucessfully created OGG Agent instance.

14、agent31上修改agent配置文件

[oracle@ORACLEDG31 ogg_agent]$ cd /u01/app/Oracle/Middleware/Oracle_Home/oggmon/agent1/cfg/

[oracle@ORACLEDG31 cfg]$ vim Config.properties

[oracle@ORACLEDG31 cfg]$ grep -v ^# Config.properties | grep -v ^$

jagent.host=192.168.10.31

jagent.jmx.port=5555

interval.regular=60

interval.quick=30

monitor.host=192.168.36.31

monitor.jmx.port=5502

monitor.jmx.username=jmxuser

jagent.username=jagent31

reg.retry.interval=10

instance.query.initial.interval=5

incremental.registration.quiet.interval=5

maximum.message.retrieval=500

jagent.rmi.port=5559

agent.type.enabled=OGGMON

status.polling.interval=5

message.polling.interval=5

reg.retry.times=-1

jagent.backward.compatibility=false

jagent.ssl=false

jagent.keystore.file=jagentKeyStore

jagent.truststore.file=jagentKeyStore

jagent.restful.ws.timeout=15000

jagent.ggsci.timeout=30

15、agent31上创建agent Wallet Credentials

server上通过ftp上传属性文件

[oracle@D2-OGGM31 cfg]$ cd /u01/app/Middleware/Oracle_Home/user_projects/domains/oggmon1221_domain/config/monitorserver/cfg/

agent31上通过ftp下载属性文件

[oracle@ORACLEDG31 cfg]$ cd /u01/app/Oracle/Middleware/Oracle_Home/oggmon/agent1/cfg/

或者使用scp进行拷贝。

[oracle@ORACLEDG31 cfg]$ cd /u01/app/Oracle/Middleware/Oracle_Home/oggmon/agent1/bin/

[oracle@ORACLEDG31 bin]$ ./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:

Mar 14, 2017 10:58:43 AM oracle.security.jps.JpsStartup start

INFO: Jps initializing.

Mar 14, 2017 10:58:46 AM oracle.security.jps.JpsStartup start

INFO: Jps started.

Wallet is created successfully.

以上密码全部是：Aaaa1111

16、agent31上启动Monitor Agent

[oracle@ORACLEDG31 bin]$ cd /u01/app/goldengate/

[oracle@ORACLEDG31 goldengate]$ echo "ENABLEMONITORING" >> GLOBALS

[oracle@ORACLEDG31 goldengate]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38

Operating system character set identified as UTF-8.

GGSCI (ORACLEDG31) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

JAGENT STOPPED

EXTRACT RUNNING ADG_DP1 00:00:05 00:00:08

EXTRACT RUNNING ADG_EXT1 00:00:04 00:00:02

GGSCI (ORACLEDG31) 2> stop adg_dp1

Sending STOP request to EXTRACT ADG_DP1 ...

Request processed.

GGSCI (ORACLEDG31) 3> stop adg_ext1

Sending STOP request to EXTRACT ADG_EXT1 ...

Request processed.

GGSCI (ORACLEDG31) 4> stop mgr

Manager process is required by other GGS processes.

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

Sending STOP request to MANAGER ...

Request processed.

Manager stopped.

GGSCI (ORACLEDG31) 5> info datastore

2017-03-14T03:03:41Z INFO OGG-06309 Datastore uses shared memory (SHM) environment files with a starting ID of 0x00002080.

GGSCI (ORACLEDG31) 6> start mgr

Manager started.

GGSCI (ORACLEDG31) 7> start adg_ext1

Sending START request to MANAGER ...

EXTRACT ADG_EXT1 starting

GGSCI (ORACLEDG31) 8> start adg_dp1

Sending START request to MANAGER ...

EXTRACT ADG_DP1 starting

GGSCI (ORACLEDG31) 9> start jagent

Sending START request to MANAGER ...

GGCMD JAGENT starting

GGSCI (ORACLEDG31) 10> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

JAGENT RUNNING

EXTRACT RUNNING ADG_DP1 00:00:00 00:00:00

EXTRACT RUNNING ADG_EXT1 00:00:55 00:00:01

查看，可以了。

17、agent38上安装monitor agent

需要先安装JDK

[oracle@D2-BOPRO38 ~]$ tar -xvzf jdk-8u51-linux-x64.tar.gz

[oracle@D2-BOPRO38 ~]$ tail -4 .bash_profile

export JAVA_HOME=/home/oracle/jdk1.8.0_51

export JRE_HOME=${JAVA_HOME}/jre

export CLASSPATH=.:%{JAVA_HOME}/lib:%{JRE_HOME}/lib

export PATH=${JAVA_HOME}/bin:$PATH

[oracle@D2-BOPRO38 ~]$ source .bash_profile

[oracle@D2-BOPRO38 ~]$ java -version

java version "1.8.0_51"

Java(TM) SE Runtime Environment (build 1.8.0_51-b16)

Java HotSpot(TM) 64-Bit Server VM (build 25.51-b03, mixed mode)

安装agent

[oracle@D2-BOPRO38 ~]$ unzip V78177-01.zip

[oracle@D2-BOPRO38 ~]$ export DISPLAY=192.168.17.100:0.0

[oracle@D2-BOPRO38 ~]$ java -jar fmw_12.2.1.0.0_ogg.jar

18、agent38上创建agent 实例

[oracle@D2-BOPRO38 ~]$ mkdir -p /u01/app/Oracle/Middleware/Oracle_Home/oggmon/agent1

[oracle@D2-BOPRO38 ~]$ cd /u01/app/Oracle/Middleware/Oracle_Home/oggmon/ogg_agent/

[oracle@D2-BOPRO38 ogg_agent]$ ./createMonitorAgentInstance.sh

Please enter absolute path of Oracle GoldenGate home directory : /u01/app/goldengate/

Please enter absolute path of OGG Agent instance : /u01/app/Oracle/Middleware/Oracle_Home/oggmon/agent1/

Please enter unique name to replace timestamp in startMonitorAgent script (startMonitorAgentInstance_20170322161033.sh) : 01

Sucessfully created OGG Agent instance.

19、agent38上修改agent配置文件

[oracle@D2-BOPRO38 ogg_agent]$ cd /u01/app/Oracle/Middleware/Oracle_Home/oggmon/agent1/cfg/

[oracle@D2-BOPRO38 cfg]$ vim Config.properties

[oracle@D2-BOPRO38 cfg]$ grep -v ^# Config.properties | grep -v ^$

jagent.host=192.168.12.38

jagent.jmx.port=5555

interval.regular=60

interval.quick=30

monitor.host=192.168.36.31

monitor.jmx.port=5502

monitor.jmx.username=jmxuser

jagent.username=jagent38

reg.retry.interval=10

instance.query.initial.interval=5

incremental.registration.quiet.interval=5

maximum.message.retrieval=500

jagent.rmi.port=5559

agent.type.enabled=OGGMON

status.polling.interval=5

message.polling.interval=5

reg.retry.times=-1

jagent.backward.compatibility=false

jagent.ssl=false

jagent.keystore.file=jagentKeyStore

jagent.truststore.file=jagentKeyStore

jagent.restful.ws.timeout=15000

jagent.ggsci.timeout=30

20、agent38上创建agent Wallet Credentials

server上通过ftp上传属性文件

[oracle@D2-OGGM31 cfg]$ cd /u01/app/Middleware/Oracle_Home/user_projects/domains/oggmon1221_domain/config/monitorserver/cfg/

agent38上通过ftp下载属性文件

[oracle@D2-BOPRO38 cfg]$ cd /u01/app/Oracle/Middleware/Oracle_Home/oggmon/agent1/cfg/

或者使用scp进行拷贝。

[oracle@D2-BOPRO38 cfg]$ cd /u01/app/Oracle/Middleware/Oracle_Home/oggmon/agent1/bin/

[oracle@D2-BOPRO38 bin]$ ./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:

Mar 14, 2017 10:58:43 AM oracle.security.jps.JpsStartup start

INFO: Jps initializing.

Mar 14, 2017 10:58:46 AM oracle.security.jps.JpsStartup start

INFO: Jps started.

Wallet is created successfully.

密码全部是：Aaaa1111

21、agent38上启动Monitor Agent

[oracle@D2-BOPRO38 bin]$ cd /u01/app/goldengate/

[oracle@D2-BOPRO38 goldengate]$ echo "ENABLEMONITORING" >> GLOBALS

[oracle@D2-BOPRO38 goldengate]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38

Operating system character set identified as UTF-8.

GGSCI (D2-BOPRO38) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

JAGENT STOPPED

REPLICAT RUNNING ADG_RP1 00:00:00 00:00:05

REPLICAT RUNNING ADG_RP2 00:00:00 00:00:05

GGSCI (D2-BOPRO38) 2> info datastore

2017-03-22T08:19:31Z INFO OGG-06309 Datastore uses shared memory (SHM) environment files with a starting ID of 0x00005180.

GGSCI (D2-BOPRO38) 3> stop adg_rp1

Sending STOP request to REPLICAT ADG_RP1 ...

STOP request pending end-of-transaction (37 records so far)..

GGSCI (D2-BOPRO38) 4> stop adg_rp2

Sending STOP request to REPLICAT ADG_RP2 ...

Request processed.

GGSCI (D2-BOPRO38) 5> stop mgr

Manager process is required by other GGS processes.

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

Sending STOP request to MANAGER ...

Request processed.

Manager stopped.

GGSCI (D2-BOPRO38) 6> start mgr

Manager started.

GGSCI (D2-BOPRO38) 7> start adg_rp1

Sending START request to MANAGER ...

REPLICAT ADG_RP1 starting

GGSCI (D2-BOPRO38) 8> start adg_rp2

Sending START request to MANAGER ...

REPLICAT ADG_RP2 starting

GGSCI (D2-BOPRO38) 9> start jagent

Sending START request to MANAGER ...

GGCMD JAGENT starting

GGSCI (D2-BOPRO38) 10> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

JAGENT RUNNING

REPLICAT RUNNING ADG_RP1 00:00:00 00:00:05

REPLICAT RUNNING ADG_RP2 00:00:00 00:00:00

查看，可以了。

Oracle GoldenGate Monitor安装配置