Oracle DBAAS Connection Error: ORA-12504 - Listener Not Given SID in CONNECT_DATA
Hi,
I'm encountering an issue with our Oracle DBAAS connection. We've got this connection type set up, which use an agent to link with our on-premise Oracle database. Oddly enough, when we run a test connection through the connection wizard, it's successful. But when we actually try to use this connection for selecting or inserting into the database within our integration, it throws us an ORA-12504 error:
Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: Listener refused the connection with the following error: ORA-12504, TNS:listener was not given the SID in CONNECT_DATA
0