关于ORACLE中异常Oracle中"listener does not currently know of SID given in connect

关于ORACLE中错误Oracle中"listener does not currently know of SID given in connect desc
最近在使用oracle11g，在网上下载了安装文件后，在连接用ibatils连接数据库时
出现了上述错误，最后发现
<transactionManager type="JDBC" commitRequired="false">
    <dataSource type="SIMPLE">
      <property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver"/>
      <property name="JDBC.ConnectionURL" value="jdbc:oracle:thin:@localhost:1521:orcl"/>
      <property name="JDBC.Username" value="sysman"/>
      <property name="JDBC.Password" value="welcome"/>
    </dataSource>
  </transactionManager>
中的orcl时SID这个SID可以通过SQL语句查询出来SELECT   NAME   FROM   v$database，如果上述错误还存在。
那么久需要去修改配置文件了
我的目录是这个D:\app\Administrator\product\11.1.0\db_2\NETWORK\ADMIN
中找到listener.ora,修改后的内容如下
# listener.ora Network Configuration File: D:\app\Administrator\product\11.1.0\db_2\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\app\Administrator\product\11.1.0\db_2)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = D:\app\Administrator\product\11.1.0\db_2)
      (SID_NAME = orcl)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
  )
最新提供关于ORACLE11g class12.jar和Oracle 11g 11.7.0.5.0 JDBC_ojdbc6.jar
的下载连接
我的网站设计 web design home page
http://www.webdesign-cn.com
http://www.webdesign-china.cn