ORA_01591

[raztaboule]

hi !
i'm in troubles again....

since yesterday two tables are locked. a select count(*) returns :
ORA-01591: lock held by in-doubt distributed transaction 3.32.9139
As those tables are used for users connections they are very critical.

The following views are empty :
DBA_2PC_NEIGHBORS
DBA_2PC_PENDING
pending_sessions$
v$dblink

I try to run :
dbms_transcation.purge_lost_db_entry('3.32.9139') ;
and the result is :
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.DBMS_TRANSACTION", line 94

I was not here when the problem start but i found that in the udump :
ORA-00600: internal error code, arguments: [kcbgcur_9], [4195042], [4], [4294966224], [131072], [], [], []

and that in the bdump :
DISTRIB TRAN <a very long number> is local tran 3.32.9139 (hex=03.20.23b3) insert pending prepared tran, scn=272441637 (hex=0.103d2125)
both messages are generated at the same hour, the last one is generated by smon.

Still waiting oracle phone call,
Still trying to found a solution by myself
Hoping someone have a clue here !

Bye.

 

[raztaboule]

oracle support solves the problem recreating the rows in dba_2pc_pendings and neighbors and then replaying dbm_transaction.purge_lost_db_entry.
why this problem appends ? gremlins hidden somewhere....