| Re :ORA-01591 lock held by in-doubt distributed transaction string [message #58875] |
Wed, 08 October 2003 09:29  |
Raymond
Messages: 30
Registered: September 2000
|
Member |
|
|
Dear Guru.
Just recently one of our banking customer OS390 have hit this error ? We try to be on site to investigate the problem . It only happen during BDS peak-period. What might be the cause of this error ? Initially we have set the Init.ora {Process = 500}
We ask Oracle (malaysia) the solution is to use rollback force 'trnid' , at the dba_2pc_pending the record show the status as "force rollback" but how to i know whether which record is being rollback ?
This problem is being resolve after we advise our customer to increase the Process/User to 700. Based on our monitoring is the total session at v$session is approx 49X. But only 2x is active and 47x session is inactive.
Any help ?
|
|
|
|
| Re: Re :ORA-01591 lock held by in-doubt distributed transaction string [message #58879 is a reply to message #58875] |
Wed, 08 October 2003 15:18  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
ORA-01591 lock held by in-doubt distributed transaction string
Cause: An attempt was made to access resource that is locked by a dead two-phase commit transaction that is in prepared state.
Action: The database administrator 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, the database administrator should contact the database administrator at the commit point if known or the 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
