topic Re: Oracle Version 19c ORACDC514E error in Qlik Replicate

Oracle Version 19c ORACDC514E error

rlwood63108 — Tue, 06 Apr 2021 16:37:56 GMT

I am not sure I am in the right place... Hopefully someone can correct me if i choose poorly...

We are running what we call Attunity, version 5, to do Change Data Capture from Oracle 12.1.0.1 data bases, to SQL Server data bases. In migrating our Oracle data bases to 19c (since 12c support has been dropped), we can no longer get the Attunity CDC process to run. We are getting errors like this:

"SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence ####

I have Log Miner running for Oracle. I have tried setting up a User Account on the PDB, and a Common User on the CDB. Neither works (different issues/errors for each user account).

Does anyone have experience with this issue? What do I need to do to get this to run - it was working great before the new Oracle version came along, and of course, Oracle claims it is not their issue. 😞

Re: Oracle Version 19c ORACDC514E error

lyka — Tue, 06 Apr 2021 16:40:32 GMT

Good Day!

Are you using Oracle 19.x as a surce endpoin in Replicate version 5?

Please note that Oracle 19.x is supported as a source endpoint starting Replicate 6.6

Thanks,

Lyka

Re: Oracle Version 19c ORACDC514E error

rlwood63108 — Tue, 06 Apr 2021 16:51:56 GMT

Thank you for the quick reply!

Yes, we are copying data FROM Oracle 19c Instances - in a PDB...

One other question from my SQL Server team member:

Will Replicate 6.6 work with SQL 2019 also?

Re: Oracle Version 19c ORACDC514E error

lyka — Tue, 06 Apr 2021 20:15:12 GMT

Hello,

Yes, SQL Server 2019 is also supported as a source endpoint in Replicate 6.6.

As for Oracle 19 source, please upgrade Replicate to 6.6 version as its not supported as source in Replicate 5

Thanks

Lyka

Re: Oracle Version 19c ORACDC514E error

rlwood63108 — Tue, 06 Apr 2021 20:23:11 GMT

Excellent... again, thank you for the quick replies. This helped us out.