How to fix the Oracle error PGA-20967: 2-phase commit recovery attempted, DBA action required?

In this post, you’ll learn more about the Oracle ErrorPGA-20967: 2-phase commit recovery attempted, DBA action required with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PGA-20967: 2-phase commit recovery attempted, DBA action required

Reason for the Error PGA-20967: 2-phase commit recovery attempted, DBA action required

Cause: The recovery process of the Oracle integrating server has connected to the gateway to perform recovery. However, the gateway cannot perform automatic recovery for this transaction due to unknown heuristic action taken by the target OLTP.

How to fix the Error PGA-20967: 2-phase commit recovery attempted, DBA action required ?

You can fix this error in Oracle by following the below steps

Action: The DBA must attempt to manually resolve the in-doubt transaction. Detailed information on how to proceed is contained in Chapter 8 of the Oracle Database Gateway for APPC Installation and Configuration Guide, in the section titled “Manual Recovery of In-Doubt Transactions”.