Hi All,
In 11gR2 database. I get the following error. I just search at google and I have find many web sites to explain this issue. I have done many things. However, I couldn't solve the problem. I did restart the database but I still get the same error. What do you recommend?
ORA-01591: lock held by in-doubt distributed transaction 485.22.432818
The following code also gives ORA-01453 error.
EXEC DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('485.22.432818');
The following query gives no row.
>>SELECT * FROM dba_2pc_pending where local_tran_id = '485.22.432818';
>>
Thanks in advance