topic will qlik replicate work with oracle OCI pluggable databases in Qlik Replicate

will qlik replicate work with oracle OCI pluggable databases

Zenith_Ian — Tue, 10 Jan 2023 11:05:45 GMT

Looking to upgrade from Attunity replicate to Qlik replicate.

encountered problem on Attunity replicate with database on oracle oci as pluggable database in that we get teh message

Error executing source loop
Endpoint is disconnected
Oracle CDC stopped
LogMiner cannot be used in Oracle pluggable : ORA-65040: operation not allowed from within a pluggable database
ORA-06512: at "SYS.DBMS_LOGMNR", line 82
ORA-06512: at line 1

would we get same issue if we upgraded to Qlik replicate?

although it's oracle error - can't tell if this is oracle (19) or replicate issue generating oracle error

please could someone advise.

thanks

Ian

Re: will qlik replicate work with oracle OCI pluggable databases

SwathiPulagam — Tue, 10 Jan 2023 11:15:43 GMT

Hi @Zenith_Ian ,

Connecting to a PDB using Oracle LogMiner is not supported. Therefore, if you want to connect to a PDB, make sure that the Access redo logs via Replicate Log Reader option is selected in the Advanced tab.
Due to unpredictable behavior, it is not recommended to use Oracle LogMiner when replicating from a RAC environment.

Below is the user guide link for your reference:

https://help.qlik.com/en-US/replicate/May2022/Content/Global_Common/Content/SharedReplicateHDD/Oracle/OracleDB_source_limitations.htm

Thanks,

Swathi

Thanks,

Swathi

Re: will qlik replicate work with oracle OCI pluggable databases

Heinvandenheuvel — Tue, 10 Jan 2023 15:20:05 GMT

With multitenant DB's there is one set of Redo/Arch per CDB shared by all tenants (PDB's). Each PDB has their own objects and unique object ID's for that PDB, but not unique within the CDB. Therefor Replicate has to add connection id to each object_id to make sure it applies to the PDB being handled. (homework: select name, con_id from v$containers) . This is not implemented for Log_miner

Please realize that with a single redo/arch set, each PDB task will have to read all of redo/arch skipping stuff from other PDB's. A replication task for small 'dev' or 'test' PDB living alongside a heavy production PDB may be relatively slow reading and selecting its changes due to activity in other PDBs.

https://expertoracle.com/2021/07/19/oracle-multitenant-db-5-noteworthy-points-on-oracle-cdb-pdb-architecture/ - point # 5

fwiw,

Hein.

Re: will qlik replicate work with oracle OCI pluggable databases

Zenith_Ian — Tue, 10 Jan 2023 16:24:43 GMT

Thanks both - have applied that change to use replicate log reader and gotten further - still need some work elsewhere but that is on us - your assistance has been incredibly useful.

Ian