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-12899: value too large for column string (actual: string, maximum: string)

1 Answers  


ORA-01045: user string lacks CREATE SESSION privilege; logon denied

1 Answers  


NID-00105: Need to specify "LOGFILE=<logfile>" when using APPEND=YES option

1 Answers  


AMD-00140: internal error: [string] [string] [string] [string] [string]

1 Answers  


DRG-11214: execution of procedure filter stored procedure has failed

1 Answers  






ORA-23456: flavor string does not contain "string"

1 Answers  


ORA-03291: Invalid truncate option - missing STORAGE keyword

1 Answers  


AMD-00147: invalid Custom Measure creation mode "string" specified

1 Answers  


ORA-29314: tablespace 'string' is not OFFLINE FOR RECOVER nor READ ONLY

1 Answers  


NNL-01041: Data stream open failures: number

1 Answers  


ORA-02185: a token other than WORK follows COMMIT

1 Answers   IBM,


ORA-06316: IPA: Invalid database SID

1 Answers  


Categories