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-06530: Reference to uninitialized composite

1 Answers  


SQL*Loader-00939: OCI error while string for table string partition string

1 Answers  


ORA-09910: Unable to find ORACLE password file entry for user.

2 Answers  


SQL*Loader-00121: Invalid skip_unusable_indexes option

1 Answers  


NCR-03009: NCRO: Protocol version mismatch

1 Answers  


ORA-09809: Unable to get user's group ID from connection

1 Answers  


ORA-36664: (XSDPART02) You must specify a partitioning method and one or more partition dimensions when defining a PARTITION TEMPLATE.

1 Answers  


TNS-01303: ns main err code: number

1 Answers  


AMD-00120: dimension #string: analytic workspace dimension name not specified

1 Answers  


EXP-00029: Incremental export mode and consistent mode are not compatible

1 Answers  


SQL*Loader-00801: all INTO TABLE clauses must have the same options (string)

1 Answers  


NNL-00522: Removes a data item from a name by value or by type

1 Answers  


Categories