FAQ
Hi=20

this error happened on our prodn boxes, causing indoubt transactions.
Metalink does not seem to have much info on this.=20

It mentioned distributed_lock_timeout, which we have set at 180. =20
Does it need to be higher ?
Anybody seen this error, and knows what it is ?

Wed May 5 13:24:23 2004
Error 2056 trapped in 2PC on transaction 28.5.51628. Cleaning up.
Error stack returned to user:
ORA-02054: transaction 28.5.51628 in-doubt
ORA-02056: 2PC: 2PC state machine: bad two-phase command number 0 from =

prepared state(2)

Wed May 5 13:24:23 2004
DISTRIB TRAN =
1bba9.00000001C04EE8141C217F36843978DB9D51740BD3010ED5128B4F68
is local tran 28.5.51628 (hex=3D1c.05.c9ac)
insert pending prepared tran, scn=3D1064404425 (hex=3D0.3f7185c9)

thanks & regards
ratnesh=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 3 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedMay 5, '04 at 1:26p
activeMay 5, '04 at 2:45p
posts3
users2
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase