【求助,在线等】Java连oracle报sid错误

angleretar 2013-07-24 11:22:16
数据库信息:

jjhww =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.200.11)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = wrac)
(INSTANCE_NAME = wrac1)
)
)

用户名和密码:

yycms cfpayycms


Java程序:

String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@192.168.200.11:1521:wrac";
String user = "yycms";
String pwd = "cfpayycms";


报错信息:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
172.16.200.11:1521:wrac


who can tell me why why why????
plsql可以连接啊
...全文
29 点赞 收藏 3
写回复
3 条回复
切换为时间正序
当前发帖距今超过3年,不再开放新的回复
发表回复
shy315 2013-07-24
(DESCRIPTION = (ADDRESS = (PROTOCOL ... java换行不方便,当然留着也没问题
回复
angleretar 2013-07-24
哪儿的换行啊?
回复
shy315 2013-07-24
jdbc:oracle:thin:@(DESCRIPTION =...) 把换行去掉即可。
回复
相关推荐
发帖
Oracle
创建于2007-09-28

1.6w+

社区成员

Oracle开发相关技术讨论
申请成为版主
帖子事件
创建了帖子
2013-07-24 11:22
社区公告
暂无公告