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

Asked

Viewed 9,353 times

1

I’m having trouble when an application tries to connect with the database, I get error ORA-12154 TNS: could not resolve the connect Identifier specified.

When I give a tnsping or try to connect by pl/sql Developer up to sql plus everything happens normally. I’m using visual studio 2013, oracle 10g and windows 7 Enterprise 64 bits.

inserir a descrição da imagem aqui

c# oracle oracle10g

  • check if the service specified exists in tnsnames.ora, if it exists, check if the file tnsnames.ora is in the appropriate directory, if it is, check if the variable TNS_ADMIN is pointing to the directory of the file tnsnames.ora

  • See what alias the DBLINK are using, do select owner, db_link, username, host from dba_db_links and check the column value host is the same as in the file tnsnames..

  • It’s all right Otto, I’ve checked tns_admin, tnsnames.

  • qmechanik, do not have access to this table

  • How is the connection string? As is the specification of TNS?

  • con = new Oracleconnection("User Id=.... ;Password=****;Data Source=....");

  • I had the same problem and to solve the incredible it seems was that Tnsname.ora was in a sample folder and I only had to put it in the proper folder with a cut and Paste. C: app username product 12.1.0 client_1 Network Admin Sample

Show 2 more comments

1 answer

1

For users of Oracle Forms Builder, remember to create the environment variable (System): ORACLE_HOME pointing to the root folder of the Forms Builder installation (In my case: C:\DevSuiteHome1).

Browser other questions tagged c# oracle oracle10g

You are not signed in. Login or sign up in order to post.