Home » RDBMS Server » Networking and Gateways » ERROR: ORA-12154: TNS:could not resolve the connect identifier specified
ERROR: ORA-12154: TNS:could not resolve the connect identifier specified [message #573467] Sat, 29 December 2012 01:14 Go to next message
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 !
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58959
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
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 Go to previous messageGo to next message
akull
Messages: 39
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!
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58959
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks to let us know.

Regards
Michel
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 Go to previous messageGo to next message
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
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 Go to previous message
Michel Cadot
Messages: 58959
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
Previous Topic: TNSNAMES
Next Topic: ERROR [08004] [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified (merged)
Goto Forum:
  


Current Time: Wed Sep 03 01:36:26 CDT 2014

Total time taken to generate the page: 0.10929 seconds