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-33213: (CINSERT06) The target position for MAINTAIN ADD or MAINTAIN MOVE cannot fall in the range of session-only values.

1 Answers  


ORA-08101: index key does not exist file string: (root string, node string) blocks (string)

1 Answers  


ORA-36341: (SNSYN130) The format of the PARTITIONCHECK function is: PARTITIONCHECK(aggmap, partition_template)

1 Answers  


RMAN-06000: could not open recovery manager library file: string

1 Answers  


AMD-00151: Creation of Custom Measure "string" in Workspace "string" failed

1 Answers  


TNS-01188: Listener cannot operate with incompatible transport protocols

1 Answers  


ORA-40103: invalid case-id column: string

1 Answers  


ORA-06430: ssaio: Seals do not match

1 Answers  


LPX-00242: invalid use of ampersand ('&') character (use &)

1 Answers  


ORA-29805: missing COLUMN keyword

1 Answers  


ORA-23472: materialized view "string"."string" must be atomically refreshed

1 Answers  


ORA-14321: cannot add/drop values to DEFAULT partition

1 Answers  


Categories