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



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

Post New Answer

More Oracle Errors Interview Questions

NNL-00305: Server dumping statistics to the log file

1 Answers  


ORA-23331: column group string does not exist

1 Answers  


ORA-06565: cannot execute string from within stored procedure

1 Answers  


IMP-00019: row rejected due to ORACLE error number

1 Answers  


IMP-00079: Warning: National character set data in this table may be incorrect

1 Answers  






TNS-12215: TNS:poorly formed PREFERRED_NAVIGATORS Addresses in TNSNAV.ORA

1 Answers  


ORA-02821: Unable to read the requested number of blocks.

1 Answers  


DRG-10001: can not access result table string

1 Answers  


ORA-06265: NETNTT: break protocol error

1 Answers  


ORA-07570: szrfc: $IDTOASC failure

1 Answers  


PCC-02081: CMD-LINE: Unterminated option value list or value list was truncated.

1 Answers  


LSX-00016: schema and instance document have incompatible character sets

1 Answers  


Categories