Ogg Capture Client Successfully Detached From Goldengate Capture ((better))

This message indicates that an Oracle GoldenGate (OGG) Extract process has successfully disconnected from the source database. đź“Ś Meaning of the Message

Successful shutdown: The Extract process was stopped normally by a user or script.

Database disconnection: The GoldenGate capture client detached cleanly from the Oracle database.

No action required: This is an informational message (INFO), not an error. 🔍 Common Causes This message indicates that an Oracle GoldenGate (OGG)

Manual Stop: An administrator issued the STOP EXTRACT command.

System Maintenance: The GoldenGate instance or the source database was being restarted.

Graceful Exit: The process reached a specified end point (e.g., THREAD or EOF) and closed safely. 🛠️ Related GGSCI Commands What happens behind the scenes:

To check the current status or restart the process, use these commands in the GGSCI or Admin Client console: View status: STATUS EXTRACT Start process: START EXTRACT View logs: VIEW REPORT đź’ˇ Best Practices

Verify state: Ensure the extract is in a STOPPED state and not ABENDED.

Check alert logs: If this happened unexpectedly, review the GoldenGate ggserr.log for preceding events. The Extract finishes processing the current batch of

Scenario 1: Manual Stop of the Extract (Most Common)

A DBA runs the command:

STOP EXTRACT ext_capture

What happens behind the scenes:

  1. The Extract finishes processing the current batch of transactions.
  2. It sends a DETACH request to the LogMining Server.
  3. The LogMining Server acknowledges the clean disconnection.
  4. Log Entry: OGG capture client successfully detached...

Conclusion: This is entirely normal. You will always see this message when you manually stop a running Integrated Extract.

Step 1: Check the Extract Status

ggsci> INFO EXTRACT <extract_name>

7. Related Messages

| Message ID | Text | |------------|------| | OGG-00998 | Capture client failed to attach | | OGG-00999 | Capture client detached (this message) | | OGG-00446 | Network read failure (often precedes detach) | | OGG-01296 | Capture client process died unexpectedly |