Re: ORA-0191

On May 12, 10:56 am, krishnen <krishn..._at_gmail.com> wrote:
> 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

What does 'show parameter dist' display?

David Fitzjarrell Received on Mon May 12 2008 - 11:09:30 CDT