Infrastructure at your Service

Daniel Westermann

Oracle OGG JAGENT 12.2 installation for GoldenGate monitoring using the Cloud Control plugin

This post is mainly for self documentation as I have to search my old notes every time I want to do this (I am faster by searching on our blog 🙂 ): If you want to monitor GoldenGate with Cloud Control using the GoldenGate plugin you’ll have to install the JAGENT on the host where GoldenGate is running on and the documentation is not quite clear on what you have to do exactly (at least when you want to use the silent installation). This is what you need to do for 12.2:

Download “Oracle GoldenGate Monitor 12.2.1.2.0” from here. You need to have Java 8 installed (Oracle version, not openjdk) on the server you want to install the JAGENT on. You can download it from here.

Once you have Java 8 installed create a response file like this:

[email protected]:/var/tmp/ [rdbms12102] cat oggmon.rsp 
#DO NOT CHANGE THIS.
Response File Version=1.0.0.0.0
[GENERIC]
#The oracle home location. This can be an existing Oracle Home or a new Oracle Home
ORACLE_HOME=/u01/app/ogg/product/agent/12.2.1.2.0
INSTALL_TYPE=GoldenGate Monitor Agent Installation

Then you are ready to install:

[email protected]:/var/tmp/ [rdbms12102] /usr/java/jdk1.8.0_131/bin/java -jar fmw_12.2.1.2.0_ogg.jar -silent -responseFile /var/tmp/oggmon.rsp  

The result when everything went fine:

Launcher log file is /tmp/OraInstall2017-05-03_11-00-32AM/launcher2017-05-03_11-00-32AM.log.
Extracting the installer . . . . Done
Checking if CPU speed is above 300 MHz.   Actual 2793.552 MHz    Passed
Checking swap space: must be greater than 512 MB.   Actual 3967 MB    Passed
Checking if this platform requires a 64-bit JVM.   Actual 64    Passed (64-bit not required)
Checking temp space: must be greater than 300 MB.   Actual 8719 MB    Passed

Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2017-05-03_11-00-32AM
Log: /tmp/OraInstall2017-05-03_11-00-32AM/install2017-05-03_11-00-32AM.log
Copyright (c) 2016, Oracle and/or its affiliates. All rights reserved.
Reading response file..
Skipping Software Updates
Starting check : CertifiedVersions
Expected result: One of oracle-6,oracle-7,redhat-7,redhat-6,SuSE-11,SuSE-12
Actual Result: oracle-7.3
Check complete. The overall result of this check is: Passed
CertifiedVersions Check: Success.

Starting check : CheckJDKVersion
Expected result: 1.8.0_101
Actual Result: 1.8.0_131
Check complete. The overall result of this check is: Passed
CheckJDKVersion Check: Success.

Validations are enabled for this session.
Verifying data
Copying Files
Percent Complete : 10
Percent Complete : 20
Percent Complete : 30
Percent Complete : 40
Percent Complete : 50
Percent Complete : 60
Percent Complete : 70
Percent Complete : 80
Percent Complete : 90
Percent Complete : 100

The installation of Oracle Fusion Middleware 12c GoldenGate Monitor & Veridata 12.2.1.2.0 completed successfully.
Logs successfully copied to /u01/app/oraInventory/logs.

Once installed you can proceed by creating the Agent instance:

[email protected]:/u01/app/ogg/product/agent/12.2.1.2.0/oggmon/ogg_agent/ [rdbms12102] pwd
/u01/app/ogg/product/agent/12.2.1.2.0/oggmon/ogg_agent
[email protected]:/u01/app/ogg/product/agent/12.2.1.2.0/oggmon/ogg_agent/ [rdbms12102] ./createMonitorAgentInstance.sh
Please enter absolute path of Oracle GoldenGate home directory : /u01/app/ogg/product/12.2.0.1.1/
Please enter absolute path of OGG Agent instance : /u01/app/ogg/product/12.2.0.1.1/agent_inst 
Please enter unique name to replace timestamp in startMonitorAgent script (startMonitorAgentInstance_20170503113738.sh) : 
Successfully created OGG Agent instance.

Create the wallet for the Agent:

[email protected]:/u01/app/ogg/product/12.2.0.1.1/agent_inst/bin/ [rdbms12102] pwd
/u01/app/ogg/product/12.2.0.1.1/agent_inst/bin
[email protected]:/u01/app/ogg/product/12.2.0.1.1/agent_inst/bin/ [rdbms12102] export JAVA_HOME=/usr/java/jdk1.8.0_131
[email protected]:/u01/app/ogg/product/12.2.0.1.1/agent_inst/bin/ [rdbms12102] ./pw_agent_util.sh -jagentonly
Please create a password for Java Agent: 
Please confirm password for Java Agent: 
May 03, 2017 11:46:06 AM oracle.security.jps.JpsStartup start
INFO: Jps initializing.
May 03, 2017 11:46:06 AM oracle.security.jps.JpsStartup start
INFO: Jps started.
Wallet is created successfully.

Adjust the Agent configuration file for your environment:

[email protected]:/u01/app/ogg/product/12.2.0.1.1/agent_inst/cfg/ [rdbms12102] pwd
/u01/app/ogg/product/12.2.0.1.1/agent_inst/cfg
[email protected]:/u01/app/ogg/product/12.2.0.1.1/agent_inst/cfg/ [rdbms12102] cat Config.properties | egrep -v "^#|^$"
jagent.host=localhost
jagent.jmx.port=5555
interval.regular=60
interval.quick=30
monitor.host=localhost
monitor.jmx.port=5502
monitor.jmx.username=oggmsjmxusr
jagent.username=oggmajmxusr
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=OEM
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

Make sure you change “agent.type.enabled” to “OEM”.

Enable monitoring in the GLOBALS file:

[email protected]:/var/tmp/ [OGG122] ggi

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 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.

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

GGSCI (oelogg1) 1> view params ./GLOBALS

ENABLEMONITORING

Restart ggscsi:

[email protected]:/var/tmp/ [OGG122] ggi

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 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.

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



GGSCI (oelogg1) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
JAGENT      STOPPED                                           


GGSCI (oelogg1) 2> start jagent

Sending START request to MANAGER ...
GGCMD JAGENT starting


GGSCI (oelogg1) 3> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
JAGENT      RUNNING                              

… and you’re done. Hope this helps.

4 Comments

  • Doreen says:

    Hi Dan,

    We have two Goldengate core instances running on the same host. Their Oracle Home and manager ports are all different.
    I have also tried to create two separate Goldengate monitor agent instances to monitor each GG core instance respectively. But when adding the instance to OEM, it seems we can only configure one agent per host.

    Would you have any advice?

    Thanks
    Doreen

    • Daniel Westermann says:

      Hi Doreen,

      we putted each manager on a separate VIP and then it was not an issue to monitor multiple OGG instances on one host.

      Cheers,
      Daniel

    • Bruce says:

      Hi Doreen,

      I had the same issue and found out that when you do the the auto discovery process you need update each JAgent instance config.properties with a different port number. So Jagent on instance 1 will be 5559 but jagent on instance 2 will need to be 55561 or something.
      Then you discover each one individually and modify the discovery module with the different port to discover the other.

      Good Luck!
      Bruce

  • chhavi says:

    I did all the installation and configuration as stated above, I can see Admin server and monitor server up and running and Monitor EAR in active state .Yet I am not able to open the url it says connection time out.
    http://host:7003/monitor.
    i opened up 7003 in access rule.
    Please some one could help here.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Daniel Westermann
Daniel Westermann

Principal Consultant & Technology Leader Open Infrastructure