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

Question

not able to connect oracle DB.

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

Answer 1

not able to connect oracle DB.

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

Please post in Oracle forum this forum is for SQL Server.Search on Net

---

Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

My TechNet Wiki Articles

Answer 2

Hello,

Please refer to the following resource and make adjustments on the Oracle client.

http://ora-12154.ora-code.com/

This error means it cannot resolve the TNSNAME. Please examine the aliases. Examine .ORA file.

The following post may be useful too:

http://blogs.msdn.com/b/dataaccesstechnologies/archive/2010/06/30/ora-12154-tns-could-not-resolve-the-connect-identifier-specified-error-while-creating-a-linked-server-to-oracle.aspx

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 3

not able to connect oracle DB.

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

Please post in Oracle forum this forum is for SQL Server.Search on Net

---

Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

My TechNet Wiki Articles

Hi,

this is related to SQL server linkserver connection .

Answer 4

This may be a SQL Server linked server connection issue, but it is an Oracle driver configuration issue.

Either you have not configured your tnsnames.ora file correctly or you are using the incorrect connection string to connect to the Oracle server.