topic Re: Qlik Replicate to Oracle connectivity in Qlik Replicate

Qlik Replicate to Oracle connectivity

AnujGupta — Mon, 17 Jul 2023 07:03:49 GMT

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

Re: Qlik Replicate to Oracle connectivity

Arun_Arasu — Mon, 17 Jul 2023 07:13:15 GMT

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

Re: Qlik Replicate to Oracle connectivity

AnujGupta — Mon, 17 Jul 2023 07:30:53 GMT

Qlik replicate -

November 2022 (2022.11.0.289)

It a new task.

Re: Qlik Replicate to Oracle connectivity

john_wang — Mon, 17 Jul 2023 08:06:31 GMT

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.

Re: Qlik Replicate to Oracle connectivity

AnujGupta — Tue, 18 Jul 2023 07:46:02 GMT

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.

Re: Qlik Replicate to Oracle connectivity

SushilKumar — Tue, 18 Jul 2023 09:54:51 GMT

Hello Anuj.

It mentioned in the

Qlik Replicate May 2022

Adding and managing source endpoints

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)

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).

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