ORA-02075: another instance changed state of transaction string



ORA-02075: another instance changed state of transaction string..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-30085: syntax error was found in overlaps predicate

1 Answers  


ORA-00485: DIAG process terminated with error string

1 Answers  


DRG-50914: invalid last document number string

1 Answers  


ORA-33450: (ESDREAD05) Discarding compiled code for workspace object because number now has more or fewer dimensions than it had when the code was compiled.

1 Answers  


QSM-01018: single table materialized join view rewrite not required

1 Answers  






TNS-12554: TNS:current operation is still in progress

1 Answers  


ORA-27011: skgfrd: cannot read from file opened for write

1 Answers  


ORA-23485: Column group "string" must consist of a single numeric column only

1 Answers  


ORA-32820: subscriber queue and exception queue must use same message system link

1 Answers  


IMP-00021: INCTYPE parameter is obsolete

1 Answers  


ORA-29551: could not convert string to Unicode

1 Answers  


PLS-01709: value list of INSERT statement, if specified with value list rather than subquery, must be value specification

1 Answers  


Categories