Ogg Capture Client Successfully Detached From Goldengate Capture [updated]
in your database alert logs or GoldenGate report files can be alarming, but it is often a routine part of the process lifecycle. The Core Mechanism This message is generated by the
This is typically and not an error. It means:
Because Integrated Capture runs inside the database, check the database dictionary views to see the status of the GoldenGate capture processes from the database perspective. Run the following queries as a DBA user: in your database alert logs or GoldenGate report
When the Extract process stops, restarts, or loses its connection to the database instance, the database registers that the external client has severed its link. It then writes the "successfully detached" message to the database alert log or the GoldenGate error log to confirm a clean teardown of that specific session. 2. Common Scenarios That Trigger This Log Entry
Check the Status . A STOPPED status might be normal if you issued a stop. An ABENDED status indicates a problem. Look specifically for any mention of ; if this is increasing and the process is not running, you have a problem. Run the following queries as a DBA user:
Sometimes the database side of the capture engine stalls or fails. You can check the health of the deployment's database components by running this SQL query as a DBA:
: If an Extract process fails due to an error (e.g., ORA-03113 or OGG-02028), the logs will show this detachment as the process terminates. Common Scenarios That Trigger This Log Entry Check
If it transitions back to a RUNNING state and begins checkpointing, the detachment was likely a transient issue.
And then, the log spits out the message.
This is healthy behavior for a controlled environment shutdown.