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-07707: error in archive text: need tape label name

1 Answers  


ORA-12705: invalid or unknown NLS parameter value specified

1 Answers  


SQL*Loader-00527: OCI return status: no data

1 Answers  


ORA-32340: cannot tune the materialized view definition

1 Answers  


LSX-00102: duplicate element "~S"

1 Answers  


RMAN-06180: incremental backups require Enterprise Edition

1 Answers  


ORA-01628: max # extents (string) reached for rollback segment string

1 Answers  


ORA-14031: partitioning column may not be of type LONG or LONG RAW

1 Answers  


NNO-00303: server "string" started with process ID number

1 Answers  


ORA-22314: method information mismatch in ALTER TYPE

1 Answers  


ORA-19205: Attribute 'string' qualifies a non-scalar value in the select list

1 Answers  


EXP-00039: export file string must be on a disk

1 Answers  


Categories