In this post, you’ll learn more about the Oracle ErrorORA-01591: lock held by in-doubt distributed transaction string with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-01591: lock held by in-doubt distributed transaction string
Reason for the Error ORA-01591: lock held by in-doubt distributed transaction string
Trying to access resource that is locked by a dead two-phase commit transaction that is in prepared state.
How to fix the Error ORA-01591: lock held by in-doubt distributed transaction string ?
You can fix this error in Oracle by following the below steps
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.