How to fix the Oracle error PGA-20935: synclevel number is not allowed when PGA_CAPABILITY=string?

In this post, you’ll learn more about the Oracle ErrorPGA-20935: synclevel number is not allowed when PGA_CAPABILITY=string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PGA-20935: synclevel number is not allowed when PGA_CAPABILITY=string

Reason for the Error PGA-20935: synclevel number is not allowed when PGA_CAPABILITY=string

Cause: The synclevel parameter passed to PGAINIT was incompatible with the setting of the PGA_CAPABILITY gateway initialization parameter, .

How to fix the Error PGA-20935: synclevel number is not allowed when PGA_CAPABILITY=string ?

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

Action: If the synclevel passed to PGAINIT is correct, then the gateway initialization parameter PGA_CAPABILITY must be changed to allow the desired synclevel to be supported. If the synclevel is not correct, the TIP should be changed to specify the correct sync- level in the call to PGAINIT. If the TIP was generated by PGAU, the SYNCLEVEL keyword of the DEFINE TRANSACTION statement should be changed to specify the correct synclevel and the TIP should be regenerated. The table below shows which synclevels are valid with each PGA_CAPABILITY setting. PGA_CAPABILITY Value SYNCLEVELs Allowed ———————- —————— READ_ONLY 0 SINGLE_SITE 0, 1 COMMIT_CONFIRM 0, 1