Oracle TNS names not showing when adding new connection to sqldeveloper

Posted by Americus on Stack Overflow See other posts from Stack Overflow or by Americus
Published on 2009-01-08T16:57:43Z Indexed on 2010/03/13 6:25 UTC
Read the original article Hit count: 561

Filed under:

Oracle

|

tnsnames

|

tns

|

sql-developer

|

database

Hello,

I'm trying to connect to an oracle database with sqldeveloper.

I've installed the .Net oracle drivers and placed the tnsnames.ora file at C:\Oracle\product\11.1.0\client_1\Network\Admin.

I'm using the following format in tnsnames.ora.

dev =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.XXX.XXX)(PORT = XXXX))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = idpdev2)
)
)

In sqldeveloper, when I try to create a new connection, no tns names show up as options.

Is there something I'm missing?

© Stack Overflow or respective owner

Related posts about Oracle

E-Business Suite Technology Sessions at OpenWorld 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle OpenWorld 2012 is almost here! We're looking forward to updating you on our products, strategy, and roadmaps. This year, the E-Business Suite Applications Technology Group (ATG) will participate in 25 speaker sessions, two Meet the Experts round-table discussions, five demoground booths and… >>> More
26 Days: Countdown to Oracle OpenWorld 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Welcome to our countdown to Oracle OpenWorld! Oracle OpenWorld 2012 is just around the corner. In less than 26 days, San Francisco will be invaded by an expected 50,000 people from all over the world. Here on the Oracle WebCenter team, we’ve all been working to help make the experience a great… >>> More
OTN ???? ?????? ???????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Database ?? Database ??????? Database ?????????? Java WebLogic Server/????????·???? SOA/BPM/????? ???????/???? ID??/?????? ?????EPM/BI EPM/BI ??????? EPM/BI ???? OS/??? ???? ????? MySQL Database ?? ???? ?? ????????? ??? ?? ORACLE MASTER… >>> More
SOA PARTNER COMMUNITY NEWSLETTER JULY 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
SOA PARTNER COMMUNITY NEWSLETTER JULY 2012 Dear SOA partner community member To provide our community members the best of our knowledge, we want your feedback on our SOA Partner community. Thus we are organizing SOA Partner Community Survey 2012. We… >>> More
Oracle ADF Coverage at OOW

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Below is the schedule for all ADF related sessions at a glance. Note the Meet and greet session added for Wednesday Octiber 3rd from 4.30 pm to 5:30. Oracle ADF and Fusion Development General Session Mon 1 Oct,… >>> More

Related posts about tnsnames

On SQL Developer and TNSNAMES.ORA

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Tnsnames.ora [DOCS] is a configuration file for SQL*Net that describes the network service names for the databases in your organization. Basically, it tells Oracle applications how to find your databases. This post is just a quick overview on how to get SQL Developer to ‘see’ this file… >>> More
How to use Data Pump (expdp and impdp) commands from Oracle without tnsnames.ora file

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to be able to run expdp and impdp onto a machine by directly specifying the connection parameters instead of a tns name that resides in tnsnames.ora. Is this possible? >>> More
Parsing tnsnames.ora using regex...

as seen on Stack Overflow - Search for 'Stack Overflow'
I am attempting to pull some information from my tnsnames file using regex. I started with the following pattern: MYSCHEMA *? = *?[\W\w\S\s]*\(HOST *?= *?(?<host>\w+\s?)\)\s?\(PORT *?= *?(?<port>\d+)\s?\)[\W\w\S\s]*\(SERVICE_NAME *?= *?(?<servicename>\w+)\s?\) which worked fine… >>> More
How to specify Java Option (System Property) for embedded Tomcat while running Grails App?

as seen on Stack Overflow - Search for 'Stack Overflow'
Specifically, I want to have my grails app under development to connect to an Oracle db defiined by an tnsnames.ora file. I have the tnsnames.ora file located in c:\drivers\Network\ on my PC. When I run the grails app via "grails run-war", the db connection string defined in the tnsnames.ora file… >>> More
How to resolve "TNS-12520 TNS:listener could not find available handler for requested type"?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have brand new MacBook Pro (Mac OS 10.6.3) and installed Oracle's SQLDeveloper. After doing so, I set the connection and was connecting just fine. But after an hour or so I got "TNS-12520 TNS:listener could not find available handler for requested type". I wonder how can I fix it? >>> More