How To Enable Monitoring For GoldenGate 12.3.x/18c/19c/21c "Classic" Using Oracle Enterprise Manager 13c R5+? (Doc ID 2314622.1)
APPLIES TO:
Management Pack for Oracle GoldenGate - Version 12.2.1.2.0 and later
Information in this document applies to any platform.
GOAL
How To Enable Monitoring For GoldenGate 12.3.x/18c/19c/21c "Classic" Using Oracle Enterprise Manager 13c R5+?
For monitoring GoldenGate MicroServices 12.3.x+ installations the process is very similar but there is no
OGG Monitor Agent (jagent) involved. (skip steps #3 and #4 below)
Check/search "microservice" in OGG plugin official doc
https://docs.oracle.com/en/middleware/goldengate/emplugin/13.5.1/empug/oracle-goldengate-enterprise-manager-plug-user-guide.pdf
SOLUTION
This document explains How To Enable Monitoring For GoldenGate 12.3.x/18c/19c/21c "Classic" Using Oracle Enterprise Manager 13c R5+
\1. Download
Oracle GoldenGate Plug-in for EMCC Release 13c
Available at:
[https://www.oracle.com/middleware/technologies/goldengate-downloads.html
](http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html)**NOTE:** The GoldenGate plugin for OEM can also be downloaded "ONLINE" via OEM 13c console if this
functionality is enabled.
\2. Deploy GoldenGate plugin using the steps on:
https://docs.oracle.com/en/middleware/goldengate/emplugin/13.5.1/empug/oracle-goldengate-enterprise-manager-plug-user-guide.pdf
3.1 Deploying the Plug-In
\3. Download, install and configure Oracle GoldenGate Monitor Agent 12.2.1.2.0
https://www.oracle.com/middleware/technologies/goldengate-downloads.html
- Oracle GoldenGate Monitor 12.2.1.2.0 (425 MB)
The following doc. can be used as reference:
Doc ID 2171015.1 How to install/configure Oracle GoldenGate Monitor Agent 12.2.1.x with GoldenGate "core"? [VIDEO]
NOTE:
As indicated in Doc ID 2171015.1,
ALL "datastore" commands are deprecated in Oracle GoldenGate 12.3.x and above.
If using GoldenGate 12.3.x and above then DO NOT execute delete datastore, create datastore commands shown below or you will
receive "command not found" type errors.
The command sequence to start OGG 12.3.x processes and enable monitoring are:
--------
start pmsrvr
start manager
start *
start jagent
-------
"start pmsrvr" will create and manage $OGG_HOME/dirbdb
\4. Patch OGG Monitor Agent 12.2.1.2.0 installation with
Patch 31997138 - Oracle GoldenGate Monitor 12.2.1.2.210930 (PS2 BP8) (Server+Agent)
Patch 31997138 is required so OGG Monitor Agent works correctly with GoldenGate "core" 12.3.x+
The patch README file contains installation steps/instructions.
After patch is installed, make sure to restart "jagent" process in ggsci prompt.
NOTE:
High level steps/example on how to install Patch 31997138
Assuming OGG Monitor Agent binaries are installed in /home/oracle/oggmon_agent**
then you do: (with jagent down)
-----------------
export ORACLE_HOME=/home/oracle/oggmon_agent
export PATH=$ORACLE_HOME/OPatch:$PATH
opatch lsinventory <---------- this is to confirm previous envs are setup correctly
cd 31997138 <--------- patch unzipped directory
opatch apply
**-----------------
\5. Login to OEM 13c R2 console and discover/promote the GoldenGate targets
https://
Go to
Setup (Gear icon on top toolbar) -> Add Target -> Configure Auto Discovery -> Targets on Host
Select/highlight the "Host" -> click -> Discovery Modules -> Select/Highlight GoldenGateDiscovery
click -> Edit Parameters
Enter
-------
JAgent User Name
JAgent Password
JAgent RMI Port
Jagent Host Name
Click OK
Click OK
Select/highlight the "Host" -> click -> Discover Now
After discovery procedure is finished -> click Close
Click -> xx in "Discovered Targets" column
In "Auto Discovery Results" page select the discovered GoldenGate target and click -> Promote.
You can select 1 of the targets associated with the "instance" and when you click "Promote"
it will bring up all the targets of the instance for final "Promote" click.
Once targets are promoted click -> "Close"
\6. Check the promoted targets in OEM 13c R5 console by going to
Targets -> GoldenGate
The promoted GoldenGate targets should display on the page with their correct statuses.
REFERENCES
NOTE:2171015.1 - How to install/configure Oracle GoldenGate Monitor Agent 12.2.1.x with GoldenGate "core"? [VIDEO]
