In New Connection Profile
I filled in the details for SID, Host, Port Number, UserName, Password
This formed the connection url automatically
jdbc:oracle:thin:@19.2.12.18:1553:HELLO.WORLD.DB
When I tried to test the connection after creating the profile, I got the following error
Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
19.2.12.18:1553:HELLO.WORLD.DB
I got the same kind of problem while configuring DBVizualizer
However in DBVizualizer, it connected properly when I gave the tnsentry itself in the connection url, for example
jdbc:oracle:thin:@(description=(address=(protocol=tcp)(host=19.2.12.18)(port=1553))(connect_data=(sid=HELLO.WORLD.DB)))
Is it possible to create a new connection profile in Eclipse using the connection url like the one mentioned above.
Please let me know if anyother information is required to resolve this...
Thanks a lot for your interests in answering this query.