Does Qlik Replicate On-Premise or Qlik Data Integration Cloud support Oracle 11.1.0.7 as a source endpoint?

[DINESHKUMAREAURA]

Hi Team,

Our client requires data replication from Oracle 11.1.0.7 to another database. However, based on Qlik documentation, it appears that Qlik Replicate supports Oracle versions starting from 11.2.0.4 as the source endpoint. Additionally, Qlik Data Integration Cloud supports Oracle versions starting from 12.x.

Could you please advise if there are any alternative methods or solutions available to achieve data replication from Oracle 11.1.0.7 using Qlik Replicate?

[Yadunandan]

Hello DINESHKUMAREAURA 

Unfortunately Oracle version 11.1.0.7 is not supported. It doesn't mean the task will not run, but you might encounter unexpected error which will cause issue. It is better to always use supported versions. 

Regards,
Yadunandan

[sureshkumar]

Hello @DINESHKUMAREAURA 

As yadunandan mentioned it's out of support.

When you Replicate using the Oracle 11.2.04, the task may fail with below error "

"The Oracle Redo compatibility version 0b200100 is not supported"

Work around is to add the internal parameter 

"fatalOnUnsupportedLRVersion" and uncheck it.

But its a temporary solution, in future you need to upgrade to supported version as mentioned in the user guide.

Regards,

Suresh

[john_wang]

Hello @DINESHKUMAREAURA ,

Welcome to Qlik Community forum and thanks for reaching out here!

Not very sure what's the Qlik Replicate version you are running now however in general Oracle 11.1.0.7 is not official supported in current Replicate major versions. It's not recommended to 'force' Replicate to capture changes from such versions as it's hard to guarantee the data is replicated completely and correctly.

We'd like to suggest:

1- Running Full Load ONLY task repeatedly in a specific interval; or

2- If you have higher version Oracle (which Qlik Replicated supported) then defined materialized view to link to Oracle 11.1.0.7. However please take care the compatibility between the 2 Oracle versions.

Hope this helps.

John.