Oracle Error Message
ORA-01591: lock held by in-doubt distributed transaction string
Reason for the Error
Trying to access resource that is locked by a dead two-phase commit transaction that is in prepared state.
Solution
DBA 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, DBA should contact DBA at commit point if known or 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.
