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 
. 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.
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.
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
Please follow and like:
Current Oracle Certs
Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.
Follow if you like:
With one thoughtOnly one thought in his mindTo overcome the dullness of his life
I’ve never experienced your ways of being
So sharp, so real, so goodSomething new I’m excited aboutOutroDreams only occur when you’re sleeping
Reach out and reveal a part of youVerse 2Intentions always start with a touch
Simple PleasuresVerse 1Oh, a strangerA stranger in the nightVenturing into an unfamiliar place
Where are you from?Why are you here?
Why are you here?Verse 2You’re confidently aware of who you are
With another strangerExcitement can be elusive and fleetingThe element of surprise
I’ve never experienced your ways of being
The motions we make against the backdrop of timeResonate along the touch of our skin
I’ll use what I have and you’ll do the sameI like how you thinkYour ideas are refreshingly bold
I’ve never experienced your ways of being
Nothing ventured, nothing gainedBridge 1Transform yourself into an adventure
The motions we make against the backdrop of timeResonate along the touch of our skin
And they make me believe in who you areWhen you decide on somethingYou act swiftly
And they make me believe in who you areWhen you decide on somethingYou act swiftly
Ensuring the security of your house is essential in today’s uncertain times. One of the best ways to protect your assets and sense of security is by putting resources in a trustworthy safe. No matter whether you’re safeguarding funds, crucial records, or treasured heirlooms, a safe offers a secure storage solution.
When it comes to choosing the right safe for your residence, there are numerous aspects to take into consideration. Primarily, consider your protection necessities. Establish what belongings you intend to store in the safe and the degree of security required for every item.
Next, think about the size and placement of the safe. Choose a safe that matches conveniently in your home while offering ample storage for your valuables. Ensure that the safe can be placed in a safe location, such as for instance screwed to the floor or wall.
Furthermore, look into the protective elements of the safe. Seek out attributes such as solid construction, dependable locking mechanisms, and fireproof materials. Consider putting resources in a safe with additional safety features, such as for instance biometric fingerprint scanners or electronic keypads.
Finally, don’t forget to factor in your budget when picking a safe. Fix a realistic budget based on your protection necessities and compare prices for alternatives that fit within your budgetary constraints.
Ultimately, selecting the correct safe for your house is crucial for keeping your belongings protected. By evaluating your protection necessities, thinking about the size and placement of the safe, inspecting security features, and fixing a financial plan, you can secure ultimate protection for your important possessions.
https://mercurylock.com/contact
And what you wish to attainYour soothing energy spills directly into me
And what you wish to attainYour soothing energy spills directly into me