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

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

gayatri235 — Tue, 23 Jan 2024 10:34:37 GMT

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 ?

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

john_wang — Tue, 23 Jan 2024 11:08:39 GMT

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.

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

gayatri235 — Tue, 23 Jan 2024 14:25:52 GMT

It does help, Thanks @john_wang !!