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 11g 下载 中文版 下载啊!!
- 求Oracle版高手帮助,SQL执行效率分析
- (100分)禁用索引报错:ORA-02243: ALTER INDEX 或 ALTER MATERIALIZED VIEW 选项无效
- 问个很浅的问题
- oracle导出问题
- 问一下下面这两种Oracle分页哪种写法是对的
- 表的锁定问题
- 在windows2000Professionnel上可以安装Oraccle9i吗?
- 不同数据库,不同表结构迁移
- sql语句一直在执行,求大神告知其原因。万分感谢!!!
- 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不一样
现在可以了
谢谢大家