Oracle 11G数据库报错 :ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
来源:互联网 发布:java if else 简写 编辑:程序博客网 时间:2024/05/16 12:48
本人在做Oracle11G的数据库迁移的时候,报错如下:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
172.1.3.111:1521:eq_test……
我的数据库net manager 配置如下:
,
在数据库服务器上,该数据库的服务名如下:
而在配置jdbc.properties 文件里我是这样写的:
datasource.url_meta_rw_0=jdbc:oracle:thin:@172.16.113.13:1522:eq_test
datasource.username_meta_rw_0=earth_meta
datasource.password_meta_rw_0=123456
然后在启动项目的时候就报出上述错误。
把jdbc.properties的配置文件修改如下:
datasource.url_meta_rw_0=jdbc:oracle:thin:@172.16.113.13:1522:earthtest
datasource.username_meta_rw_0=earth_meta
datasource.password_meta_rw_0=123456
重启TNSListener后,问题解决了。
故:这里面的数据库名,应该和服务名称一致的,这个服务是指“我的电脑”里的“服务”,不是数据库里配置的服务名。
- Oracle 11G数据库报错 :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
- Oracle - 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
- 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异常
- ORA-12505,TNS:listener does not currently know of SID given in connect descriptor
- which
- Jquery 回车触发按钮事件
- 经典的网络管理命令
- 由西门庆勾引潘金莲看营销技巧、谈判策略
- 早餐5种吃法让女人更年轻
- Oracle 11G数据库报错 :ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- net命令详解
- Android游戏框架AndEngine使用入门
- 关于ling-sql的写法
- linux c方式 从www.ip138.com获取IP数据
- 再次写给我们这些浮躁的程序员
- 关于cocos2d-x中CCScrollView和CCMenu触摸优先级的解决方案
- 修改JRE system library
- 【小蒙淘金】2.26早评-黄金白银行情分析及部分操作建议