ORA-02047: cannot join the distributed transaction in progress

ORA-02047: cannot join the distributed transaction in progress


Cause:


Either a transaction is in progress against a remote database that does not fully support two phase commit, and an update is attempted on another database, or updates are pending and and an attempt is made to update a different database that does not fully support two phase commit.



Action:


complete the current transaction and then resubmit the update request.