Distributed transactions become in-doubt - Server machine running Oracle Database software crashes

Q.  Which of the following way can the Distributed transactions become in-doubt?

- Published on 12 Aug 15

a. A server machine running Oracle Database software crashes
b. A network connection between two or more Oracle Databases involved in distributed processing is connected
c. An unhandled software error does not occurs
d. None of the above

ANSWER: A server machine running Oracle Database software crashes
 

    Discussion

  • Nirja Shah   -Posted on 22 Sep 15
    - The two-phase commit mechanism ensures that all nodes either commit or perform a rollback together.

    - What happens if any of the three phases fails because of a system or network error? The transaction becomes in-doubt.

    - Distributed transactions can become in-doubt in the following ways:
    1. A server machine running Oracle Database software crashes
    2. A network connection between two or more Oracle Databases involved in distributed processing is disconnected
    3. An unhandled software error occurs

    - The RECO process automatically resolves in-doubt transactions when the machine, network, or software problem is resolved.

    - Until RECO can resolve the transaction, the data is locked for both reads and writes.

    - The database blocks reads because it cannot determine which version of the data to display for a query.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)