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 . 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
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”.
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
A rush of senses collideAnd burst into our cores
Can be the beginning of joyDisappointment is always a possibilityBut as the say:
Thank you for your sharing. I am worried that I lack creative ideas. It is your article that makes me full of hope. Thank you. But, I have a question, can you help me? https://accounts.binance.com/uk-UA/register?ref=W0BCQMF1
When you undress me with your eyesWhere are you from?
Something NewVerse 1I’m liking your div chicCasually cool and mysteriously captivating
And they make me believe in who you areWhen you decide on somethingYou act swiftly
You tower over meI look up to you with such rare admirationIn your line of view
You tower over meI look up to you with such rare admirationIn your line of view
Why are you here?Verse 2You’re confidently aware of who you are
Can be the beginning of joyDisappointment is always a possibilityBut as the say:
Reach out and reveal a part of youVerse 2Intentions always start with a touch
Why are you here?Verse 2You’re confidently aware of who you are
Nothing ventured, nothing gainedBridge 1Transform yourself into an adventure
Why are you here?Verse 2You’re confidently aware of who you are
Why are you here?Verse 2You’re confidently aware of who you are
And what you wish to attainYour soothing energy spills directly into me
So sharp, so real, so goodSomething new I’m excited aboutOutroDreams only occur when you’re sleeping
Why are you here?Verse 2You’re confidently aware of who you are
So sharp, so real, so goodSomething new I’m excited aboutOutroDreams only occur when you’re sleeping
And what you wish to attainYour soothing energy spills directly into me
rReach out and grab onto something newHesitation stands in the way of boldness
When you’re sleepingWhen you’re sleepingWritten by B. (Saturday, June 14, 2014)Copyright 2014
Where are you from?Why are you here?
A rush of senses collideAnd burst into our cores
Something NewVerse 1I’m liking your div chicCasually cool and mysteriously captivating
Simple PleasuresVerse 1Oh, a strangerA stranger in the nightVenturing into an unfamiliar place
With another strangerExcitement can be elusive and fleetingThe element of surprise
Why are you here?Verse 2You’re confidently aware of who you are
You tower over meI look up to you with such rare admirationIn your line of view
When you undress me with your eyesWhere are you from?
The motions we make against the backdrop of timeResonate along the touch of our skin
Nothing ventured, nothing gainedBridge 1Transform yourself into an adventure
And what you wish to attainYour soothing energy spills directly into me
With another strangerExcitement can be elusive and fleetingThe element of surprise
You’re beautifully and incredibly inspiringChorusSo sharp, so real, so goodSomething new I’m experiencing
rReach out and grab onto something newHesitation stands in the way of boldness
When you’re sleepingWhen you’re sleepingWritten by B. (Saturday, June 14, 2014)Copyright 2014
rReach out and grab onto something newHesitation stands in the way of boldness
You tower over meI look up to you with such rare admirationIn your line of view
A rush of senses collideAnd burst into our cores
With one thoughtOnly one thought in his mindTo overcome the dullness of his life
When you undress me with your eyesWhere are you from?
I’ll use what I have and you’ll do the sameI like how you thinkYour ideas are refreshingly bold
Where are you from?Why are you here?
Reach out and reveal a part of youVerse 2Intentions always start with a touch
Where are you from?Why are you here?
Something NewVerse 1I’m liking your div chicCasually cool and mysteriously captivating
Reach out and reveal a part of youVerse 2Intentions always start with a touch
You’re blissfully satisfyingVerse 3When you reach out your handYou form a connection with meI hope it’s unbreakable
Securing the safety of your business is essential in today’s challenging marketplace. Among the most effective ways to protect your assets and monetary documents is by investing in a dependable commercial safe. Whether or not you’re storing cash, vital records, or classified data, a safe provides a necessary layer of protection for your enterprise.
When selecting a safe for commercial use, there can be multiple aspects to take into account. Above all, assess your company’s security needs. Determine precisely what items demand safeguarding and the degree of security needed.
Following, consider the capacity and kind of safe necessary for your enterprise. Opt for a safe which matches inside your enterprise’s area while offering satisfactory storage for belongings. Consider if the safe needs extra attributes such as fire resistance or water repellency.
Furthermore, inspect the protective elements of the safe. Look for attributes such as advanced locking mechanisms, heavy-duty construction, and manipulation resistance. Take into account committing in a safe with additional safety measures such as thumbprint scanners or electronic keypads.
Finally, guarantee the safe suits within your business’s budget. Fix a reasonable budget based on your safety requirements and research options that match within your budgetary constraints.
Ultimately, choosing the appropriate safe for your enterprise is critical for safeguarding your assets. By evaluating your security needs, taking into account the size and type of safe required, inspecting safety measures, and establishing a budget, you can secure optimal protection for your company.
Reliable residential gun safes in Scottsdale – https://mercurylock.com/about
When you undress me with your eyesWhere are you from?