Goldengate Monitor v11.1

JAVA version more than 1.6 can be

[Email protected] ~]# RPM-IVH jre-8u65-linux-x64.rpm

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

1:jre1.8.0_65 ########################################### [100%]

Unpacking JAR files ...

Plugin.jar ...

Javaws.jar ...

Deploy.jar ...

Rt.jar ...

Jsse.jar ...

Charsets.jar ...

Localedata.jar ...

Jfxrt.jar ...

Add Java environment variables to Oracle User: (because I installed OGG with Oracle user)

Export PATH

Export Oracle_base=/u01/app/oracle

Export Oracle_home=/u01/app/oracle/product/11.2.0/db_1

Export Oracle_sid=phub

Export path= $ORACLE _home/bin: $PATH

Export Ld_library_path= $ORACLE _home/lib:/lib:/usr/lib

Export classpath= $ORACLE _home/jre: $ORACLE _home/jlib: $ORACLE _home/rdbms/jlib

Export display=:0.0

umask=022

Alias sqlplus= ' Rlwrap sqlplus '

Alias rman= ' Rlwrap Rman '

Alias ggsci= ' Rlwrap Ggsci '

Export Path=/u01/ogg: $PATH

Export Ld_library_path=/u01/ogg: $LD _library_path

Export Ggate=/u01/ogg

Export java_home=/usr/java/jre1.8.0_65

Path= $PATH: $HOME/bin: $JAVA _home/jre/bin

SOURCE side:

Ggsci (Cwogg) 6> view params./globals

Ggschema ogg

Enablemonitoragent

Target side

Ggsci (OGG1) 3> view params./globals

Ggschema ogg

Checkpointtable ogg. Ckpt_table

Enablemonitoragent

# Cd/u01/ogg

To edit the Config.properties, modify the following:

SOURCE Library:

Vim/u01/ogg/cfg/config.properties

jagent.host=172.16.30.227

monitor.host=172.16.30.228

Monitor.jmx.username=jmxuser

Target Library:

Vim/u01/ogg/cfg/config.properties

jagent.host=172.16.30.226

monitor.host=172.16.30.228

Monitor.jmx.username=jmxuser

Configure OGG Wallet

Source-side Configuration

[Email protected] ogg]$./pw_agent_util.sh-create

Please create a password for Java Agent:

Confirm Password for Java Agent:

Please enter Monitor Server JMX password:

Please confirm Monitor Server JMX Password:

Wallet is created successfully. password 123123, where the password and installation time set the JMX password consistent.

Target-side configuration:

[Email protected] ogg]$./pw_agent_util.sh-create

Please create a password for Java Agent:

Confirm Password for Java Agent:

Please enter Monitor Server JMX password:

Please confirm Monitor Server JMX Password:

Wallet is created successfully.

Start Target End JAGETN:

Ggsci (OGG1) 2> start jagent

Ggcmd Jagent started

Ggsci (OGG1) 3> info All

Program Status Group lags at chkpt time Since chkpt

MANAGER RUNNING

Jagent RUNNING

Replicat RUNNING REP1 00:00:00 00:00:02

Ggsci (OGG1) 4> 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, x64, 64bit (optimized) on APR 23 2012 04:41:46

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

Starting at 2015-10-28 10:15:23

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

Operating System Version:

Linux

Version #1 SMP Wed Feb 17:37:40 EST., Release 2.6.32-300.10.1.el5uek

Node:ogg1

Machine:x86_64

Soft Limit Hard Limit

Address Space Size:unlimited Unlimited

Heap Size:unlimited Unlimited

File Size:unlimited Unlimited

CPU Time:unlimited Unlimited

Process id:13462

Parameters ...

COMMAND java-jar-xms64m-xmx512m Dirjar/jagent.jar

Program was ' Java ', arguments is '-jar-xms64m-xmx512m dirjar/jagent.jar '

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

* * Run Time Messages * *

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

2015-10-28 10:15:23 INFO OGG-00978 ggcmd jagent is running.

2015-10-28 10:15:23 INFO OGG-01927 child process started, process ID 13466, command line ' java-jar-xms64m-xmx512m Dirjar/jage

Nt.jar '

Source-side Boot jagent:

Ggsci (Cwogg) 2> start jagent

Ggcmd Jagent started

Ggsci (cwogg) 3> info All

Program Status Group lags at chkpt time Since chkpt

MANAGER RUNNING

Jagent RUNNING

EXTRACT RUNNING EXT1 00:00:00 00:00:05

Ggsci (Cwogg) 4> 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, x64, 64bit (optimized) on APR 23 2012 04:41:46

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

Starting at 2015-10-28 10:16:58

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

Operating System Version:

Linux

Version #1 SMP Wed Feb 17:37:40 EST., Release 2.6.32-300.10.1.el5uek

Node:cwogg

Machine:x86_64

Soft Limit Hard Limit

Address Space Size:unlimited Unlimited

Heap Size:unlimited Unlimited

File Size:unlimited Unlimited

CPU Time:unlimited Unlimited

Process id:26094

Parameters ...

COMMAND java-jar-xms64m-xmx512m Dirjar/jagent.jar

Program was ' Java ', arguments is '-jar-xms64m-xmx512m dirjar/jagent.jar '

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

* * Run Time Messages * *

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

2015-10-28 10:16:58 INFO OGG-00978 ggcmd jagent is running.

2015-10-28 10:16:58 INFO OGG-01927 child process started, process ID 26114, command line ' java-jar-xms64m-xmx512m

Dirjar/jagent.jar '.

After completion the discovery interface has not been displayed:

Jagent.log error is as follows:

2015-10-28 11:21:22 [main] INFO jagentwsmain-about to call initialize on the WebService

2015-10-28 11:21:22 [main] INFO agentinfoimpl-using IP address 172.16.30.226 to connect to the Manager Web Service

2015-10-28 11:21:22 [main] INFO agentinfoimpl-reading Manager port 7500 from MGR.PRM file.

2015-10-28 11:21:23 [main] INFO managerfacadeimpl-metadata initialized

2015-10-28 11:21:23 [main] INFO jagentdigestmd5jmxfactory-starting JMX connector server on port 5555

2015-10-28 11:21:23 [main] INFO Jagentwsmain-jagent finished initialization.

2015-10-28 11:21:23 [Managerconnectionkeeper] INFO managerwsapi-created WSAPI

2015-10-28 11:21:28 [getinstancelist] ERROR Managerwsadapter- Com.goldengate.monitor.model.AgentCommunicationException:Failed to get Registry.

2015-10-28 11:21:28 [getinstancelist] ERROR managerfacadeimpl-instance List returned from JNI call is null

2015-10-28 11:21:28 [getinstancelist] ERROR mbeanscontainerimpl-unexpected behavior, no agent object found! Jagent'll exit!

2015-10-28 11:21:28 [getinstancelist] INFO mbeanscontainerimpl-jagent mode:monitor-integrated

2015-10-28 11:21:28 [main] WARN jagentwsmain-no Agent Mbean found, exit with error code 1

2015-10-28 11:21:28 [main] INFO Jagentwsmain-jagentwsmain is about-terminate its operation

2015-10-28 11:21:28 [agentregistration] WARN Mbeanscontainerimpl-agentmbean is null

For the 11.2.1 version of jagent need to deploy monitoring agent on the server to create a local datastore under Ogg, or even in Ggsci after starting the jagent jagent boot success, and the status is running, but in the server-side web interface does not see the host Plus The Jagent.log in the Ogg installation directory will report similar errors:

The cause of this problem is that the proxy does not have a local datastore, and the proxy side creates the Datastore

Ggsci (OGG1) 2> Create Datastore

Datastore created

Ggsci (OGG1) 3> stop jagent

Jagent process is required by other GGS processes.

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

Sending STOP request to Ggcmd jagent ...

Request processed.

Jagent stopped.

Ggsci (OGG1) 7> start jagent

Ggcmd Jagent started

Ggsci (OGG1) 8> info All

Program Status Group lags at chkpt time Since chkpt

MANAGER RUNNING

Jagent RUNNING

Replicat RUNNING REP1 00:00:00 00:00:10

On the Web monitoring page, you can see:

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/74/FD/wKiom1YwSLLBTr0cAAVTSf8iZ6w753.jpg "title=" Untitled. png "alt=" wkiom1ywsllbtr0caavtsf8iz6w753.jpg "/>

Goldengate Monitor v11.1