ORA-12154 error [closed]

2019-08-20 10:09发布

问题:

While I tried to create data connection for using oracle 10g for asp.net form, i got the error ORA-12154 error . Can any one sort this out for me? Since Im new to oracle , it looks hard for me. but the connection with sqlexpress are working fine!!

回答1:

The problem is your TNS. Check these three solutions :

  • Make sure that "TNSNAMES" is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA)

  • Verify that a TNSNAMES.ORA file exists and is in the proper directory and is accessible.

  • Check that the net service name used as the connect identifier exists in the TNSNAMES.ORA file.