Spring+ibatis出现ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
来源:互联网 发布:广州程序员工资水平 编辑:程序博客网 时间:2024/06/08 12:28
今天在连接一个oracle读库时出现--- Cause: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
223.203.208.109:1521:racstandby
这样的错误,可是PL/SQL是可以连接的,怎么会出现PL/SQL可以连接而程序不能连,网上许多人说这个错误是SID不对,但是对于我这里就不一样,毕竟ORACLE可以连呀,后来在想想是不是xml配置问题,原先配置如下:
<property name="url">
<value>jdbc:oracle:thin:@223.203.208.109:1521:racstandby</value>
</property>
现在修改成 <value>jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=223.203.208.109)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=racstandby)))</value>
即可,可以参考这位网友的说法:
http://www.2cto.com/database/201203/124950.html
0 0
- Spring+ibatis出现ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- ORA-12505 TNS:listener does not currently know of SID given in connect descriptor
- Oracle ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- 解决‘ORA-12505, TNS:listener does not currently know of SID given in connect descriptor’
- ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- ORA-12505,TNS:listener does not currently know of SID given in connect descriptor
- ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- Oracle - ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 解决
- ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- Oracle - ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 解决
- ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- 力所能及之ORA-12505,TNS:listener does not currently know of SID given in connect descriptor
- ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- ORA-12505,TNS:listener does not currently know of SID given in connect descriptor
- ORA-12505, TNS:listener does not currently know of SID given in connect descriptor异常
- ORA-12505,TNS:listener does not currently know of SID given in connect descriptor
- 日经社説 20150630 アジア投資銀は透明な運営を
- MFC 根据圆心和半径画圆
- 科企通
- 我的WCF之旅(2):Endpoint Overview
- dialog底部自动弹出
- Spring+ibatis出现ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- 关于数据输入之先输入int数值在输入string的一些小问题
- js块元素和内联元素的种种恩怨
- 非常有用的 Oracle 查询语句
- rabbitMQ重启提示发生系统错误 5。 拒绝访问。
- Bolt的生命周期
- ckeditor 中文api
- iOS6新特征:UICollectionView介绍
- 慕课第四次学习总结