Oracle database error code ORA-02075 – another instance changed state of transaction string

Oracle Database Error Code ORA-2075 Description :
another instance changed state of transaction string
Error Cause:
A commit force or rollback force was issued from a session in another instance.

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


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , ,
No Comment Yet   
«
»