web程序本地通过ip地址链接不到数据库oracle11g，异常错误 The Network Adapter could not establish the connection

异常错误 The Network Adapter could not establish the connection

plsql和sqlplus连接数据库正常但是程序连接是报如上的错误，解决方法：

找到oracle11g安装路径，我的是：D:\oracle11\Administrator\product\11.2.0\dbhome_2\NETWORK\ADMIN
找到listener.ora文件将里面的
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\oracle11\Administrator\product\11.2.0\dbhome_2)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\oracle11\Administrator\product\11.2.0\dbhome_2\bin\oraclr11.dll")
    )
  )
代码替换为下面的部分
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\oracle11\Administrator\product\11.2.0\dbhome_2)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\oracle11\Administrator\product\11.2.0\dbhome_2\bin\oraclr11.dll")
    )
   (SID_DESC =
    (GLOBAL_DBNAME = ORCL)
    (ORACLE_HOME = D:\oracle11\Administrator\product\11.2.0\dbhome_2)
    (SID_NAME = ORCL)
    )
  )