Posted by: michaelverzijl | 07/11/2011

GoldenGate Monitor – Installation

On OOW 2011 I followed one session about Oracle GoldenGate Monitor. This session was a hands-on, but didn’t work well due to firewall issues.
Therefore I wanted to do a test on my own machines.

Software
For the Source and Target I installed:
Oracle GoldenGate V11.1.1.1.0 for Oracle 11g 64bit on Windows XP, 2003, 2008

For the Monitor I installed:
Oracle GoldenGate Monitor V11.1.1.1.0 on Windows (64-bit) (117 MB)

Do you have to upgrade your agents?
Yes. The agent need to be upgraded to 11.1.1.1.1 or later. This is needed because the agents need to push data to the monitor. Before agents worked on the pull mechanism.
The new Oracle GoldenGate instance include a java agent that collect information and sends this to the monitor server.

What is the GoldenGate Monitor Server?
With this tool you can monitor multiple Oracle GoldenGate instances. It’s a Java application that:

  1. Processes information from Oracle GoldenGate Monitor agents and communicates it to the web browser
  2. Manages users, history, the display of information, and notifications triggered by events

Repository for Monitor
A separate repository is needed to store information about users, groups, process status, events and other information.
This repository can be installed in:

  • Oracle 10g or Oracle 11g
  • MySQL 5.0 or MySQL 5.1
  • SQL Server 2005 or 2008

User Interface for Monitor
The user interface is web based. Only IE 7/8 and Firefox 3 are certified.

Installing Monitor

The process starts with a default screen:

Where should Oracle GoldenGate Monitor be installed?

Should a start menu shortcut be installed?

Where will the repository be installed?

Provide information to connect to repository:

Username and password (this users needs DML and DDL privledges):

The Monitor uses a Master Account. This account is the super account for Monitor:

On which port will Monitor listen?

Install Monitor as a Service?

JMX configuration for local agents:

E-Mail configuration:

SNMP server (for automatic connection to issue tracking system):

Review:

Completed:

Go to the address of GoldenGate monitor:

Log in:

Welcome to Oracle GoldenGate Monitor

Next steps:

  • Configuration
  • Create solutions
  • Add users
  • Add alerts
Advertisements

Responses

  1. […] 11g ← GoldenGate Monitor – Installation […]

  2. […] the installation and configuration, it’s time to add a […]

  3. […] you want a see screenshots of the GUI installation then Michael Verzijl has a step-by-step on his blog. However, when I came to perform my first installation I didn’t find complete instructions on […]

  4. Hi Michael,

    thanks a lot. Its a really very useful steps to implement GG monitor, reduced lot of time with help of this. i have one query , once we configured all the settings in source side instance , what are the steps we have to follow to add the replicate target side processes in to monitor? whether we have to do the same setup in target gg instance also? like source config.properties settings, enablemonitoring,wallet creation , create datastore, start jagent… etc these same things have to do in target environment? please confirm since our target host and replicat processes are not reflected in monitor web portal.

  5. Hi Michael,

    I am know how to get the url posted in:

    Thanks and regards,
    Sagar.

  6. Hi Michael,

    May I know how to do I connect to the monitor from the webpage. I am uable to connect to the monitor, when I mention the:
    http://host_name:port_number/monitor

    I am using RHEL4.

    Thanks and regards,
    Sagar

  7. hi is it possible to have a windows monitor for a unix database?


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Categories

%d bloggers like this: