|
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 编辑 ] |
|