Verify that the Logmining server is still healthy and check the database alert logs for errors related to GoldenGate or Streams. Oracle Forums -- Check capture status in the database capture_name, status, error_number, error_message dba_capture; Use code with caution. Copied to clipboard Step 3: Increase Memory (If Needed) If you see "Waiting for memory" or STREAMS_POOL errors, increase the pool size: Oracle Forums streams_pool_size = [NewSize] SCOPE=BOTH; Use code with caution. Copied to clipboard Step 4: Clean Up "Hung" Processes
OGG capture client successfully detached from GoldenGate capture. Process Termination: Extract is terminating. If the word "successfully" Verify that the Logmining server is still healthy
To ensure that "detached" always remains a benign message and never a sign of a forced disconnect, follow these best practices: Copied to clipboard Step 4: Clean Up "Hung"
The successful detachment of the OGG capture client from the GoldenGate capture process implies that: setting IGNORE_UNSUPPORTED_TABLE for table (*) Wed Oct 19
GoldenGate Capture: OGG$CAP_PEX00001. setting IGNORE_UNSUPPORTED_TABLE for table (*) Wed Oct 19 08:00:53 2016. GoldenGate Capture: Oracle Forums