TONGWEB在SERVER1
ORACLE在SERVER2
SERVER2是双网卡
JSP连接很不稳定
请问连接字穿该怎么写啊?出错信息:
java.sql.SQLException: 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: XXX.XXX.XXX.XXX:1521:SID
ORACLE在SERVER2
SERVER2是双网卡
JSP连接很不稳定
请问连接字穿该怎么写啊?出错信息:
java.sql.SQLException: 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: XXX.XXX.XXX.XXX:1521:SID
解决方案 »
- 大家来帮我解决一个查询的语句
- 问一个执行oracle存储过程的速度问题
- 又有新问题!!!
- 【如何程序打包的时候创建“用户,表,并添加一些数据”】
- 在数据库查询中,怎样规定日期区间?
- 如何创建DBLINK?
- oracle9i 的超级管理员sysman的密码忘记了,怎么找回来?
- 打算学oracle,安装oracle9i的简单问题,oracle9i能在xp professional 下安装吗?
- oracle 数据库查询问题
- 用gns解析scan vip后 ,已经启动rac 但是nslookup 解析不到已经生成的scan vip
- sql如何实现 把同城市年度一级天数最多的月份合并成一条记录。
- 写了个存储过程,有些问题,请专家帮忙看看
问题是有时候
network adapter could not estaption .....
有时又正常的
还是要报javax.servlet.ServletException: Io 异常: The Network Adapter could not establish the connection
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521))(LOAD_BALANCE=yes))(CONNECT_DATA=(SERVICE_NAME=xxx)))不会出现java.sql.SQLException: 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: XXX.XXX.XXX.XXX:1521:SID 了但是有时会出现javax.servlet.ServletException: Io 异常: The Network Adapter could not establish the connection连接时,问题出现的情况几乎是1/2
我搞错了
双机SID和单机的SID不一样
现在可以了
谢谢大家