2pc oracle dba_2pc_pending,dba_2pc_pending视图中的信息不清除会对以后有影响吗？如何根本解决问题？...

oracle9206+solaris9

alert日志信息：

Wed Jun 18 16:01:40 2008

Error 2068 trapped in 2PC on transaction 25.13.3300307. Cleaning up.

Error stack returned to user:

ORA-02050: transaction 25.13.3300307 rolled back, some remote DBs may be in-doubt

ORA-02068: following severe error from RADIUSC

ORA-12570: TNS:packet reader failure

Wed Jun 18 16:01:40 2008

DISTRIB TRAN BIMS.888c7a47.25.13.3300307

is local tran 25.13.3300307 (hex=19.0d.325bd3)

insert pending collecting tran, scn=26459977850 (hex=6.2923387a)

Wed Jun 18 16:02:18 2008

Wed Jun 18 16:17:28 2008

Error 2068 trapped in 2PC on transaction 3.12.10511774. Cleaning up.

Wed Jun 18 16:17:28 2008

DISTRIB TRAN BIMS.888c7a47.3.12.10511774

is local tran 3.12.10511774 (hex=03.0c.a0659e)

insert pending collecting tran, scn=26460503683 (hex=6.292b3e83)

ARC1: Completed archiving  log 1 thread 1 sequence 242783

Wed Jun 18 16:26:17 2008

Error stack returned to user:

ORA-02050: transaction 3.12.10511774 rolled back, some remote DBs may be in-doubt

ORA-02068: following severe error from RADIUSD

ORA-12570: TNS:packet reader failure

视图信息：

SQL> select LOCAL_TRAN_ID,STATE from dba_2pc_pending;

LOCAL_TRAN_ID          STATE

---------------------- ----------------

25.13.3300307          collecting

3.12.10511774          collecting

SQL> col LOCAL_TRAN_ID for a15

SQL> col IN_OUT for a10

col DATABASE for a10

col INTERFACE for a20

set line 132

SELECT LOCAL_TRAN_ID, IN_OUT, DATABASE, INTERFACE FROM DBA_2PC_NEIGHBORS;SQL> SQL> SQL> SQL>

LOCAL_TRAN_ID   IN_OUT     DATABASE   INTERFACE

--------------- ---------- ---------- --------------------

25.13.3300307   in                    N

3.12.10511774   in                    N

25.13.3300307   out        RADIUSA    N

25.13.3300307   out        RADIUSB    N

25.13.3300307   out        RADIUSC    N

25.13.3300307   out        RADIUSD    N

3.12.10511774   out        RADIUSA    N

3.12.10511774   out        RADIUSB    N

3.12.10511774   out        RADIUSD    N

3.12.10511774   out        RADIUSC    N

已选择10行。

视图里的信息不清除对以后的业务有影响吗？因为根据metalink.oracle.com操作，虽然我清除过了，但是一段时间后又会产生新的挂起信息。

SQL> alter session set "_smu_debug_mode" = 4;

会话已更改。

SQL> EXECUTE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('25.13.3300307');

PL/SQL 过程已成功完成。

SQL> commit;

如何根本解决问题？

[本帖最后由 jieyancai 于 2008-6-19 08:26 编辑]