How to fix the Oracle error PGA-20961: synclevel 1 conversations not allowed when PGA_CAPABILITY=2_PHASE?

In this post, you’ll learn more about the Oracle ErrorPGA-20961: synclevel 1 conversations not allowed when PGA_CAPABILITY=2_PHASE with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PGA-20961: synclevel 1 conversations not allowed when PGA_CAPABILITY=2_PHASE

Reason for the Error PGA-20961: synclevel 1 conversations not allowed when PGA_CAPABILITY=2_PHASE

Cause: A conversation was requested at synclevel 1. The gateway init file specified PGA_CAPABILITY=2_PHASE. When 2-phase commit is enabled, synclevel 1 conversations are not supported, since they are not protected by 2-phase processing.

How to fix the Error PGA-20961: synclevel 1 conversations not allowed when PGA_CAPABILITY=2_PHASE ?

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

Action: Either use synclevel 2 for the conversation (if the remote transaction program supports it) or use a different gateway SID for this conversation.