Forum Stats

  • 3,759,940 Users
  • 2,251,618 Discussions
  • 7,870,876 Comments

Discussions

ORA-02056: 2PC: k2lcom: bad two-phase command number rdonly from coord

Raheleh
Raheleh Member Posts: 17 Blue Ribbon
edited Oct 3, 2021 5:45AM in Database Upgrade

Hi,

After the upgrade from 12.1 to 19.12, I got this error when executed this procedure:

USER1:

create database link DBLINK1 connect to R1 using 'GUARD1';

create view USER1.TABLE1 as select * from [email protected];


USER2:

create database link DBLINK1 connect to R1 using 'GUARD1';

create view USER2.TABLE2 as select * from [email protected];


USER3:

create or replace procedure USER3.PRC1(loan in number,

                    rslt out sys_refcursor) is

begin

 open rslt for

select t.LOAN_FILE_NUMBER,

    t.SEPAM_UNIQUE_NUMBER,

    to_number(t.APPROVAL_AMOUNT) APPROVAL_AMOUNT

from USER1.TABLE1 t,

   USER2.TABLE2 p

where t.LOAN_FILE_NUMBER=loan

   and t.CONTRACT_TYPE_ID in (35464 ,35468)

   and t.CUSTOMER_ID=p.EXTERNAL_REF;

end PRC1;


ERROR AFTER EXECUTE USER3.PRC1:

DISTRIB TRAN P01.261225d5.11.7.1062937

ORA-02050: transaction 11.7.1062937 rolled back, some remote DBs may be in-doubt

 is local tran 11.7.1062937 (hex=0b.07.103819)

ORA-02056: 2PC: k2lcom: bad two-phase command number rdonly from coord

 insert pending collecting tran, scn=447714966418 (hex=0x000000683de43b92)

ORA-02063: preceding line from DBLINK1