求助:使用DBLINK时,报ORA-02050: 事务处理 16.0.600 已回退, 某些远程数据库可能有问题;ORA-03135: 连接失去联系
问题现象:有两台数据库服务器oracle11g,分别有两个用户user1,user2,java应用通过proxool连接池连接到user1(EASDB),user1通过DBLINK去连接user2进行数据库查询。
报错如下:
java.sql.SQLException: ORA-02050: 事务处理 16.0.600 已回退, 某些远程数据库可能有问题
ORA-03135: 连接失去联系
ORA-02063: 紧接着 line (起自 EASDB)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Ocommoncall.receive(Ocommoncall.java:140)
at oracle.jdbc.ttc7.TTC7Protocol.logoff(TTC7Protocol.java:396)
at oracle.jdbc.driver.OracleConnection.close(OracleConnection.java:1524)
at org.logicalcobwebs.proxool.ProxyConnection.reallyClose(ProxyConnection.java:192)
at org.logicalcobwebs.proxool.ConnectionPool.removeProxyConnection(ConnectionPool.java:429)
at org.logicalcobwebs.proxool.ConnectionPool.expireProxyConnection(ConnectionPool.java:462)
at org.logicalcobwebs.proxool.HouseKeeper.sweep(HouseKeeper.java:106)
at org.logicalcobwebs.proxool.HouseKeeperThread.run(HouseKeeperThread.java:39)
2012-11-29 12:59:45 [ HouseKeeper:72084195 ] - [ ERROR ] #0046 encountered errors during destruction:
其他说明:
这个现象不是每次查询都出现,时有时无,一些查询会失败;会不会是网络不稳定导致?
麻烦高手指导指导,谢谢!