ORA-12154错误 [英] ORA-12154 error

问题描述

虽然我试图创建一个使用Oracle 10g的asp.net表单数据连接，我得到了错误ORA-12154错误。任何一个可以排序了这一点给我吗？由于进出口新的甲骨文，它看起来对我来说很难。但sqlex preSS的连接工作正常！

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!!

推荐答案

问题是你TNS。检查这三种解决方案：

The problem is your TNS. Check these three solutions :

• 确保TNSNAMES被列为NAMES.DIRECTORY_PATH参数在Oracle网络配置文件（SQLNET.ORA）中的一个值

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

验证tnsnames.ora文件是否存在，并在适当的目录和可访问。

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

检查作为连接标识符的网络服务名在tnsnames.ora文件存在。

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

这篇关于ORA-12154错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！