is too small to handle the volume of redo data, forcing the logmining server to shut down. Database Shutdown/Maintenance:
Look for surrounding messages. If you see STOP requested by user , the detachment is normal. If you see ORA- errors immediately preceding the detachment, the client detached because the database encountered an issue. Step 3: Check Database-Side Capture Status
cat $OGG_HOME/ggserr.log
In most cases, this message is a confirmation of a successful administrative action rather than an error. Here are the most common triggers: 1. Manual Stopping of the Extract is too small to handle the volume of
Scenario A: Detachment accompanied by Streams Pool Out of Memory
The message is a standard informational log entry in Oracle GoldenGate. It indicates that an Extract process (the "capture client") has cleanly disconnected from the database logmining server. Overview of the Message
This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later. If you see ORA- errors immediately preceding the
The process reached a specified end point (e.g., THREAD or EOF ) and closed safely. 🛠️ Related GGSCI Commands
Once the underlying issue (missing logs, memory, etc.) is fixed, restart the process: Oracle Help Center GGSCI> start extract [EXTRACT_NAME] Use code with caution. Copied to clipboard 4. Prevention Strategies Configure Autorestart: AUTORESTART
While this message sounds like a technical failure at first glance, it is often a routine part of the GoldenGate lifecycle. This article explores what this message means, why it occurs, and when you should actually be concerned. What Does This Message Mean? Manual Stopping of the Extract Scenario A: Detachment
Once you've identified a potential root cause, follow the appropriate resolution path.
The command STOP EXTRACT hangs for a long time before finally printing the successful detachment message.