RE: reciving error ORA-01591 lock held by in-doubt distributed transaction string

Fadi,  

    What databases have remote access into yours? Any of them could be holding the lock. Has any server/remote db been bounced lately? Any network interruptions between servers? Lots of possibilities.     

Dick Goulet, Senior Oracle DBA

45 Bartlett St Marlborough, Ma 01752, USA Tel.: 508.573.1978 |Fax: 508.229.2019 | Cell:508.742.5795

RGoulet_at_kanbay.com
: POWERING TRANSFORMATION  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Fadi Hasweh Sent: Thursday, October 12, 2006 8:58 AM To: oracle-l
Subject: reciving error ORA-01591 lock held by in-doubt distributed transaction string

Dear support;  

I keep getting ORA-01591 lock held by in-doubt distributed transaction string

And I search all metalink for solution but could not find any help on it, I don't have any pending transactions. Do you have any hint?    

Thanks

Fadi  

"This email is intended for the above named adressee (s) only and may contain confidential and/or privilege information and should not be used by anyone who is not the original intended recipient(s). Any review, print, copy, reliance or distribution by others or forwarding without express permission is strictly prohibited If you have received this email in error, kindly notify the sender immediately by reply email and delete this email and any attachments from your mailbox or any other storage mechanism. Thank you.
Email transmission cannot be guaranteed to be secured or error free, as information could be intercepted, corrupted, lost, destroyed, received late or incomplete, or could contain viruses. The sender therefore does not accept liability for any error or omission in the contents of this message, which arises as a result of email transmission. Opinions, conclusions and other information in this message that do not relate to the official business of Umniah Mobile Company and is not its responsibility shall be understood as neither given nor endorsed by the organization."

--
http://www.freelists.org/webpage/oracle-l