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-16170: Terminal recovery may have left the database in an inconsistent state

1 Answers  


DRG-12212: error while dropping section string

1 Answers  


ORA-24390: Unsupported scrollable cursor operation

1 Answers  


ORA-36906: (XSAGDNGL45) 4. Model only includes one non-step dimension in the equations.

1 Answers  


ORA-00311: cannot read header from archived log

1 Answers  


QSM-01007: query has NOREWRITE hint

1 Answers  


ORA-31009: Access denied for property string

1 Answers  


ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke

1 Answers  


NZE-28841: Operation is not supported.

1 Answers  


ORA-19599: block number string is corrupt in string string

1 Answers  


ORA-15002: parameter LOCK_NAME_SPACE exceeds limit of string characters

1 Answers  


DRG-11207: user filter command exited with status string

1 Answers  


Categories