Troubleshooting Oracle XStream CDC Source Connector for Confluent Platform

This section contains troubleshooting information for the Confluent Oracle XStream CDC Source connector.

Connector diagnostics script

The Confluent Oracle XStream CDC connector diagnostics script (orclcdc_diag.sql) is a read-only script that collects key diagnostic information about the Oracle database and XStream configuration. This script helps troubleshoot connector issues and is provided solely for diagnostic purposes. The script output is an HTML report that you can upload to Confluent Support for further analysis.

This script does not collect or process any message content.

Prerequisites

  • Oracle Database version 19c and later.

  • Oracle database user with SYSDBA privileges.

  • Access to SQL*Plus command-line utility for running the script.

Usage instructions

Run the script

  • Connect to the Oracle database as a user with SYSDBA privileges. Note that if you are using a Container Database (CDB), you must connect to the root container.

  • Run the script using sqlplus. The script generates a diagnostic HTML report.

Upload the report

After you generate the report, you must upload it securely to Confluent.

  • Go to Secure File Transfer site. This site enables file encryption and tracks who accesses the files.

  • Upload the report.

Warning

Do not upload sensitive information to Confluent.

For more information, see Required Access to Confluent Network Sites.