From oracle-l-bounce@freelists.org Wed May 5 14:12:25 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i45JCAv13594 for ; Wed, 5 May 2004 14:12:20 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i45JC0613545 for ; Wed, 5 May 2004 14:12:10 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 26F4672D280; Wed, 5 May 2004 14:02:36 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 21566-08; Wed, 5 May 2004 14:02:36 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 691B872CF56; Wed, 5 May 2004 14:02:35 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 05 May 2004 14:01:12 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C531372D0AD for ; Wed, 5 May 2004 14:01:11 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 20777-47 for ; Wed, 5 May 2004 14:01:11 -0500 (EST) Received: from ahmler5.mail.eds.com (ahmler5.mail.eds.com [192.85.154.70]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E8BD772D0D0 for ; Wed, 5 May 2004 14:01:10 -0500 (EST) Received: from ahmlir4.mail.eds.com (ahmlir4-2.mail.eds.com [192.85.154.134]) by ahmler5.mail.eds.com (8.12.10/8.12.10) with ESMTP id i45JF1Ht030229 for ; Wed, 5 May 2004 15:15:01 -0400 Received: from ahmlir4.mail.eds.com (localhost [127.0.0.1]) by ahmlir4.mail.eds.com (8.12.10/8.12.10) with ESMTP id i45JE4fk006497 for ; Wed, 5 May 2004 15:14:04 -0400 Received: from USAHM102.amer.corp.eds.com (usahm102.exmi01.exch.eds.com [207.37.138.190]) by ahmlir4.mail.eds.com (8.12.10/8.12.10) with ESMTP id i45JE4Z3006490 for ; Wed, 5 May 2004 15:14:04 -0400 Received: by usahm102.exmi01.exch.eds.com with Internet Mail Service (5.5.2657.72) id ; Wed, 5 May 2004 15:14:10 -0400 Message-ID: <564DE4477544D411AD2C00508BDF0B6A1CE0AB15@usahm018.exmi01.exch.eds.com> From: "Powell, Mark D" To: "'oracle-l@freelists.org'" Subject: RE: ORA-02056: 2PC state machine: bad two-phase command number Date: Wed, 5 May 2004 15:14:05 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-type: text/plain; charset=iso-8859-1 X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 4488 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mark.powell@eds.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Based on the error information for the listed codes it would appear that Oracle should clean this up given some time. Did Oracle manage to clean this up or are repeated error messages showing in the alert log? $ oerr ora 02054 02054, 00000, "transaction %s in-doubt" // *Cause: network or remote failure in 2PC. // *Action: Notify operations; DBs will automatically re-sync when the // failure is repaired. Monitor pending_trans$ for final outcome. $ oerr ora 02056 02056, 00000, "2PC: %s: bad two-phase command number %s from %s" // *Cause: two-phase commit protocol error. // *Action: recovery of transaction attempted. Monitor pending_trans$ table to // ensure correct resolution. Contact support. If you have to clean this up manually then if you are using an undo tablespace be aware of a bug in versions 9.0, 9.1, and 9.2 that results in an ORA_30119 when you run dbms_transaction.PURGE_LOST_DB_ENTRY. If you hit it then you will probably need to check metalink for the bug and fix: alter session set "_smu_debug_mode" = 4; HTH -- Mark D Powell -- -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Singh, Ratnesh (GEI, GEFA, Contractor) Sent: Wednesday, May 05, 2004 2:29 PM To: oracle-l@freelists.org Subject: ORA-02056: 2PC state machine: bad two-phase command number 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@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 ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------