oracle 3135,ORA-03135:ORA-02063:

Thu Apr 13 09:25:36 2017

Error 3135 trapped in 2PC on transaction 10.12.125379.

Cleaning up.

Thu Apr 13 09:25:36 2017

DISTRIB TRAN ZQZC.37cce578.10.12.125379

is local tran 10.12.125379

(hex=0a.0c.1e9c3)

insert pending collecting tran,

scn=15105179120502 (hex=dbc.f2d5f376)

Error stack returned to user:

ORA-02050:  10.12.125379 ijЩԶORA-03135:

ʧȥ

ORA-02063:

ine ( GDOSSDB2)

Thu Apr 13 09:26:09 2017

Error 3135 trapped in 2PC on transaction 1.32.63944. Cleaning

up.

Error stack returned to user:

ORA-02050:  1.32.63944 ijЩԶORA-03135: ʧȥ

ORA-02063: ine (

GDOSSDB2)

Thu Apr 13 09:26:09 2017

DISTRIB TRAN ZQZC.37cce578.1.32.63944

is local tran 1.32.63944

(hex=01.20.f9c8)

insert pending collecting tran,

scn=15105179124643 (hex=dbc.f2d603a3)

Thu Apr 13 09:27:11 2017

Error 3135 trapped in 2PC on transaction 11.7.129207. Cleaning

up.

Error stack returned to user:

ORA-02050:  11.7.129207 ijЩԶORA-03135:

ʧȥ

ORA-02063:

ine ( GDOSSDB2)

Thu Apr 13 09:27:11 2017

DISTRIB TRAN ZQZC.37cce578.11.7.129207

is local tran 11.7.129207

(hex=0b.07.1f8b7)

insert pending collecting tran,

scn=15105179125577 (hex=dbc.f2d60749)

Thu Apr 13 09:30:48 2017

Error 3135 trapped in 2PC on transaction 9.14.8649. Cleaning

up.

Error stack returned to user:

ORA-03135: ʧȥ

ORA-02063: ine ( GDOSSDB2)

Thu Apr 13 09:31:30 2017

Error 3135 trapped in 2PC on transaction 14.2.32415. Cleaning

up.

Error stack returned to user:

ORA-03135: ʧȥ

ORA-02063: ine ( GDOSSDB2)

Thu Apr 13 09:31:34 2017

Error 3135 trapped in 2PC on transaction 4.32.75252. Cleaning

up.

Error stack returned to user:

ORA-02050:  4.32.75252 ijЩԶORA-03135: ʧȥ

ORA-02063: ine (

GDOSSDB2)

Thu Apr 13 09:31:34 2017

DISTRIB TRAN ZQZC.37cce578.4.32.75252

is local tran 4.32.75252

(hex=04.20.125f4)

insert pending collecting tran,

scn=15105179175216 (hex=dbc.f2d6c930)

Thu Apr 13 09:33:08 2017

Error 3135 trapped in 2PC on transaction 5.3.93124. Cleaning

up.

Error stack returned to user:

ORA-03135: ʧȥ

ORA-02063: ine ( GDOSSDB2)

Thu Apr 13 09:38:08 2017

Error 3135 trapped in 2PC on transaction 35.0.2. Cleaning

up.

Error stack returned to user:

ORA-03135: ʧȥ

ORA-02063: ine ( GDOSSDB2)

处理方法：conn /as sysdba

select * from dba_2pc_pending

select * from dba_2pc_neighbors

select 'rollback force  ''' || LOCAL_TRAN_ID

|| ''';' || chr(10) ||

'execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY(''' ||

LOCAL_TRAN_ID

|| ''');' || chr(10) || 'commit;' from

DBA_2PC_PENDING;

rollback force  '1.32.63944';

execute

DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('1.32.63944');

commit;

rollback force  '10.12.125379';

execute

DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('10.12.125379');

commit;

rollback force  '11.7.129207';

execute

DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('11.7.129207');

commit;

rollback force  '4.32.75252';

execute

DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('4.32.75252');

commit;

rollback force  '16.0.28386';

execute

DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('16.0.28386');

commit;