It is amazing what Oracle Enterprise Manager 12c will report once it is configured for a product. Once such product is Oracle GoldenGate. I have stepped into a project where I’m running Oracle GoldenGate between many different environments for production purposes. Just trying to get a handle around what is going on has been a task. In talking with the customer, they were starting to implement Oracle Enterprise Manager 12c. Once OEM was setup, we added the Oracle GoldenGate plug-in and started to monitor the replication environments.
Monitoring the Oracle GoldenGate environments, I noticed a warning in the Incident Manager. The warning that was noticed was: “Status for Streams process OGG$_CGGMONX9AC55691 is DISABLED”. I got to thinking, what is this message about? Much more, how do I resolve this warning (I like OEM to be quite. I started to look around MOS for answers, to my surprise, not much is written about his message.
Oracle GoldenGate, classic capture, doesn’t report these types of messages within Oracle Enterprise Manager 12c. Classic Capture mostly reports the up and down status of Oracle GoldenGate processes. This message had to be coming from some integrated version of the extract (first clue was the word Streams). Keeping that Streams may be used in some way, the DBA_CAPTURE table should be able to shine a bit of light on this warning.
From a SQL*Plus prompt or an SQL IDE (prefer SQL Developer), the DBA_CAPTURE view can be queried.
From looking at the STATUS column, I verified that I’ve found the correct record. The PURPOSE column shows that this extract (capture) is being used for Streams. What!?, wait a minute, I’m using Oracle GoldenGate.
Yes, Oracle GoldenGate is being used. If there is information in the DBA_CAPTURE view it is because the Extract has been registered (integrated) with the database some how. The status is DISABLED, an indicator that this extract was registered for logretention:
GGSCI> stop extract cggmonx
GGSCI> dblogin userid ggate password ggate
GGSCI> register extract cggmonx logretention
GGSCI> start extract cggmonx
Now, that it is understood that the extract has been registered for log retention, what does this actually mean?
According to the Oracle GoldenGate 11g Reference Guide, an extract can be registered in one of two modes.
1. Database – Enables integrated capture for the Extract group. In this mode,
Extract integrates with the database logmining server to receive
change data in the form of logical change records (LCR). Extract
does not read the redo logs. Extract performs capture processing,
filtering, transformation, and other requirements
2. Logretention – Enables an Extract group, classic capture mode, to work with
Oracle Recovery Manager (RMAN) to retain the logs that Extract
needs for recovery
As indicated a few lines up, this extract has been registered with logretention. This means that the extract creates an underlying Streams capture process and prevents RMAN from removing any archivelogs that may be needed for replication of data. As part of creating the underlying Streams structure, Oracle creates a queue under the Oracle GoldenGate owner (The queue name can also be found in the DBA_CAPTURE view).
Now that the root problem of the DISABLE message in Oracle Enterprise Manager 12c has been identified, how can this message be resolved?
The simplest way is to unregister the extract from the database/logretention knowing that Oracle GoldenGate configuration is using Classic Capture. Keep in mind that when unregistering the extract, retention of archivelogs will not be enforced when RMAN backs them up and possibility removes them. Make sure you RMAN retention policies are what you expect them to be.
To unregister an extract that is using logretention, use the steps below:
GGSCI> stop extract cggmonx
GGSCI> dblogin userid ggate password ggate
GGSCI> unregister extract cggmonx logretention
GGSCI> start extract cggmonx
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:
Nice Article
I do agree with all the ideas you have introduced on your post They are very convincing and will definitely work Still the posts are very short for newbies May just you please prolong them a little from subsequent time Thank you for the post
wonderful put up, veery informative. I wonder why the other specialists of thiss
srctor do not realize this. You must continue your writing.
I’m confident, you’ve a great readers’ base already! http://Boyarka-Inform.com/
The other day, while I was at work, mmy cousin stolke my applle ipad and tested
to see if it can survive a thirty foot drop, just
so she can be a youtube sensation. My iPaad is now destroyed and she has 83 views.
I know this is totally off topic but I had to share it with someone!
Also visit my webpage: Başakşehi̇r evden eve nakli̇yat
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
I constantly spent my half an hour to read this
blog’s content every day along with a cup of coffee.
my blog; Samsun Ferroli servisi
Heya i’m for the primary time here. I came across this board
and I best plastic surgery in turkey finding It really helpful &
it helped me ouut a lot. I am hoping to provide something again and
help others like you helped me.
Espectro de vibracion
Aparatos de ajuste: fundamental para el operación suave y óptimo de las dispositivos.
En el entorno de la innovación actual, donde la efectividad y la estabilidad del equipo son de alta relevancia, los sistemas de equilibrado desempeñan un tarea esencial. Estos dispositivos especializados están creados para balancear y regular elementos dinámicas, ya sea en herramientas de fábrica, vehículos de desplazamiento o incluso en aparatos hogareños.
Para los especialistas en mantenimiento de aparatos y los técnicos, trabajar con dispositivos de calibración es importante para promover el rendimiento suave y estable de cualquier mecanismo dinámico. Gracias a estas opciones innovadoras innovadoras, es posible disminuir notablemente las movimientos, el zumbido y la presión sobre los rodamientos, mejorando la longevidad de piezas costosos.
Igualmente relevante es el tarea que cumplen los equipos de ajuste en la atención al usuario. El soporte experto y el soporte constante utilizando estos equipos permiten proporcionar servicios de gran nivel, aumentando la bienestar de los compradores.
Para los titulares de negocios, la contribución en unidades de balanceo y detectores puede ser fundamental para incrementar la efectividad y desempeño de sus dispositivos. Esto es principalmente importante para los emprendedores que gestionan medianas y medianas empresas, donde cada aspecto cuenta.
Por otro lado, los dispositivos de equilibrado tienen una vasta uso en el sector de la prevención y el monitoreo de nivel. Facilitan encontrar potenciales errores, evitando intervenciones elevadas y averías a los dispositivos. Además, los información generados de estos dispositivos pueden aplicarse para perfeccionar métodos y mejorar la exposición en plataformas de exploración.
Las zonas de uso de los aparatos de ajuste abarcan múltiples sectores, desde la fabricación de transporte personal hasta el seguimiento ecológico. No importa si se refiere de extensas fabricaciones manufactureras o limitados espacios de uso personal, los equipos de ajuste son fundamentales para asegurar un desempeño productivo y sin riesgo de detenciones.
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?
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.
Everything is very open with a precise description of the challenges. It was really informative. Your website is extremely helpful. Thank you for sharing.
This blog was… how do I say it? Relevant!! Finally I’ve found something which helped me. Thanks!
Good write-up, I am normal visitor of one’s site, maintain up the nice operate, and It’s going to be a regular visitor for a lengthy time.
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.
Unexpectedly lost your balance on your QIWI wallet?
We understand how disheartening that can be.
Stay calm—our company specializes in getting
back your balance from QIWI wallets.
With years of experience, we’re positive we can help out.
Get in touch and let’s begin of getting your
money back.
These windows are often patterned with fleur de lys and different floral motifs that had been suited to the shape of the diamond panes.
Have you lost money on your QIWI wallet?
We understand how frustrating that can be.
Stay calm—we specializes in getting back your balance
from QIWI wallets.
With years of experience, we’re positive we can help out.
Reach out to us and let’s start the process of restoring
your balance.
Overwhelmed by how to proceed with recovery of your QIWI wallet funds?
Our customer support are ready around the clock to guide
you through the process and respond to any queries you
might have.
With us, you’re choosing a trusted helper in reclaiming your assets.
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article. https://accounts.binance.com/pt-PT/register?ref=IJFGOAID
Very well written story. It will be beneficial to anyone who utilizes it, including me. Keep doing what you are doing – can’r wait to read more posts.
Madurai is one among the many necessary pilgrimage cities in south India and is thought for its Meenakshi Temple.
I am genuinely pleased to read this webpage posts whichcontains lots of useful facts, thanks for providing these kinds ofstatistics.