Saw this in Eclipse when trying to connect to an Oracle database using
Data Source Explorer.
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
Problem seems to be that when setting up my Oracle Thin driver properties, the SID really has to be a SID, when all I have is a Service Name. It means that the resulting DB URL is:
jdbc:oracle:thin:@host:port:sid when it should be:
The answer is to use a different option in Eclipse when setting up the driver.
Window > Preferences > Data Management > Connectivity > Driver Definitions > choose "Other Driver" for Oracle instead of Oracle Thin Driver. This gives you the option of directly setting the Connection URL.