will qlik replicate work with oracle OCI pluggable databases

[Zenith_Ian]

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

[SwathiPulagam · Accepted solution]

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/Oracl...

Thanks,

Swathi

Thanks,

Swathi

[Heinvandenheuvel]

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-arch...  - point # 5

fwiw,

Hein.

[Zenith_Ian]

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