Troubleshoot using the OCI GoldenGate deployment console

You can use log files in the OCI GoldenGate deployment console to gain more insight on issues you may encounter.

Depending on the type of issue, you can start in one of two places:

  • Deployment Health issues: For health issues not caused by user action, such as stopping a critical Extract. Start troubleshooting using logs generated by the OCI GoldenGate deployment console when you create a manual backup of the deployment. You can download the backup locally, and then view logs from the backup.
  • Performance issues: You can drill down to additional details using the Diagnosis tab, Debug log, Critical Events logs, or the Performance Metrics Server to see GoldenGate metrics in real time.

Troubleshoot using the Administration Service

In the Administration Service area, you can use the following to help you troubleshoot:

  • Extract and Replicat processes:
    • Add, alter, and delete
    • Register and unregister
    • Start and stop
    • Review process information, statistics, and status, including LAG and checkpoints
    • Retrieve the report and discard files
  • Log files
    • Diagnosis for Critical Events
    • Debug Log for additional debug information
  • Configuration (parameter) files
  • Checkpoint, trace, and heartbeat tables
  • Supplemental logging for procedural replication, schema, and tables
  • Tasks, both custom and standard, such as auto-restart and purge trails
  • Credential stores
  • Add users and assign their roles

Troubleshoot using the Distribution Service

In the Distribution Service area, you can use the following to help you troubleshoot:

  • Distribution Path processes:
    • Add, alter, and delete
    • Reposition path, change filtering
    • Monitor data statistics outgoing path
  • Log files
    • Diagnosis for Critical Events
    • Debug Log for additional debug information

Troubleshoot using the Receiver Service

In the Receiver Service area, you can use the following to help you troubleshoot:

  • Receiver Path processes:
    • Add, alter, and delete
    • Reposition path, change filtering
    • Monitor data statistics incoming path
    • Monitor network/file IO statistics incoming path
  • Log files
    • Diagnosis for Critical Events
    • Debug Log for additional debug information

Troubleshoot using the Performance Metrics Service

In the Performance Metrics Service area, you can monitor Oracle GoldenGate deployment processes to help you troubleshoot:

  • Administration Service
    • Extracts
    • Replicats
  • Distribution Service
  • Receiver Service
  • Performance Metrics Service
  • Log files
    • Diagnosis for Critical Events
    • Debug log for additional debug information
  • Monitor system Oracle GoldenGate deployment system wide logs
  • Monitor system Oracle GoldenGate deployment system status changes