今天用數(shù)據(jù)池配置數(shù)據(jù)源，發(fā)現(xiàn)拋出異常
Io 異常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093120)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
Driver Classname: oracle.jdbc.driver.OracleDriver
URL:jdbc:oracle:thin:@145.32.16.1:1521:zzlt
解決辦法：9i和10g的驅(qū)動不要混了，要一一對應
換了以后還是不行拋出異常
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
172.21.18.78:1521:usky
解決辦法：
10.1.0.2.0有這個問題，必須用機器名連接，不能用IP地址。把Listener.ora文件中的監(jiān)聽配置成IP地址也行。10.1.0.3.0就沒有這個問題了。另外安裝時Listener.ora是默認安裝需改成
SID_LIST_LISTENER =
??(SID_LIST =
????(SID_DESC =
??????(SID_NAME = orcl)
??????(ORACLE_HOME = d:\oracle\product\10.2.0\db_1)
??????(GLOBAL_DBNAME = orcl)
??????(PROGRAM = extproc)
????)
??)
LISTENER =
??(DESCRIPTION_LIST =
????(DESCRIPTION =
??????(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
??????(ADDRESS = (PROTOCOL = TCP)(HOST = toby)(PORT = 1521))
????)
??)
改完后需重啟服務，到晚上1點才解決。以上為分經(jīng)驗分享。