（原創(chuàng)）配置tnsname是個(gè)十分輕易的問題，沒什么好說的，以前也從來沒有錯(cuò)過，不過今天配置的時(shí)候出了兩個(gè)小問題（這兩個(gè)問題是用GUI配置時(shí)不會(huì)出的，我覺得Java啟動(dòng)太慢，手工配置tnsname.ora時(shí)出現(xiàn)的）C:>tnsping 100 TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - ProdUCtion on 15-OCT-2004 12:38:38Copyright (c) 1997 Oracle Corporation.; All rights reserved.Used parameter files:F:oracleora92networkadmin qlnet.oraUsed HOSTNAME adapter to resolve the aliasAttempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=100))(ADDRESS=(PROTOCOL=TCP)(HOST=100)(PORT=1521)))TNS-12541: TNS:no listener查看Server端的監(jiān)聽,lsnrctl status，結(jié)果正常查看tnsname.ora100 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.100)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oracas) ) )完全正確....*******************************************************************或者是C:>tnsping 226TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 15-OCT-2004 12:40:12Copyright (c) 1997 Oracle Corporation.; All rights reserved.Used parameter files:F:oracleora92networkadmin qlnet.oraTNS-03505: Failed to resolve name(意思是不存在226在文件tnsname.ora中)查看tnsname.ora226 =; (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.226)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = oracas) ) )完全正確...最后分析出導(dǎo)致上述兩個(gè)問題的原因都是應(yīng)為tns前面多了一個(gè)空格。。。。。。寒，居然是這種錯(cuò)誤...所以大家配置的時(shí)候小心細(xì)節(jié)問題