Oracle DBA, How To, Error, Cause and Action

ORA-02075: another instance changed state of transaction string

ORA-02075: another instance changed state of transaction string


Cause:


A commit force or rollback force was issued from a session in another instance.



Action:


Check if another Oracle instance is performing recovery of pending transactions. Query DBA_2PC_PENDING to determine the new state of the transaction.

No comments:

Post a Comment

Thanks for your comment.