This discussion is archived
4 Replies Latest reply: Dec 9, 2012 9:04 PM by CoolBond RSS

求助:使用DBLINK时,报ORA-02050: 事务处理 16.0.600 已回退, 某些远程数据库可能有问题;ORA-03135: 连接失去联系

CoolBond Newbie
Currently Being Moderated
问题现象:有两台数据库服务器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:

其他说明:
这个现象不是每次查询都出现,时有时无,一些查询会失败;会不会是网络不稳定导致?
麻烦高手指导指导,谢谢!
  • 1. Re: 求助:使用DBLINK时,报ORA-02050: 事务处理 16.0.600 已回退, 某些远程数据库可能有问题;ORA-03135: 连接失去联系
    LiuMaclean(刘相兵) Expert
    Currently Being Moderated
    2套库 各具体是什么版本?

    给出reco 后台进程的trace

    给出这2条机器间的 ping 、 tracert 信息
  • 4. Re: 求助:使用DBLINK时,报ORA-02050: 事务处理 16.0.600 已回退, 某些远程数据库可能有问题;ORA-03135: 连接失去联系
    CoolBond Newbie
    Currently Being Moderated
    今天早上刚刚报了相同的错,我收集了下信息
    补充现象:EASDB是从132.97.122.97 到132.97.122.1 的DBlink,反向的DBlink没有出现类似错误
    bppfrdb1_reco_18133.trc如下:
    *** 2012-12-07 18:25:11.899
    DISTRIB TRAN BPPFRDB.59c536a9.49.11.975
    is local tran 49.11.975 (hex=31.0b.3cf))
    delete pending collecting tran, scn=13074738503199 (hex=be4.3324de1f)
    DISTRIB TRAN BPPFRDB.59c536a9.31.13.2318

    *** 2012-12-10 10:44:58.406
    is local tran 31.13.2318 (hex=1f.0d.90e))
    delete pending collecting tran, scn=13074744375475 (hex=be4.337e78b3)
    DISTRIB TRAN BPPFRDB.59c536a9.10.30.100680

    *** 2012-12-10 11:00:39.084
    is local tran 10.30.100680 (hex=0a.1e.18948))
    delete pending collecting tran, scn=13074744378110 (hex=be4.337e82fe)

    alert_bppfrdb1.log如下:
    Mon Dec 10 07:00:40 2012
    Archived Log entry 3865 added for thread 1 sequence 1842 ID 0x9a632295 dest 1:
    Mon Dec 10 07:59:53 2012
    Time drift detected. Please check VKTM trace file for more details.
    Mon Dec 10 09:58:21 2012
    Error 3135 trapped in 2PC on transaction 10.30.100680. Cleaning up.
    Error stack returned to user:
    ORA-02050: 事务处理 10.30.100680 已回退, 某些远程数据库可能有问题
    ORA-03135: 连接失去联系
    ORA-02063: 紧接着 line (起自 EASDB)
    Mon Dec 10 09:58:21 2012
    DISTRIB TRAN BPPFRDB.59c536a9.10.30.100680
    is local tran 10.30.100680 (hex=0a.1e.18948)
    insert pending collecting tran, scn=13074744378110 (hex=be4.337e82fe)
    Mon Dec 10 10:44:58 2012
    DISTRIB TRAN BPPFRDB.59c536a9.31.13.2318
    is local tran 31.13.2318 (hex=1f.0d.90e))
    delete pending collecting tran, scn=13074744375475 (hex=be4.337e78b3)
    Mon Dec 10 11:00:39 2012
    DISTRIB TRAN BPPFRDB.59c536a9.10.30.100680
    is local tran 10.30.100680 (hex=0a.1e.18948))
    delete pending collecting tran, scn=13074744378110 (hex=be4.337e82fe)

    ***********************************************************************

    Fatal NI connect error 12170.

    VERSION INFORMATION:
    TNS for Linux: Version 11.2.0.3.0 - Production
    Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
    TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
    Time: 10-DEC-2012 11:41:59
    Tracing not turned on.
    Tns error struct:
    ns main err code: 12535

    TNS-12535: TNS:operation timed out
    ns secondary err code: 12560
    nt main err code: 505

    TNS-00505: Operation timed out
    nt secondary err code: 110
    nt OS err code: 0
    Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=132.97.122.113)(PORT=47823))
    Mon Dec 10 11:41:59 2012
    ***********************************************************************

    Fatal NI connect error 12170.

    VERSION INFORMATION:
    TNS for Linux: Version 11.2.0.3.0 - Production
    Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
    TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
    Time: 10-DEC-2012 11:41:59
    Tracing not turned on.
    Tns error struct:
    ns main err code: 12535

    TNS-12535: TNS:operation timed out
    ns secondary err code: 12560
    nt main err code: 505

    TNS-00505: Operation timed out
    nt secondary err code: 110
    nt OS err code: 0
    Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=132.97.122.113)(PORT=47824))
    Mon Dec 10 11:41:59 2012


    ***********************************************************************
    ping的输出信息如下:
    [oracle@bppfrdb1 jc]$ ping -s 1024 -c 30 132.97.122.1
    PING 132.97.122.1 (132.97.122.1) 1024(1052) bytes of data.
    1032 bytes from 132.97.122.1: icmp_seq=1 ttl=64 time=0.473 ms
    1032 bytes from 132.97.122.1: icmp_seq=2 ttl=64 time=0.543 ms
    1032 bytes from 132.97.122.1: icmp_seq=3 ttl=64 time=0.622 ms
    1032 bytes from 132.97.122.1: icmp_seq=4 ttl=64 time=0.538 ms
    1032 bytes from 132.97.122.1: icmp_seq=5 ttl=64 time=0.570 ms
    1032 bytes from 132.97.122.1: icmp_seq=6 ttl=64 time=0.544 ms
    1032 bytes from 132.97.122.1: icmp_seq=7 ttl=64 time=0.511 ms
    1032 bytes from 132.97.122.1: icmp_seq=8 ttl=64 time=0.550 ms
    1032 bytes from 132.97.122.1: icmp_seq=9 ttl=64 time=0.469 ms
    1032 bytes from 132.97.122.1: icmp_seq=10 ttl=64 time=0.574 ms
    1032 bytes from 132.97.122.1: icmp_seq=11 ttl=64 time=0.568 ms
    1032 bytes from 132.97.122.1: icmp_seq=12 ttl=64 time=0.632 ms
    1032 bytes from 132.97.122.1: icmp_seq=13 ttl=64 time=0.522 ms
    1032 bytes from 132.97.122.1: icmp_seq=14 ttl=64 time=0.420 ms
    1032 bytes from 132.97.122.1: icmp_seq=15 ttl=64 time=0.474 ms
    1032 bytes from 132.97.122.1: icmp_seq=16 ttl=64 time=0.506 ms
    1032 bytes from 132.97.122.1: icmp_seq=17 ttl=64 time=0.573 ms
    1032 bytes from 132.97.122.1: icmp_seq=18 ttl=64 time=0.582 ms
    1032 bytes from 132.97.122.1: icmp_seq=19 ttl=64 time=0.496 ms
    1032 bytes from 132.97.122.1: icmp_seq=20 ttl=64 time=0.520 ms
    1032 bytes from 132.97.122.1: icmp_seq=21 ttl=64 time=0.517 ms
    1032 bytes from 132.97.122.1: icmp_seq=22 ttl=64 time=0.609 ms
    1032 bytes from 132.97.122.1: icmp_seq=23 ttl=64 time=0.505 ms
    1032 bytes from 132.97.122.1: icmp_seq=24 ttl=64 time=0.527 ms
    1032 bytes from 132.97.122.1: icmp_seq=25 ttl=64 time=0.532 ms
    1032 bytes from 132.97.122.1: icmp_seq=26 ttl=64 time=0.613 ms
    1032 bytes from 132.97.122.1: icmp_seq=27 ttl=64 time=0.537 ms
    1032 bytes from 132.97.122.1: icmp_seq=28 ttl=64 time=0.500 ms
    1032 bytes from 132.97.122.1: icmp_seq=29 ttl=64 time=0.565 ms
    1032 bytes from 132.97.122.1: icmp_seq=30 ttl=64 time=0.519 ms

    --- 132.97.122.1 ping statistics ---
    30 packets transmitted, 30 received, 0% packet loss, time 29005ms
    rtt min/avg/max/mdev = 0.420/0.537/0.632/0.048 ms

    traceroute信息如下:
    [oracle@bppfrdb1 jc]$ traceroute 132.97.122.1 -p 1521

    traceroute to 132.97.122.1 (132.97.122.1), 30 hops max, 60 byte packets
    1 132.97.122.1 (132.97.122.1) 0.803 ms 0.785 ms 0.772 ms


    traceroute to 132.97.122.1 (132.97.122.1), 30 hops max, 60 byte packets
    1 132.97.122.1 (132.97.122.1) 0.560 ms 0.543 ms 0.533 ms

    traceroute to 132.97.122.1 (132.97.122.1), 30 hops max, 60 byte packets
    1 132.97.122.1 (132.97.122.1) 0.462 ms 0.456 ms *

    traceroute to 132.97.122.1 (132.97.122.1), 30 hops max, 60 byte packets
    1 132.97.122.1 (132.97.122.1) 0.740 ms 0.741 ms 0.733 ms

    traceroute to 132.97.122.1 (132.97.122.1), 30 hops max, 60 byte packets
    1 132.97.122.1 (132.97.122.1) 0.350 ms * *

    traceroute to 132.97.122.1 (132.97.122.1), 30 hops max, 60 byte packets
    1 132.97.122.1 (132.97.122.1) 0.602 ms 0.587 ms 0.580 ms


    traceroute to 132.97.122.1 (132.97.122.1), 30 hops max, 60 byte packets
    1 132.97.122.1 (132.97.122.1) 0.757 ms 0.745 ms *



    另外,也把日志发送到你的邮箱了,
    麻烦你指导一下,谢谢!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points