I had a similiar problem a few years ago. I got an ORA-01591 "lock held =
by
in-doubt distributed transaction nnn"
To fix this match the transaction number in the message with the
GLOBAL_TRAN_ID in DBA_2PC_PENDING table and either rollback or commit =
the
transaction.
ROLLBACK FORCE '6.7.43497' ; or
COMMIT FORCE '6.7.43497';
> -----Original Message-----
> From: cyhu_at_eachnet.com [SMTP:cyhu_at_eachnet.com]
> Sent: Friday, April 28, 2000 1:33 AM
> To: Multiple recipients of list ORACLE-L
> Subject: How to delete in-doubt transactions
>=20
> I found a in-doute transaction through Instance Manager. The =
application
> could not query a table which was dead-locked by this in-doubt
> transaction.
> I knew nothing to clear this. I had to shutdown the instance. After =
that,
> everything is ok.Below is part of trace file.
>=20
> *** SESSION ID:(8.6) 2000.04.28.09.58.22.000
> DISTRIB TRAN
> =
28.747578320000000000000000000000000000000000000000000000000000000016B90=
70
> 04409F938128E9100
> is local tran 6.7.43497 (hex=3D06.07.a9e9)
> change pending prepared tran, scn=3D9377247 (hex=3D0.008f15df)
> to pending collecting tran, scn=3D9377247 (hex=3D0.008f15df)
> DISTRIB TRAN
> =
28.747578320000000000000000000000000000000000000000000000000000000016B90=
70
> 04409F938128E9100
> is local tran 6.7.43497 (hex=3D06.07.a9e9))
> delete pending collecting tran, scn=3D9377247 (hex=3D0.008f15df)
>=20
> Thank in advance.
> =BA=FA=B4=BA=D3=EA
> =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
> Tel:(8621)52340871/0872*667
> E-mail:cyhu_at_eachnet.com
> =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
> =02=EBa=A2=B2
> =
=1172=86=E7=9Ar=19=DE=B5=CA&=15=ABB=8A=DC=8Dz=DC(=AED=9E=AE=F8=9Cz=CF9=F3=
=9D=FC=E7Nu=14=05=FC=E7=CEw=F3=9D9=D5&=A7=0E'=A0=A0&=A5=89=FA+=9E&=8F=B9=
=B9bp=89=EDz=B9=DE=B5=A7=1Cz
> =CB?1=A8=A5=8Ax
> =
=8A=CBlN=84D0=E5D=CA=8B=AB=B1=E9_~=BA&=B6=18=AC=99=A8=A5=8Ax%=8A=CBlzwZ=9C=
C=1A=8AY=9E=B2=C6=A0z=DA=0B=8A=CBF=BA=BB=9Fj=D7"=B7'(=9Az-xE=C0 ;)zYb?
> =
=1F.+-=1A=EA=EEjwb=9E=D8^=99=EB,j=07=8186"=9D=C9nu=E6=A5=8Aw=9C=A2{Z=8Ax=
Received on Fri Apr 28 2000 - 10:56:02 CDT
