数据库信息: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可以连接啊
(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可以连接啊
解决方案 »
- CRS-0184: Cannot communicate with the CRS daemon. RAC重启错误
- oracle不能录入中文
- 关于oracle启动的三个阶段问题理解
- Oracle 11g忘了设置口令,现在登陆不上去,怎么办
- spool导出200万记录的话,需要多少时间呀?
- oracle报错 急求正解~!!!
- 一道数据库题,!!高手请帮忙,给分
- 视图创建问题
- 有windows下pro*c开发经验的大侠请进,有问题请教
- 初学者问题,请教了
- com.inspur.trans.exceptions.DaoException: ORA-00933: SQL 命令未正确结束
- 大神 看看我的游标错在哪里啊?
把换行去掉即可。
java换行不方便,当然留着也没问题