ORA-0191

From: krishnen <krishnenc_at_gmail.com>
Date: Mon, 12 May 2008 08:56:53 -0700 (PDT)
Message-ID: <4b2a2594-5354-48a7-af75-f0f3adce7047@27g2000hsf.googlegroups.com>


Hello All,

We are running an Oracel Forms system on the following platform: IBM AIX UNIX 4.33
Database Version: 8.1.7.4

End users are getting the following error when trying to select from a certain table.
ORA-0951 : LOCK Held by in-doubt distributed transaction 15.5.1005 No pending transactions were found in DBA_2PC_PENDING.

The DBA tried a rollback force on the transaction id string specified in the error message but the follwowing error was obtained: ORA-02058: no prepared transaction found with ID string.

Is there any solution to this problem??

Many Thanks,
Krishnen Received on Mon May 12 2008 - 10:56:53 CDT

Original text of this message