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

ORA-12154: TNS:could not resolve the connect identifier specified

I am trying to connect to oracle 11g installed on Linux EL 5 and and getting the following error SQL> connect sys/password@ud06 as sysdba ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor my…
user275705
  • 115
  • 1
  • 2
  • 9
7
votes
12 answers

ORA-12154: TNS:could not resolve the connect identifier specified (PLSQL Developer)

I need to use PLSQL Developer to access oracle databases. I get the following error when I try to connect to my database. ORA-12154: TNS:could not resolve the connect identifier specified. I am able to use SQLPLUS from the command line to connect to…
ZakTaccardi
  • 12,212
  • 15
  • 59
  • 107
6
votes
2 answers

java.lang.ArrayIndexOutOfBoundsException when creating a connection to an Oracle database

It appears that Oracle's java client has a bug - if the tnsnames.ora file has misplaced spaces/tabs/new-lines in particular places, you get an exception with the following trace: java.lang.ArrayIndexOutOfBoundsException: at…
RonK
  • 9,472
  • 8
  • 51
  • 87
6
votes
1 answer

How to connect to ORACLE DB without oracle client or tnsname

Is there any way to connect to Oracle DB without installing oracle client or using tnsname ? The application needs to be deployed on client machine ,hence want it to be INDEPENDENT.
jen123
  • 61
  • 1
  • 1
  • 4
6
votes
3 answers

Querying an Oracle database from SQL Server

I have an Oracle 11g XE database that I would like to transfer into SQL Server Express 2005. At first I thought I'd just generate the tables in Oracle as SQL, manipulate the data formats, and run the query in SQL Server. This worked for small…
mikimr
  • 311
  • 3
  • 8
  • 18
5
votes
1 answer

how to use tns entries with macromedia drivers for Oracle

We are currently forced to use macromedia drivers on ColdFusion in order to connect to Oracle databases. The jdbc connection url is like: jdbc:macromedia:oracle://server:port;sid=service The flip side of this approach is that it forces us to 'hard…
E. Jaep
  • 2,095
  • 1
  • 30
  • 56
5
votes
2 answers

ORA-12162: TNS:net service name is incorrectly specified on Mac OS X Lion

I am trying to connect to an oracle database using oracle sqlplus instant client using tnsnames.ora. But getting this error: ORA-12162: TNS:net service name is incorrectly specified. I have following environmental value set up…
Omanand
  • 51
  • 1
  • 1
  • 2
5
votes
2 answers

ORA-12154: Can't Connect to Default Oracle XE 21c Database on Windows 10

I've had it. I just can't get this to work. I installed Oracle XE 21c on my Windows 10 desktop. The installation went ok, once I ran the Setup file as an administrator. I basically chose all the defaults. So now it is running, and there was a…
JRomeo
  • 171
  • 1
  • 8
5
votes
4 answers

How can I connect to Oracle Database with SQLcl and SQLPlus, but without a TNSNames.ORA file?

You have: an Oracle database an Oracle Client installation, including SQL*Plus the TNS information for #1 BUT NO TNSNames.ORA file or the desire to create and maintain one How can you get your SQL*Plus connection going?
thatjeffsmith
  • 20,522
  • 6
  • 37
  • 120
5
votes
2 answers

How do I list tnsnames

Is there any easy way to list out all the available tnsnames in my system via command line? Whenever I need to find out a tnsname, I just simply search for the tnsnames.ora file with tnsping command and open it in a text editor to scan through. Then…
Damith
  • 417
  • 1
  • 5
  • 15
5
votes
4 answers

Unable to connect SQLState=08004 [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified in ms odbc administrator

I want to add two service names in one tnsnames.ora file and getting error in below 2 image in "Microsoft ODBC Driver Configuration".
sandhiya
  • 133
  • 2
  • 3
  • 17
5
votes
3 answers

How to set proper path to TNSNAMES file in C# application?

I have a program in C# that use ODP.NET dlls: oci.dll, ociw32.dll, Oracle.DataAccess.dll, orannzsbb11.dll, oraocci11.dll, oraociicus11.dll, OraOps11w.dll. I've got 2 computers. First with whole ODAC package installed, and second without that…
Marshall
  • 255
  • 1
  • 4
  • 11
4
votes
2 answers

tnsping fails, but can connect to Oracle DB via sqlplus

I've installed the Oracle Client v. 11.2.0.1 on a Windows XP machine and set both the TNS_ADMIN and ORACLE_HOME environment variables. Using sqlplus to connect to a remote database via a TNS alias works fine: sqlplus username/password@ALIAS But a…
Kevin D.
  • 911
  • 1
  • 6
  • 18
4
votes
1 answer

How can I configure my Oracle tnsnames file location?

I have Oracle 10g installed on Windows. Currently, my tnsnames file is stored at %ORACLEHOME%\network\admin. However, I want to configure Oracle to look somewhere else for that file. How can I do this? Andrew L
AndrewL
  • 3,126
  • 5
  • 31
  • 33
4
votes
1 answer

"ORA-12560: TNS:protocol adapter error" when bypassing tnsnames.ora using full connection string and EZCONNECT

Attempting to use either connection string to bypass tnsnames.ora (full connection string and EZCONNECT) returns the following error when trying to connect to the database: pyodbc.Error: ('HY00', '[HY00] [Oracle][ODBC][Ora]ORA-12560: TNS:protocol…
James Whitehead
  • 101
  • 1
  • 11
1
2
3
…
17 18