Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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-26017: global indexes not allowed for direct path load of table partition string

1 Answers  


ORA-12413: labels do not belong to the same policy

1 Answers  


ORA-31640: unable to open dump file "string" for read

1 Answers  


RMAN-08586: output filename=string tag=string recid=string stamp=string

1 Answers  


DRG-11519: encounter error when exporting a LONG or LONG RAW column

1 Answers  


LFI-00144: File [string][string] does not exist

1 Answers  


ORA-24310: length specified for null connect string

1 Answers  


NPL-00100: cannot initialize ASN.1 context

1 Answers  


ORA-22056: value [string] is divided by zero

1 Answers  


ORA-01891: Datetime/Interval internal error

1 Answers  


TNS-01187: No proxy service handler available

1 Answers  


NNL-00811: Fastest query processing time: string

1 Answers  


Categories