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.