Oracle DB Error ORA-01591 lock held by in-doubt distributed transaction string

The following is the cause of this error:

An attempt was made to access resource that is locked by a dead two-phase commit transaction that is in prepared state.

Action you can take to resolve this issue: The database administrator should query the PENDING_TRANS$ and related tables, and attempt to repair network connection(s) to coordinator and commit point. If timely repair is not possible, the database administrator should contact the database administrator at the commit point if known or the end user for correct outcome, or use heuristic default if given to issue a heuristic COMMIT or ABORT command to finalize the local portion of the distributed transaction.

Tags: Database, Education, Software

Related