How to fix the Oracle error PGA-21215: partner log name mismatch on warm start?

In this post, you’ll learn more about the Oracle ErrorPGA-21215: partner log name mismatch on warm start with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PGA-21215: partner log name mismatch on warm start

Reason for the Error PGA-21215: partner log name mismatch on warm start

Cause: The Exchange Log Names (XLN) GDS variable received from the partner LU’s RRM contains an LU6.2 log name that is different from that known by the local LU’s RRM.

How to fix the Error PGA-21215: partner log name mismatch on warm start ?

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

Action: This can happen if the partner LU was cold started and later warm started, all between the times the local LU’s RRM was last shut down and warm started. The local LU’s RRM is not aware that the partner LU was cold started, and therefore assumes that the partner LU’s RRM is using the wrong LU6.2 log name. Verify that this is what happened, and if so, the local LU’s RRM can be forced to accept the new LU6.2 log name from the partner LU’s RRM by deleting the local RRM’s LU6.2 log entry for the partner LU, and then forcing the partner LU to reinitiate the connection to the local LU. For further information on recovery from this error, refer to “RRM Recovery” in Chapter 12, “2-Phase Commit”.