Oracle SID Connnection String fails with ORA-12505 Error
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.