Oracle DBA, How To, Error, Cause and Action

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.