Hello All.
If its of interest to anyone, the problem was solved by our oracle
sup****t like this:
insert into pending_trans$ (
LOCAL_TRAN_ID,GLOBAL_TRAN_FMT,GLOBAL_ORACLE_ID,
STATE,STATUS,SESSION_VECTOR,RECO_VECTOR,TYPE#,FAIL_TIME,RECO_TIME)
values( '15.5.1005',
306206, /* */
'XXXXXXX.12345.1.2.3', /* These values can be used without any
*/
'prepared','P', /* modification. Most of the values are */
hextoraw( '00000001' ), /* constant. */
hextoraw( '00000000' ), /* */
0, sysdate, sysdate );
insert into pending_sessions$ values('15.5.1005',1,
hextoraw('05004F003A1500000104'),'C',0,30258592,'',146);
rollback force '15.5.1005';
execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('15.5.1005');
-------
Where '15.5.1005' is the ID of the transaction which was locked.
Cheers,
Krishnen
On May 12, 10:46=A0pm, "fitzjarr...@[EMAIL PROTECTED]
" <orat...@[EMAIL PROTECTED]
> wrote:
> 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=
TYPE =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 =
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
spec=
ified
> > > > > > 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 =
text -
>
> > - Show quoted text -
>
> I believe it should. =A0I 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- Hide quoted text -
>
> - Show quoted text -
|
