Error: Database Is Not Compatible With Required Version 11.2

Issue

While configuring a connection to use the Binary Log Reader sync method with Oracle Database Version 11.2, setup tests fail with the following error:

Database is not compatible with the required version 11.2

Environment

• Connector: Oracle
• Incremental sync method: Binary Log Reader

Resolution

To resolve this issue:

1. Run the following command to check the COMPATIBLE parameter:

   SELECT value FROM SYS.V_$PARAMETER WHERE name = 'compatible'
   

2. Set the COMPATIBLE parameter to 11.2.0.0.0 or later. Changing this parameter requires a database restart.

Cause

This issue occurs when the database COMPATIBLE parameter is set to a value earlier than 11.2.0.0.0, which is the minimum version required by the Fivetran Binary Log Reader sync method.