关于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
