JDBC报错：Connection refused(DESCRIPTION=(TMP=)(VSNNUM=150999297)(ERR=12505)(ERROR_

Eclipse连Jdbc报错：

Io Òì³£: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=150999297)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))

 

原来是我的SID_NAME 错误

jdbc:oracle:thin:@192.168.1.2:1521:SID_NAME

 

SID_NAME 可以在listener.ora中找到

(SID_DESC =
      (GLOBAL_DBNAME = a.b)
      (ORACLE_HOME = D:\oracle\oracle9i)
      (SID_NAME = a)

 

 

 

 

 

参考资料http://www.cnblogs.com/simie/archive/2007/06/03/769312.html