Last update: 4 August 2017
This article describes the error message triggered as a result of a locked resource in a pending transaction as well as the solution.
"ORA-01591: lock held by in-doubt distributed transaction"
An attempt was made to access resource that is locked by a dead two-phase commit transaction that is in prepared state.
Warning: Please consider that the solution provided below requires a complete domain restart!
select * from sys.dba_pending_transactions
select * from dba_2pc_pending
while using an Oracle database