Shulou(Shulou.com)06/01 Report--

one。 Error message

Sun Oct 28 00:46:33 2018Error 3113 trapped in 2PC on transaction 644.3.881743. Cleaning up.Error stack returned to user:ORA-02054: transaction 644.3.881743 in-doubtORA-03113: end-of-file on communication channelORA-02063: preceding line from KMESBASun Oct 28 00:46:34 2018DISTRIB TRAN OMES.2b7345a.644.3.881743 is local tran 644.3.881743 (hex=284.03.d744f) insert pending prepared tran, scn=14593464857025 (hex=d45.ce49f1c1)

two。 Analysis.

Such problems are usually due to network problems or distributed transaction failures caused by remote database exceptions.

Execute the following SQL statement

Select LOCAL_TRAN_ID,GLOBAL_TRAN_ID,STATE,MIXED,HOST,COMMIT# from dba_2pc_pending;#dba_2pc_pending view records information about distributed transactions waiting to be recovered select * from DBA_2PC_NEIGHBORS;# view records input and output connection information for outstanding distributed transactions

three。 Deal with

1. If a record is queried in the above view, try force commit/rollback

Commit force '644.3.881743'

two。 If unsuccessful, do the following

(1) .disable distributed recovery SQL > ALTER SYSTEM DISABLE DISTRIBUTED RECOVERY;System altered. (2). Puege (clear) in-doubt transaction entry:SQL > exec DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY ('644.3.881743'); PL/SQL procedure successfully completed. (3)。 Then enable distributed recovery: SQL > ALTER SYSTEM ENABLE DISTRIBUTED RECOVERY

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.