Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Zenith_Ian
Contributor II
Contributor II

will qlik replicate work with oracle OCI pluggable databases

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

 

Labels (1)
1 Solution

Accepted Solutions
SwathiPulagam
Support
Support

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

View solution in original post

3 Replies
SwathiPulagam
Support
Support

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
Specialist III
Specialist III

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
Contributor II
Contributor II
Author

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