Qlik Replicate to Oracle connectivity

[AnujGupta]

Hello Team, 

I have source as orcale below error only appearing when will do apply changes ON & getting below error 

00002076: 2023-07-17T08:31:23 [SOURCE_CAPTURE ]E: The Oracle Redo compatibility version 0b200000 is not supported [1022316] (oradcdc_redo.c:837)

00002076: 2023-07-17T08:31:23 [SOURCE_CAPTURE ]E: Error executing source loop [1022316] (streamcomponent.c:1940)

00002076: 2023-07-17T08:31:23 [TASK_MANAGER ]E: Stream component failed at subtask 0, component st_0_WMS2-Prod [1022316] (subtask.c:1396)

00002076: 2023-07-17T08:31:23 [SOURCE_CAPTURE ]E: Stream component 'st_0_WMS2-Prod' terminated [1022316] (subtask.c:1565)

I have checked we have  below version in Oracle servers. 

Oracle source database version is 11.2.0.4.0

Oracle compatibility version is 11.2.0

Oracle Client version: 19.3.0.0.0

[Arun_Arasu]

Hello @AnujGupta ,

Thank you for reaching out to the Qlik community!

We kindly request your assistance in providing us with the version of Qlik Replicate that you are currently using. Additionally, it would be greatly appreciated if you could provide us with some background information about the tasks at hand. Are these tasks newly created?

Furthermore, we suggest enabling CDC (Change Data Capture) and attempting to resume the task with a timestamp using the advanced run option.

Thank you for your cooperation.

Best regards,

Arun

[AnujGupta]

Qlik replicate - 

• November 2022 (2022.11.0.289)

It a new task.

[john_wang · Accepted solution]

Hello @AnujGupta , copy @Arun_Arasu ,

Qlik Replicate supports Oracle 11.x starting from 11.2.0.4 as source endpoint DB. However in this Oracle version, the Oracle compatibility version cannot set to an earlier version number than 11.2.0.4. It's a note in Replicate User Guide.

From you error message:

00002076: 2023-07-17T08:31:23 [SOURCE_CAPTURE ]E: The Oracle Redo compatibility version 0b200000 is not supported [1022316] (oradcdc_redo.c:837)

where 0b200000 means 11.2.0. (a=10,b=11...). This is the exact limitation. Replicate does not support this version and settings.

One option is to set the compatibility version to 11.2.0.4. However please work with your DBA and your organization's relevant team for the final decision (a bit risky I think).

Hope this helps.

Regards,

John.

[AnujGupta]

 Oracle compatibility version is 11.2.0 version working with Qlik Version May 2022 (2022.5.0.395) but not with Nov  2022 release any exact docs we have.

[SushilKumar · Accepted solution]

Hello Anuj.

It mentioned in the 

• Qlik Replicate May 2022

• Adding and managing source endpoints

1. Using Oracle as a source   in the PREREQUSITE section nothing related to compatible parameter is mention

However, in the November 2022 help document it mentioned clearly to use oracle as Source endpoints you must Have.  the compatible parameter value must match the real version of the database.

in nutshell if you have a 11.2.0.4 you must have set it 11.2.0.4. you QR will not work if you Have the compatible parameter 11.2.0.0 or minor number is 11.2.0.( 0,1,2,3)

1. Qlik Replicate November 2022

 

1. Adding and managing source endpoints

 

1. Using Oracle as a source

SELECT name, value, description FROM V$parameter WHERE name = 'compatible';

The returned result should be from GE to n.n.n where n.n.n is the Oracle database version (e.g. 10.0.0).

Information note

For Replicate to work, the parameter value must match the real version of the database.

Hope provided InfoMation help. if it helps you request you to mark it as Accept as Solution.

Regards,

Sushil Kumar