OracleConnection.Open抛出了ORA-12541 TNS没有监听器 [英] OracleConnection.Open is throwing ORA-12541 TNS no listener
问题描述
所以我通过C#连接到外部服务器。我刚在我的计算机上安装了 Oracle 11g 客户端: http ://www.oracle.com/technetwork/database/windows/downloads/index-090165.html (255MB一个)。
So I am connecting to an external server through C#. I just installed Oracle 11g client on my machine from here: http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html (255MB one).
阅读了许多博客后/ question我发现这篇文章是有用的:
After reading many blogs/questions I found this article to be useful:
http://dbaspot.com/oracle-faq/444787-ora-12541-tns-no-listener.html
这是正确的吗?我什么都做不了。 DBA必须编辑 LISTENER.ORA 文件?
So is this correct? I cannot do anything. The DBA has to edit the LISTENER.ORA file?
我的 tnsnames.ora p>
My tnsnames.ora looks like this:
TestingConnect=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = TestHostName.us.local)(PORT = 1523))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TEST)
)
)
这是我的错误:
Oracle.DataAccess.Client.OracleConnection connection = new Oracle.DataAccess.Client.OracleConnection();
connection.ConnectionString = "Data Source=TestHostName.us.local;Persist Security Info=True;" + "User ID=tesName;Password=test";
connection.Open() //Throwing ERR!!!
我该怎么办?我喜欢任何意见。谢谢!
What should I do? I appreciate any comments. Thanks!
推荐答案
感谢您的所有意见。我改变了我的连接字符串,它工作。这里它的样子:
Thanks for all your input. I changed my connection string and it worked. Here its what looks like:
private static string GetConnectionString()
{
return "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=TestHostName.us.local)(PORT=1523) ) )" +
"(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=CCDB)));User id=UserName; Password=Password; enlist=false; pooling=false;";
}
这篇关于OracleConnection.Open抛出了ORA-12541 TNS没有监听器的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!