On May 12, 12:27=A0pm, krishnen <krishn...@[EMAIL PROTECTED]
> wrote:
> On May 12, 7:15=A0pm, "fitzjarr...@[EMAIL PROTECTED]
" <orat...@[EMAIL PROTECTED]
> wrote:
>
>
>
>
>
> > On May 12, 11:29=A0am, krishnen <krishn...@[EMAIL PROTECTED]
> wrote:
>
> > > Hello David,
>
> > > The following is displayed:
>
> > > NAME =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0
T=
YPE =A0 =A0 =A0 =A0VALUE
> > > ------------------------------------ -----------
> > > ------------------------------
> > > distributed_transactions =A0 =A0 =A0 =A0 =A0 =A0 integer =A0 =A0 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
fr=
om a
> > > > > certain table.
> > > > > ORA-0951 : LOCK Held by in-doubt =A0distributed transaction
15.5.1=
005
> > > > > No pending transactions were found in DBA_2PC_PENDING.
>
> > > > > The DBA tried a rollback force on the transaction id string
specif=
ied
> > > > > 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');- Hide quoted
te=
xt -
>
> - Show quoted text -
I believe it should. I wanted to see if both sides of the transaction
were allowing distributed transactions since I have experienced a
similar issue when one side was configured for distributed transaction
processing and one side was not.
David Fitzjarrell
|
