ORACLE TNS NAMES not resolving

Question

0.00/5 (No votes)

See more:

Hi,

i wonder if anyone can assist me. i keep getting an error ORA-12154: TNS Could not resolve the connection identifier. i installed the oracle instant client and odbc connections downloaded from oracle. the OS is windows 7 64 bit. as i understand it is not necessary to install an actual oracle home for the connections. but whenever i try to connect to the database via visual studio 2010 i get the ORA-12154: TNS: Could not resolve the connection identifier specified. i am at a loss at what i am need to do to fix this as i can't find the tnsnames.ora or the listener.ora file .
any help will be greatly appreciated
thank you
Kallie

Posted 3-Jul-13 21:17pm

Member 9742322

Add a Solution

2 solutions

Solution 1

hi i installed Oracle 10g express and copied the existing working tns names and listeners files and it works perfectly

Posted 3-Jul-13 22:02pm

Member 9742322

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prasad Khandekar · Accepted Answer · 2013-07-03T22:12:00

Hello Kallie,

Oracle Instant Client does not really requires the TNS configuration (tnsnames.ora). According to documentation Instant Client allows you to run your applications without installing the standard Oracle client or having an ORACLE_HOME. So it does uses a slightly different connection string syntax. You can use any one of the following syntax with the instant client.

A SQL Connect URL string of the form:

//host:[port][/service name]

e.g. //oradb01.foo.com:1521/orcl

As an Oracle Net keyword-value pair.

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=HOSTNAME_OR_IP) 
(PORT=1521)) 
(CONNECT_DATA=(SERVICE_NAME=SERVICE_NAME))) 

e.g.
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=oradb01.foo.com) 
(PORT=1521)) 
(CONNECT_DATA=(SERVICE_NAME=orcl)))

As per the documentation Naming methods that require TNS_ADMIN to locate configuration files continue to work if the TNS_ADMIN environment variable is set. If the TNS_ADMIN environment variable is not set, and TNSNAMES entries are used, then the ORACLE_HOME variable must be set, and the configuration files are expected to be in the $ORACLE_HOME/network/admin directory.

Regards,