What's causing "ORA-12514, TNS:listener does not currently know of service requested in connect descriptor" Error using Oracle CDC Source Connector

Description

The following error might be observed on the Confluent Cloud UI for Oracle CDC Source connectors:

"ORA-12514, TNS:listener does not currently know of service requested in connect descriptor". Please reach out to your DBA and check if the requested database is registered with the listener and configured correctly.

Applies To

Confluent Cloud

Oracle CDC Source connector

Cause

This error message means that the Oracle database listener is unable to find the service name you provided in the connection string, indicating that the database you're trying to access is not properly registered with the listener or might have incorrect configuration settings

Resolution

Please contact your DBA about the error and ask them to check the following:

• • If the database is registered with the listener 
    
  • If the service name is correctly configured in the listener configuration 
    
  • If there are any network issues preventing communication with the database 
    

  • You can also check the TNSNAMES.ora file for any errors in the service name definition.