Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQL Developer 2.1.0.63 duplicate TNS names displayed in the Connection Type

695499Jan 25 2010 — edited Feb 16 2010
I'm running SQL Developer 2.1.0.63, Windows XP, Java version 1.4.03. The New Connection window displays duplicate database names on selecting the TNS Connection Type - but only on the 2nd and subsequent times I start SQLDeveloper (not the first time & then exit). The TNS_ADMIN variable name is correctly set and no other copies of a file starting with "tnsnames" exist on my local machine or in any Regedit, path or ORACLE_HOME. The same tnsnames file has been used for prior versions of SQLDeveloper, teh problem has appeared wih the upgarde to 2.1

I can reliably re produce the problem with a tsnames file that only contains:

occsys.WORLD =
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 123.456.789.23)(PORT = 1521))
)
(CONNECT_DATA = (SID = occsys))
)

pulse.WORLD =
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 123.456.789.24)(PORT = 1521))
)
(CONNECT_DATA = (SID = pulse))
)

Would anybody have any ideas or could point me in the direction of a set up guide (other than Oracle Database Net Services Reference)?
This post has been answered by Turloch O'Tierney-Oracle on Feb 5 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 16 2010
Added on Jan 25 2010
19 comments
7,494 views