Oracle Solution for Error ora-02075
ORA-02075: another instance changed state of transaction string
What triggered the Error:
A commit force or rollback force was issued from a session in another instance.What should we do to fix it:
Check if another Oracle instance is performing recovery of pending transactions. Query DBA_2PC_PENDING to determine the new state of the transaction.
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
