Re: ORA-0191

On May 12, 7:15 pm, "fitzjarr..._at_cox.net" <orat..._at_msn.com> wrote:
> On May 12, 11:29 am, krishnen <krishn..._at_gmail.com> wrote:
>
>
>
>
>
> > Hello David,
>
> > The following is displayed:
>
> > NAME                                 TYPE        VALUE
> > ------------------------------------ -----------
> > ------------------------------
> > distributed_transactions             integer     31
>
> > On May 12, 6:09 pm, "fitzjarr..._at_cox.net" <orat..._at_msn.com> wrote:
>
> > > 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- Hide quoted text -
>
> > > - Show quoted text -- Hide quoted text -
>
> > - Show quoted text -
>
> And on the server where the remote table exists?
>
> David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -

The same is displayed...
Will the following solve the problem??
execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('15.5.1005'); Received on Mon May 12 2008 - 12:27:58 CDT