OraFAQ Forum: Networking and Gateways » ERROR: ORA-12154: TNS:could not resolve the connect identifier specified

Home » RDBMS Server » Networking and Gateways » ERROR: ORA-12154: TNS:could not resolve the connect identifier specified

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ERROR: ORA-12154: TNS:could not resolve the connect identifier specified [message #573467]

Sat, 29 December 2012 01:14

shakthi
Messages: 1
Registered: December 2012

Junior Member

Hi,

I have both 10g and 11g installed in my machine.
There are so many CI builds that runs without problems.
For few builds which uses 10g, it throws errors as ,

SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 27 01:18:52 2012

Copyright (c) 1982, 2010, Oracle. All rights reserved.

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

Enter user-name:

Only at a particular step, this is happening. After this,if someother target is connecting to Oracle,it is able to connect.

Checked TNSNAMES.ORA,Sqlnet.ORA. Everything looks good!
This is really new to us.
Honestly am not a Oracle DBA , but am at the neck of the moment to resolve this.
Any help would be very helpful !

Report message to a moderator

Re: ERROR: ORA-12154: TNS:could not resolve the connect identifier specified [message #573471 is a reply to message #573467]

Sat, 29 December 2012 01:55

Michel Cadot
Messages: 68634
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Sometimes you do not point to the correct tnsnames.ora location.
Check your ORACLE_HOME and TNS_ADMIN variables when it does not work.

Regards
Michel

Report message to a moderator

Re: ERROR: ORA-12154: TNS:could not resolve the connect identifier specified [message #574926 is a reply to message #573471]

Wed, 16 January 2013 14:35

akull
Messages: 46
Registered: July 2012
Location: Argentina

Member

We had the same issue when we installed our Oracle DB 11g. The problem was that the ORACLE_HOME was not pointing the file oci.dll when we fixed that, we had another problem. It turns out that the server specified in the file TNSNAMES.ORA was pointing directly to the server and the DNS was unable to resolve the Ip Adress, so we changed the server name and put the Ip adress, it worked perfectly.

I hope this piece of advice can be useful!

Report message to a moderator

Re: ERROR: ORA-12154: TNS:could not resolve the connect identifier specified [message #574927 is a reply to message #574926]

Wed, 16 January 2013 14:41

Michel Cadot
Messages: 68634
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Thanks to let us know.

Regards
Michel

Report message to a moderator

Re: ERROR: ORA-12154: TNS:could not resolve the connect identifier specified [message #575210 is a reply to message #574927]

Mon, 21 January 2013 05:24

rishwinger
Messages: 132
Registered: November 2011

Senior Member

If you are looking just to connect from cmd prompt , You can use below cmd, this make use of ezconnect feature of Oracle , your tnsname.ora won't even matter

sqlplus username/password@[//]host[:port][/service_name]

port is generally 1521 , but you should still check your tnsnames.ora

Report message to a moderator

Re: ERROR: ORA-12154: TNS:could not resolve the connect identifier specified [message #575219 is a reply to message #575210]

Mon, 21 January 2013 06:31

Michel Cadot
Messages: 68634
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

But you have to enable ezconnect in sqlnet.ora with, for instance:

NAMES.DIRECTORY_PATH= (EZCONNECT,TNSNAMES)

Regards
Michel

Report message to a moderator

Previous Topic:	TNSNAMES
Next Topic:	ERROR [08004] [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 08:19:17 CDT 2024