Toad World® Forums

error 12154 tns:could not resolve the connect identifier specified


#1

Hello I’m getting an error when I try to connect to my database.

tnsnames.ora and sqlnet.ora are located in C:\Oracle\product\10.1.0\Client_1\NETWORK\ADMIN and my plsql developer works fine. I’m not sure why I’m getting the error message 12154.

Thanks in advance.


#2

Hi Ryanp,

Can you TNSPING your database?

ORA-12154: TNS:could not resolve service name

Cause: Oracle Net could not locate the net service name specified in the tnsnames.ora configuration file.

Action: Perform these steps:

  1.  Verify that a tnsnames.ora file exists. See Also:
    

"Localized Configuration File Support"http://download-west.oracle.com/docs/cd/B10501_01/network.920/a96580/config_c.htm#484186 for configuration file location information

  1.  Verify that there are not multiple copies of the tnsnames.ora file.
    
  2.  In the tnsnames.ora file, verify that the net service name specified in your connect string is mapped to a connect descriptor.
    
  3.  Verify that there are no duplicate copies of the sqlnet.ora file.
    
  4.  If you are using domain names, verify that your sqlnet.ora file contains a NAMES.DEFAULT_DOMAIN parameter. If this parameter does not exist, you must specify the domain name in your connect string.
    
  5.  If you are not using domain names, and this parameter exists, delete it or disable it by commenting it out.
    
  6.  If you are connecting from a login dialog box, verify that you are not placing an "@" symbol before your connect net service name.
    
  7.  Activate client tracing and repeat the operation.

#3

I reinstalled oracle driver and it works now… I don’t know why it didn’t. Thanks!


#4

Hi Ryanp,

Good to hear that it is working for you now. Please feel free to come to the community to ask questions should you have other issues in the future. Thanks.