Skip to main content

INGESTION_GATEWAY_ORACLE_MISSING_CONFIGURATION error condition

SQLSTATE: 42000

Oracle connection configuration is incomplete.

INVALID_SOURCE_CATALOG

Invalid Oracle service name '<sourceCatalog>' provided in connection parameters.

The 'source_catalog' parameter must contain only printable ASCII characters such as letters, numbers, and underscores.

Edit the Ingestion Gateway pipeline settings to include connection parameters with the source_catalog field — set it to the CDB$ROOT service name for multi-tenant databases, and to the service name for single-tenant databases.

Update and restart the pipeline to apply the changes. No full refresh is required.

For more details, refer to the documentation.

NO_CONNECTION_PARAMETER

Connection parameters must be provided for the Oracle CDC connector.

Edit the Ingestion Gateway pipeline settings to include connection parameters with the source_catalog field — set it to the CDB$ROOT service name for multi-tenant databases, and to the service name for single-tenant databases.

Update and restart the pipeline to apply the changes. No full refresh is required.

For more details, refer to the documentation.

NO_SOURCE_CATALOG

The 'source_catalog' field is required in the connection parametres for the Oracle CDC connector.

Edit the Ingestion Gateway pipeline settings to include connection parameters with the source_catalog field — set it to the CDB$ROOT service name for multi-tenant databases, and to the service name for single-tenant databases.

Update and restart the pipeline to apply the changes. No full refresh is required.

For more details, refer to the documentation.