You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!