how does qlik replicate work with ASM in oracle ? Does it delete any disk group or create ?

[gayatri235]

Hello Team, 

We are working oracle as source and creating CDC task .

Oracle has ASM enabled for log management, can anyone help me with the working of replicate with ASM  ?

 Does Qlik replicate delete or create any groups at source for logs or it only reads  ?

[john_wang]

Hello @gayatri235 ,

Thanks for reaching out to Qlik Community!

---

 Does Qlik replicate delete or create any groups at source for logs or it only reads  ?

---

 Qlik Replicate calls dbms_diskgroupAPI(s) to access ASM redo logs. dbms_diskgroupis an Oracle 'internal package' (C implementation, as opposed to PL/SQL), it provides and API to access ASM data, Replicate does not create/delete any groups or objects during the ASM access.

Regarding the ASM Connection String , it's as same as you use it in SQLPlus. You can validate ASM access by SQLPLus for example:

sqlplus sys/oracle@192.168.33.179:1521/+ASM as sysasm

Hope this helps.

John.

[gayatri235]

It does help, Thanks @john_wang !!