Oracle Enterprise Manager 12c and pending Oracle GoldenGate status

I’ve been working with a customer for the last month or so.  They have implemented Oracle Enterprise Manager and looking to move all their monitoring into Oracle Enterprise Manager Smile .  This is a good thing and I’ve been working on getting them moved over.  One thing they would like moved into Oracle Enterprise Manager is their Oracle GoldenGate monitoring. 

Note: I previously wrote a post on how to configure monitoring for Oracle GoldenGate in OEM12c, check it out here.

After I’ve identified everything, the next thing I needed to do was configure monitoring for Oracle GoldenGate (here).  Once configured, I started to receive pending status for all the processes.  Normally, I wouldn’t be concern about this because is could take the EM Agent a few minutes to get the information from the JAgent and send it to Oracle Enterprise Manager. 

image

After sometime, these pending statuses started to bug me.  After checking the emagent and the jagent, I determined that everything was working and reporting as expected.  So what is the problem?  I looked in the jagent.log and found the following warning:

WARN  Capture – Error in getAttribute: No Object with localId found: :type=capture,name=

Searching MOS, the problem turned out to be a bug (Bug 14244174).  This bug is specific to the GoldenGate Plug-In registered instances stuck in a pending status.  The bug is also associated with the using Oracle GoldenGate (11.2.1.0.1) with OEM12c (yet another reason to stay on the most current release of Oracle GoldenGate).

Now that I’ve established that this is a bug and that I cannot upgrade until the customer oks the process; how do I get past this for reporting in OEM12c?  Fortunately, I found a MOS Note (1487633.1) that will help in working around the issue. 

The solution presented in MOS Note 1487633.1 is actually simple, but requires that  the specific order outlined in the note.  Once all the steps are complete, the  Oracle GoldenGate objects will respond with their status.

Note: Being that this is Oracle GoldenGate (11.2.1.0.1), OEM reports that the status for downed extract and replicats are up.  This issue is more than likely fixed once upgraded passed 11.2.1.0.10+.

Steps:

Now, how to resolve this issue?  Below are the steps that are outlined in the MOS Note.  I have performed theses steps and verified that they worked in resolving the pending status problem.

1. Login to ggsci prompt and stop all processes
stop *
stop jagent
stop manager

2. Remove any initial load/replicats from ggsci prompt by running
info all tasks
delete replicat/extract [name]  (only needed if they are initial load extract/replicat)

3. Delete $GG_HOME/dirbdb directory.

4. Delete jagent.log and gsserr.log in $GG_HOME.

5. Login to ggsci prompt and run ‘create datastore’ command

6. Start all proceses, run
start manager
start *
start jagent

7. Login to OEM 12c -> Targets -> GoldenGate.
Set the page refresh rate to 1 minute and wait a couple of minutes, the page should show
the correct status.

Once, I have performed the steps above, within a few minutes I had all the Oracle Golden Gate processes reporting successfully.

image

Keep in mind, the other issue I had with all down processes reporting up? I get around this once the reporting started to be correct was to place the down processes in blackout mode. 

Enjoy!

twitter: @dbasolved

blog: http://dbasolved.com

About these ads

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Martins Blog

Trying to explain complex things in simple terms

Oracle Data Warrior

Changing the world, one data model at a time. How can I help you?

Maaz Anjum's Blog

A life yet to be lived...

PeteWhoDidNotTweet

Stuff that interests me, if not you!

The Oracle Instructor

Explain, Exemplify, Empower

Frits Hoogland Weblog

IT Technology; Oracle, linux, TCP/IP and other stuff I find interesting

Oracle Spin - Flimatech Blog

Sharing Our Database Experience

Oracle Scratchpad

Just another Oracle weblog

Carlos Sierra's Tools and Tips

Tools and Tips for Oracle Performance and SQL Tuning

Follow

Get every new post delivered to your Inbox.

Join 1,501 other followers

%d bloggers like this: