ora-02055 when insert data from Oracle8170 into remote Oracle 10g database using WAN

From: yang zhihong <boypoo_at_gmail.com>
Date: 16 Dec 2005 06:33:51 -0800
Message-ID: <1134743631.406735.59510@f14g2000cwb.googlegroups.com>

information:
Local database A:ibm f80 aix 4.3.3 + Oracle81700 local database B: ibm f85 aix 4.3.3 + Oracle81700 remote database C: Redhat EL3 + Oracle10.1.0.2

when i executed the following scripts at a, it raised errors.
==

DELETE sal018tg_at_idcdrp where fact='3300';

284503 行 已删除

SQL> commit

SQL> INSERT INTO sal018tg_at_idcdrp

  2                 (cust_no, prod_no, price, start_date, end_date,
sis_custno,
  3                  fact)
  4        SELECT cust_no, prod_no, price, start_date, end_date,
sis_custno, fact
  5          FROM sych_sal018tg;INSERT INTO sal018tg_at_idcdrp
               (cust_no, prod_no, price, start_date, end_date,
sis_custno,
                fact)
      SELECT cust_no, prod_no, price, start_date, end_date, sis_custno,
fact
        FROM sych_sal018tg

ORA-02055: distributed update operation failed; rollback required

ORA-02068: following severe error from IDCDRP ORA-03113: end-of-file on communication channel
==

during the insert operation, i queryed dba_2pc_pending ,returned no rows.
no any other errors in traces.

but i executed the same operations in b,it is proper.

thanks.

zhihong Received on Fri Dec 16 2005 - 08:33:51 CST