Sidebar

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

0 votes
418 views
asked Sep 13, 2013 by brandon-w-8204 (33,170 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"
answered Sep 13, 2013 by brandon-w-8204 (33,170 points)
...