In this post, you’ll learn more about the Oracle ErrorPGA-21209: error selecting PGA_2PC_PENDING rows for partner LU string with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PGA-21209: error selecting PGA_2PC_PENDING rows for partner LU string
Reason for the Error PGA-21209: error selecting PGA_2PC_PENDING rows for partner LU string
Cause: The RRM was unable to read the pending transaction entries from its LU6.2 log for the partner LU
How to fix the Error PGA-21209: error selecting PGA_2PC_PENDING rows for partner LU string ?
You can fix this error in Oracle by following the below steps
Action: Ensure that the Oracle server and its TNS listener are both operational. Also ensure that the PGA_2PC_PENDING table exists and has not been altered or updated manually. If the table has been tampered with, it may need to be reinitialized and the RRM cold started.