Install and Configure GG Monitoring agent

In Order to monitoring GG instance form OEM, we need to install GG monitoring agent and configure. 
In this blog, we will show how to install and configure GG monitoring agent.  

Step 1: Download GG monitoring agent binary and move to the server.

[GGHOST01 ogg_monitorl $ cd /opt/app/ogg/30ftware
[GGHOST01 software) $ ls
31748559
fmw 12.2.1.2.0 ogg.jar
moniteragent.rsp
OGG Monitor 12.2.1.2.200930 Release Notes.pdf
p31748SS9 122120 Generic. zip

README . txt

fmw 12.2.1.2.0 ogg Diskl lofl.zip 

Step 2: Edit the response file moniteragent.rsp as per your environment. 

ORACLE_HOME=/opt/ app/ ogg/oggmon
INSTALL_TYPE=G01denGate Monitor Agent Installation

Step 3: Export Java Home

[GGHOST01 software) $ which java
/ usr/bin/java
[GGHOST01 software) $ export JAVA HOME=/usr/bin/java 

Step 4: Install GG Monitoring Agent 

[GGHOST01 software) $ java —jar fmw 12.2.1.2.0 ogg.jar —silent —responseFi1e /opt/app/ogg/software/moniteragent.rsp 

Launcher log file is /tmp/Ora1n3ta112021-07-22 05-06-22PM/1auncher2021-07-22 05-06-22PM.10g.
Extracting the installer . . Done

Checking if CPU speed is above 300 MHz . Actual 2900.000 MHz Passed
Checking swap space: must be greater than 512 MB.  Actual 24575 MB  Passed
Checking if this platform requires a 64—bit Actual 64 Passed (64—bit not required)
Checking temp space: must be greater than 300 MB. Actual 1770 MB Passed 

Preparing to launch the Oracle Universal Installer from /tmp/OraInsta112021—07—22 

Log: /tmp/Ora1nsta112021-07-22 05-06-22PM/insta112021-07-22 05-06-22PM.10g 

Copyright (c) 2016, Oracle and/or its affiliates. All rights reserved.
Reading response file
Skipping Software Updates
Starting check : CertifiedVersions
Expected result: One of redhat—7, redhat—6, SuSE—11, SuSE—12
Actual Result: oracle—7.7
Check complete. The overall result of this check is: Passed
CertifiedVersions Check: Success . 

Starting check : ChecküDTVersion
Expected result: 1.8.0 101
Actual Result: 1.8.0 231
Check complete. The overall result of this check is: Passed
ChecküDTVersion 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 /opt/app/oraInventory/logs.

Step 5: Apply latest Patch to the GG Monitor agent.

Step 6: Create monitoring agent instance

[GGHOST01 ogg agent) $ . / createMonitorÄgentInstance . sh 

Please enter absolute path of Oracle GoldenGate home directory : /opt/app/ogg/gghome
Please enter absolute path of OGG Agent instance : /opt/ app/ogg/gghome/oggmoniter
Please enter unique name to replace timestamp in startMonitorÄgent script (startMonitorÄgentInstance 20210722172718. sh) IstartMonitorAgentInstance gghome . sh
Successfully created OGG Agent instance . 

[GGHOST01 ogg agent) $ 

Step 7: Create Wallet and password for Monitoring agent instance 

[GGHOST01 bin) $ ./pw agent util. sh —jagentonly
Please create a password for Cava Agent :
Please confirm password for Cava Agent :
Jul 22, 2021 PM oracle . security. jpg . CpsStartup start
INFO: Cps initializing.
Jul 22, 2021 5:30:44 PM oracle . security. jpg . CpsStartup start
INFO: Cps started.
Wallet is created successfully. 

Step 8: Edit GOLBALS parameter file in GG_HOME and add ENABLEMONITORING .

[GGHOST01 ] $ cd /opt/app/ogg/gghome
cat GLOBALS
ENABLEMONITORING

Step 9: Edit cfg file for the GG monitoring agent instance. 

[GGHOST01 cfgJ$ pwd
/uO1/app/ogg/gghome/oggmoniter/cfg 

[GGHOST01 cfg)$ cat Config.properties

edit below paramter in file

jagent.jmx.port
monitor.jmx.port
jagent.user=gguser
mgr.port
jagent.rmi.port
agent.type.enabled=OEM

Step 10: Start  jagent and pmsrvr from GG prompt.

ggsci> start pmsrvr
ggsci> start jagent

Next Step will be to go to auto discovery and modify the jagent connection information and change the rmi port and jagent password. And discover and promote the first GG instance in OEM.

You can learn more about oracle database administration: 

Pro Oracle GoldenGate for the DBA

Oracle Security Tools Installation and Configuration

Expert Oracle Exadata 

Oracle Database 12c Release 2 Real Application Clusters Handbook: Concepts, Administration, Tuning & Troubleshooting

Expert Oracle RAC 12c

 ==========================================================

Please check our other blogs for GoldenGate.