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

ORA-12452: label tag string already exists

1 Answers  


ORA-02032: clustered tables cannot be used before the cluster index is built

1 Answers  


PLS-01406: An identifier has been found that is considered a keyword in ANSI's grammar but not in PL/SQL's

1 Answers  


ORA-13443: GeoRaster metadata SRS error

1 Answers  


ORA-08194: Flashback Table operation is not allowed on materialized views

1 Answers  






ORA-28153: Invalid client initial role specified: 'string'

1 Answers  


PCC-00033: Missing operand for option "string"

1 Answers  


RMAN-06074: file string is not an ORACLE datafile

1 Answers  


ORA-23358: invalid remote user

1 Answers  


ORA-37070: You may not execute OLAP DML programs in a parallel query session.

1 Answers  


LSX-00164: no content specified in "~S"

1 Answers  


ORA-17610: file 'string' does not exist and no size specified

1 Answers  


Categories