ORA-02056: 2PC state machine: bad two-phase command number

From: Singh, Ratnesh (GEI, GEFA, Contractor) <Ratnesh.Singh_at_ge.com>
Date: Wed, 5 May 2004 14:28:55 -0400
Message-ID: <53C7726C165C4B46B5470C1A20EDBC4A02942B2D@LYHMLVEM01.e2k.ad.ge.com>

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.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed May 05 2004 - 13:26:28 CDT