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
4
votes
4 answers

Python tnsnames.ora parser

I need a dict containing all database connections from tnsnames.ora file. I need to go from this…
Jean Coiron
  • 632
  • 8
  • 24
4
votes
3 answers

Managed ODP.NET Calls to PUBLIC Database Link tables cause TNS errors

Our application uses managed ODP.NET code to call a variety of Oracle Procedures. For one of our clients, who is using public database links, and referencing the linked tables within the procedure, that call is failing. Upon further testing, any…
Tom Halladay
  • 5,651
  • 6
  • 46
  • 65
4
votes
2 answers

Oracle database TNS The value's length for key 'data source' exceeds it's limit of '128'

So I have a connection string to an Oracle Database essentially I copied it straight from sql developer and then cut out the white space. I later programmatically add in the user name and password.The problem is that when I try to open an…
Alexander Ryan Baggett
  • 2,347
  • 4
  • 34
  • 61
4
votes
1 answer

What exactly is the deal with oracle connection identifiers separated by a period

I've been wondering this for a while but since it hasn't come up much I've left it in the 'mysterious wizardy' column. It seems to me that there is some sort of relationship between a connection identifier like ABC and ABC.DEFG and I don't quite get…
George Mauer
  • 117,483
  • 131
  • 382
  • 612
4
votes
7 answers

cannot connect to oracle server from C#.net application

I'm trying to connect to remote Oracle server. My connection string - OdbcConnection con = new OdbcConnection(); con.ConnectionString = @"Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=…
Shalem
  • 1,446
  • 2
  • 22
  • 47
4
votes
3 answers

Commandline to modify tnsnames.ora

Is there a command line utility to modify the tnsnames.ora file for the oracle client? [EDIT] I'm looking for something similar to odbcconf.exe (for editing ODBC connection on windows) to modify the tnsnames.ora file. [EDIT2] I'm using MSBUILD from…
Aaron Carlson
  • 5,522
  • 4
  • 31
  • 35
4
votes
1 answer

SDU setting in the connection string with oracle 11G

I do not reference the sqlnet.ora file for the look-up and pretty much provide the following TNS URL for the connectivity and I need to squeeze in a SDU setting in the below connection URL I was wondering where it would go and how the new url will…
Swaroop
  • 67
  • 1
  • 6
4
votes
4 answers

Parsing tnsnames.ora in Visual C# 2008

How I parse tnsnames.ora file using Visual C# (Visual Studio 2008 Express edition) to get the tnsnames ? For instance, my tnsnames.ora file contains ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = shaman)(PORT = 1521)) …
Sathyajith Bhat
  • 21,321
  • 22
  • 95
  • 134
3
votes
2 answers

SqlDeveloper: clear network alias list

I use sql-developer to connect to several different oracle databases with several different users. The connection info is kept in a tnsnames.ora file so that when a database changes servers, I don't have to manually update all my connections to it.…
David Oneill
  • 12,502
  • 16
  • 58
  • 70
3
votes
1 answer

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor in oracle 11g

Already read all the question related to this error, but couldnt resolve the issue. As of yesterday, the oracle SMALLWORLD service has stopped working and the error is ORA-12514 TNS:listener does not currently know of service requested in connect…
Sadeq Aramideh
  • 43
  • 1
  • 2
  • 7
3
votes
2 answers

Does Oracle SQL Developer Work With sqlnet.ora?

Is there a way to configure Oracle SQL Developer to respect the TNS look up order in sqlnet.ora ? We have all information correctly configured in TNS_ADMIN folder: ldap.ora sqlnet.ora tnsnames.ora Our sqlnet.ora config TNS Look up order…
LeY
  • 659
  • 7
  • 21
3
votes
0 answers

Oracle 12c docker container -- uploading tnsnames.ora

I'm creating a docker image of a oracle 12c and i want to include a custom tnsnames.ora file. So what i do in my dockerfile: COPY tnsnames.ora /u01/app/oracle/product/12.1.0/xe/network/admin/ But then i get an error like this: rm: cannot…
S. Wens
  • 31
  • 1
  • 5
3
votes
3 answers

Fetching connection data from tnsnames.ora via awk

I try to build automation procedure which base on connection data from tnsnames.ora which is oracle connection base for database. Typical TNS build looks like this but there is much more connections than 1: " MY_BASE= (DESCRIPTION= …
Jan Wit
  • 31
  • 1
3
votes
1 answer

Unable to connect to Database using SQL Developer (not picking up from tnsnames.ora)

I have installed Oracle 11g & SQL Developer on my Linux Mint OS. After setting ORACLE_PATH and relevant variable in .bashrc file, I am able to connect using sqlplus. Snapshot of my tnsnames.ora XE = (DESCRIPTION = (ADDRESS =…
inityk
  • 476
  • 1
  • 9
  • 18
3
votes
2 answers

Using settings from TNSNAMES.ORA in HikariCP

I am trying to migrate to HikariCP for my application connection pool. At the moment, I want to connect to an Oracle database. Here is the code I am using : HikariConfig hc = new HikariConfig(); hc.setUsername(username); …
Shade
  • 55
  • 6
1 2
3
…
17 18