Stack Overflow
Stack Overflow

Questions tagged [tnsnames]

The Oracle `tnsnames.ora` is a client site configuration file with database server connection details.

The Oracle tnsnames.ora is a client site configuration file with database server connection details. It contains the database name, server name, and connection protocol.

257 questions
148
votes
5 answers

Use tnsnames.ora in Oracle SQL Developer

I am evaluating Oracle SQL Developer. My tnsnames.ora is populated, and a tnsping to a connection defined in tnsnames.ora works fine. Still, SQL Developer does not display any connections. Oracle SQL Developer Soars mentions, that if you have…
Peter Lang
  • 54,264
  • 27
  • 148
  • 161
101
votes
8 answers

Oracle TNS names not showing when adding new connection to SQL Developer

I'm trying to connect to an oracle database with SQL Developer. 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 = …
Americus
  • 1,367
  • 3
  • 11
  • 14
60
votes
11 answers

Oracle - What TNS Names file am I using?

Sometimes I get Oracle connection problems because I can't figure out which tnsnames.ora file my database client is using. What's the best way to figure this out? ++happy for various platform solutions.
Mark Harrison
  • 297,451
  • 125
  • 333
  • 465
58
votes
17 answers

TNS-12505: TNS:listener does not currently know of SID given in connect descriptor

I'm trying to connect to Oracle 10.2.0 from NetBeans, using the following connection string: jdbc:oracle:thin:@localhost:1521:XE The weirdest part is that everything worked fine, until the one of the reboots. I started getting this TNS-12505 errors…
Anton
  • 3,006
  • 3
  • 26
  • 37
53
votes
9 answers

Why would Oracle.ManagedDataAccess not work when Oracle.DataAccess does?

I'm developing a very simple application which I intend to use to troubleshoot an issue I am having on a few machines but before I even got that far I ran into a few issues, including cpu architecture differences and Oracle database libraries. I…
Jeff
  • 1,727
  • 2
  • 17
  • 29
18
votes
7 answers

PL/SQL Developer cannot find my tnsnames.ora file

I have an Oracle tnsnames.ora file from my previous workplace. I want to pick it up with my newly installed PL/SQL Developer on another computer. I have copied the file into ..ORACLE/product/11.2.0/client_32/NETWORK/ADMIN, but PL/SQL Developer…
MiamiBeach
  • 3,261
  • 6
  • 28
  • 54
15
votes
8 answers

ODBC Administrator Can't Find Oracle TNS Names File

With a new Oracle Installation when I go to Configuration Management Tools > Microsoft ODBC Administrator > System DSN > Add > [new installation] it does not have the TNSNAMES.ora connection name in the drop down. With the old installation, this…
pixelbobby
  • 4,368
  • 5
  • 29
  • 49
13
votes
3 answers

What is a TNS:listener in the Context of Oracle?

Borderline ServerFault question, but figured I'd try here first since I've had luck with Oracle questions in the past. I'm trying to connect to an oracle database from PHP, and I'm getting the following error. ORA-12505: TNS:listener does not…
Alana Storm
  • 164,128
  • 91
  • 395
  • 599
13
votes
3 answers

How to connect JDBC to tns oracle

I can connect from plsql to database using tns file Now I want to connect to the database from my Java using JDBC. What I tried: I search google and I find that I have to using this connection String: "jdbc:oracle:thin:@//host:port))/tnsfile)"; My…
Marco Dinatsoli
  • 10,322
  • 37
  • 139
  • 253
11
votes
3 answers

How to connect SQLPlus with tnsnames.ora

I want to connect with my Oracle database without installing Oracle Client. I downloaded: "Instant Client Package - Basic" and "Instant Client Package - SQL*Plus" Then I created folder on C:\Oracle\instantclient, where I extracted all packages. I…
KamilK
  • 319
  • 1
  • 6
  • 16
9
votes
3 answers

Connecting to a remote Oracle DB with Nodejs through Oracledb Driver

Hey I'm really trying to figure out how to connect to a remote Oracle test DB and I have no experience in Java. So if I could get your help, I would be forever grateful. I have a remote test database I'm trying to connect to and I have a jdbc…
Brooke Clonts
  • 465
  • 1
  • 10
  • 20
9
votes
2 answers

How to use Data Pump utilities without a tnsnames.ora file

I want to be able to run expdp and impdp by directly specifying the connection parameters instead of a TNS name that resides in tnsnames.ora. Is this possible?
Shravan
  • 223
  • 1
  • 5
  • 12
9
votes
4 answers

How do I query LDAP from C# to resolve Oracle TNS hostname while using managed ODP.NET?

Further to my previous Question, which I managed to answer myself with help from the Oracle forums, I now have another issue which follows on from the earlier one (provided for background). I wish to query LDAP directly from my C# code to perform an…
Neo
  • 4,145
  • 6
  • 53
  • 76
8
votes
2 answers

SQL Server Linked Server with tnsnames.ora on network share - ORA: 12154

Having an issue getting a SQL Server linked server to Oracle working while using a tnsnames.ora file on a network share. If I copy the tnsnames.ora file to the local server, the linked servers work fine. However, we keep the file on a network…
Sam
  • 7,543
  • 7
  • 48
  • 62
8
votes
3 answers

Where is TNSNAMES.ORA?

I am working on a Windows server and access Oracle databases using the Oracle ODBC driver. I have Oracle ODBC connections that work fine on this machine. However I want to add a new connection, and when testing it I get the error Unable to…
Alexis Eggermont
  • 7,665
  • 24
  • 60
  • 93
1
2 3
…
17 18