OCI-01591
lock held by in-doubt distributed transaction string
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.
OCI-01591
lock held by in-doubt distributed transaction string
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.
OCI-01591
lock held by in-doubt distributed transaction string
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.
