Oracle DB Connection: TNS:listener does not currently know of SID given in the connect descriptor

Question

Recieving the following error when testing a DB connection for Oracle:

java.sql.SQLException: Listener refused the connection with the following error:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Answer 1

The SID indicates the schema paramater is not correct.

The default value for schema is sut90 which stands for Single User Training version of EMR 9.5. When using the SUT version of EMR 9.5 you have to use the OCI driver as it does not support TNS. If this is a SUT version check the "Manually set the connection URL" and put in the following: "jdbc:oracle:oci:@sut90"