Hello David,
The following is displayed:
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
distributed_transactions integer 31
On May 12, 6:09=A0pm, "fitzjarr...@[EMAIL PROTECTED]
" <orat...@[EMAIL PROTECTED]
> wrote:
> On May 12, 10:56=A0am, krishnen <krishn...@[EMAIL PROTECTED]
> 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 =A0distributed 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 -
|
