DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, October 2, 2017

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.

No comments: