In-Doubt Transactions
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.A server machine running Oracle Database software crashesA network connection between two or more Oracle Databases involved in distributed processing is disconnectedAn unhandled software error occurs