Skip to main content

Oracle SID Connnection String fails with ORA-12505 Error

Article # 3018630 - Page views: 267

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: 



The reason why this string failed is because our Oracle connection string does not use SID, instead it uses the 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?