java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection解决方案

 java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection是我今天刚遇到的问题，有很

多原因导致这个，网上也有答案，我的主要毛病是在hibernate.properties文件中没有把hibernate.properties中的行：

hibernate.connection.url jdbc:oracle:thin:@localhost:1521:oracle
最后一个oracle替换为我的oracle_sid，改成orcl后就没事，还有一些解决方法。我一一列出：
1、把卡巴斯基防火墙关掉就好了
2、oracle/ora92/network/admin/listener.ora  和 oracle/ora92/network/admin/tnsnames.ora 的设置问题。
两个文件如下：
listener.ora:
# LISTENER.ORA Network Configuration File: F:/oracle/ora92/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = lei)(PORT = 1521))
      )
    )
  )
#change 1521 to 1523 this is oracle92's listener
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = F:/oracle/ora92)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = F:/oracle/ora92)
      (SID_NAME = orcl)
    )
  )

tnsnames.ora：
# TNSNAMES.ORA Network Configuration File: F:/oracle/ora92/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = lei)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = lei)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

    比如，listener.ora中的host写错了。不同的版本所需要的portable也不会一样的。

    
  还是非常感谢大家！！