This article is about the steps which we use to monitor goldengate from OEM 12c Cloud Control.

We can monitor goldengate processes like a manager, extract and replicate and also the lag from OEM 12c cloud control.

We need three main things.

  1. Goldengate plugin to be deployed on the management server
  2. Goldengate plugin to be deployed on the management agent server(which goldengate is running)
  3. JAGENT software to be installed on server( where goldengate is running)

In this article, we will explain step by step, how to implement this.

1. DEPLOY GOLDENGATE PLUGIN ON MANAGEMENT SERVER.

Go to EXTENSIBILITY -> PLUG IN -> DEPLOY ON – > MANAGEMENT SERVER

Select ORACLE GOLDENGATE

This deployment will shut down the complete OMS  and once the plugin is deployed, it will start the OMS.

2. Deploy GG plugin on the Management Agent server( where goldengate process is running):

With this Plugin has been installed successfully. Now we will install JAGENT.

3. Install Goldengate management agent on agent server(where gg is running)

Download the software from Oracle’

Capture

NOTE – JDK version should be > = 1. 8

Unzip the software:

SET JAVA_HOME and PATH variable:

Start the installation:

 

HERE ORACLE_HOME – Location where this agent will be installed ( not the database oracle_home)

4. Create an agent instance:

5. Create an wallet:

6. Update the configuration file as below information.

Apart from the above 3 , No need to modify any other parameter in that file

7. Update GLOBALS file.

Now go to goldengate home and add keyword ENABLEMONITORING in that GLOBAL file.

8 . Restart the goldengate manager and other process and jagent

9 . Check the ggerror.log(Make sure no error reported)

Log should look like this

With this jagent setup is completed. Now we can proceed with discovering the process on OEM.

10 . Discover goldengate processes on OEM cloud control.

SETUP -> ADD TARGET -> CONFIGURE AUTO DISCOVERY

ADVANCED : DISCOVERY MODULE -> GOLDENGATE DISCOVERY

SELECT THE AGENT SERVER( Where goldengate process is running and jagent is installed):

Pass the value of jagentuser and password which we have given, while creating the wallet ( STEP 5 ) 

TARGET ON HOSTS – > DISCOVER NOW

We can the goldengate process. Now promote them.

Now we can easily monitor the goldengate process and their lag from oem 12c cloud .

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Anuradha’s LinkedIn: https://www.linkedin.com/in/dbaanuradhamudgal/

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

 

About The Author

Comments

Leave a Reply