Troubleshoot pipeline issues

Explore recommendations for troubleshooting OCI GoldenGate pipeline issues.

Enable pipeline logs

Enable or disable critical events logs for OCI GoldenGate pipelines.

To enable critical events logs:

1. On the pipeline details page, select Monitoring.

2. On the Monitoring page, scroll down to Logs.

3. In the Actions menu for Critical Events, select Enable log.

4. In the Enable log panel, complete the following fields, and then select Enable log:

   1. For Log name, enter a name for the log.

   2. From the Compartment dropdown, select the compartment in which to create the log.

   3. Select a Log group or select Create new group.

   4. Select a Log retention time.

Retrieve Initial Load log files

On a target non-Autonomous AI Database, use the following query to locate the IMPDAT*.log from the ORACLE_BASE directory.

SELECT directory_path FROM dba_directories WHERE directory_name='ORACLE_BASE'

View or copy the IMPDAT*.log from the ORACLE_BASE directory.

Collect diagnostics

Collect diagnostics to analyze or share information about your OCI GoldenGate pipeline. The diagnostics file contains discarded records, if any, for the Capture and Apply processes.

To collect diagnostics about your pipeline:

1. On the pipeline details page, from the Actions menu, select Collect diagnostics.

2. In the Collect diagnostics panel, select the compartment and bucket in which to save the diagnostics file.

3. Enter a name prefix for the diagnostics file.

4. Select Collect diagnostics.

After the collection process completes, you can download the diagnostics file from the pipeline details page.

Work requests

1. On the Pipelines page, select the pipeline you want to view the work request for.

2. On the Pipelines details page, on the navigation bar, select Work Requests.

3. In the list of Pipelines, from the Actions menu, for the pipeline you want to enable, select View details.

Work requests help you monitor long-running operations. Possible work requests that you encounter here are:

• Create

• Start

• Stop

• Update

• Delete

• Move

Review metrics

1. On the Pipelines page, select the pipeline you want to view the metrics for.

2. On the Pipelines details page, on the navigation bar, select Monitoring.

In the Oracle Cloud console, you can monitor metrics on the OCI GoldenGate pipeline details page or using the Metrics Explorer. For more information, see Oracle Cloud Infrastructure GoldenGate Metrics.