ORA-02056:2PC:k2lcom:bad two-phase command number rdonly from coordremote DBs may be in-doubt

We need to set the below parameter to fix the issue.

alter system set “_clusterwide_global_transactions”=false scope=spfile sid=’*’;

and restart the RAC cluster.

This should be done on on both source and target if both are on RAC.

  • October 2, 2017 | 46 views
  • Comments