ORA-01591: lock held by in-doubt distributed transaction string
Answer / guest
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.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 1 No |
ORA-16170: Terminal recovery may have left the database in an inconsistent state
DRG-12212: error while dropping section string
ORA-24390: Unsupported scrollable cursor operation
ORA-36906: (XSAGDNGL45) 4. Model only includes one non-step dimension in the equations.
ORA-00311: cannot read header from archived log
QSM-01007: query has NOREWRITE hint
ORA-31009: Access denied for property string
ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke
NZE-28841: Operation is not supported.
ORA-19599: block number string is corrupt in string string
ORA-15002: parameter LOCK_NAME_SPACE exceeds limit of string characters
DRG-11207: user filter command exited with status string