Oracle® Database 11g / 12c / 18c error codes ORA-01591: lock held by in-doubt distributed transaction [string]

ORA-01591: lock held by in-doubt distributed transaction [string]

Oracle Error Code: ORA-01591

Cause: Trying to access resource that is locked by a dead two-phase commit transaction that is in prepared state.

Action: 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.