Skip to main content
Kofax

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.

 

  • Was this article helpful?