This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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:
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
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.
Well, I dont have access to the server.
All I have is this TNS entry with me in my oracle client.
Connection got established with DB-Vizualiser but not with Eclipse.
Hence the Real problem is in Eclipse configuration. ....
Joined: Jul 10, 2008
Ok, I may be wrong here, but just a guess. HELLO.WORLD.DB looks like the name of global database (that's what SERVICE_NAME is). It is not name of SID. Now since you syntax of
is working, so it is possible Oracle accepts global db name as value to SID (oracle TNS thing syntax is changed several times in past and is still confusing). I would again say, make sure SID name is HELLO.WORLD.DB, and once you resolve this problem do let us know what was the reason of issue.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: Creating Database Connection profile using connection url