Oracle SID Connnection String fails with ORA-12505 Error

Last updated
Save as PDF

Error when trying to connect to Oracle DB using SID connection:

If you get the error: "Listener refused the connection with the following error: ORA-12505, TNS: listener does not currently know of SID given in connect descriptor"

This is because of the unsupported SID element in the connection string used by Oracle:

jdbc:oracle:thin:@//<host>:<port>/<service_name>

The reason why this string failed is because our Oracle connection string does not use SID, instead it uses the schema:

jdbc:oracle:thin:@${ServerName}:${Schema}

However, you can use the Service name in the Schema field as long as your connection string is configured to use the service name in your Oracle tnsname.ora configuration file too.