some error of the Oracle connection TNS-03505 OR T
2024-08-29 13:29:46
供稿：網友
（原創）配置tnsname是個十分容易的問題，沒什么好說的，以前也從來沒有錯過，不過今天配置的時候出了兩個小問題（這兩個問題是用gui配置時不會出的，我覺得java啟動太慢，手工配置tnsname.ora時出現的）
c:/>tnsping 100
tns ping utility for 32-bit windows: version 9.2.0.1.0 - production on 15-oct-2004 12:38:38
copyright (c) 1997 oracle corporation. all rights reserved.
used parameter files:
f:/oracle/ora92/network/admin qlnet.ora
used hostname adapter to resolve the alias
attempting to contact (description=(connect_data=(sid=*)(service_name=100))(address=(protocol=tcp)(host=100)(port=1521)))
tns-12541: tns:no listener
查看server端的監聽,lsnrctl status，結果正常
查看tnsname.ora
100 =
(description =
(address_list =
(address = (protocol = tcp)(host = 192.168.6.100)(port = 1521))
)
(connect_data =
(server = dedicated)
(service_name = oracas)
)
)
完全正確....
*******************************************************************
或者是
c:/>tnsping 226
tns ping utility for 32-bit windows: version 9.2.0.1.0 - production on 15-oct-2004 12:40:12
copyright (c) 1997 oracle corporation. all rights reserved.
used parameter files:
f:/oracle/ora92/network/admin qlnet.ora
tns-03505: failed to resolve name(意思是不存在226在文件tnsname.ora中)
查看tnsname.ora
226 = (description =
(address_list =
(address = (protocol = tcp)(host = 192.168.6.226)(port = 1521))
)
(connect_data =
(service_name = oracas)
)
)
完全正確...
最后分析出導致上述兩個問題的原因都是應為tns前面多了一個空格。。。。。。寒，居然是這種錯誤...
所以大家配置的時候小心細節問題
本文來源于網頁設計愛好者web開發社區http://www.html.org.cn收集整理，歡迎訪問。
