Error with Oracle destination provider and normalization


The user is facing an issue with the Oracle destination provider when trying to normalize tabular data, encountering an ORA-12514 error related to the TNS listener not recognizing the service in the connect descriptor.


Hello, we have a problem with normalization. The oracle destination provider always gets the same error with normalization tabular data turned on (it works with RAW turned on)
The error
2024-02-20 12:42:24 normalization > 2024-02-20 12:42:22.669567 (ThreadPoolExecutor-0_0): Attempting to connect using Oracle method: ‘OracleConnectionMethod.HOST’ and dsn: ‘xxx:1521/xxx’
2024-02-20 12:42:24 normalization > 2024-02-20 12:42:22.743726 (ThreadPoolExecutor-0_0): Got an error when attempting to open an Oracle connection: ‘ORA-12514: TNS:listener does not currently know of service requested in connect descriptor’

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["error", "oracle-destination-provider", "normalization", "tabular-data", "ORA-12514", "TNS-listener"]