1.2k questions

1.4k answers

361 comments

339 users

Categories

Sidebar
0 votes
568 views
by brandon-w-8204 (34.1k points)
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

1 Answer

0 votes
 
Best answer
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"
by brandon-w-8204 (34.1k points)
...