Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Congratulations to the new Qlik Luminary and Partner Ambassador class! Meet them here
cancel
Showing results for 
Search instead for 
Did you mean: 
Tamerboy
Contributor
Contributor

Oracle as Source for Qlik Replicate

I have 2 questions:

1) Does ASM Log Reader alter redo log files or only reads them? 
2) Confirmation of whether Qlik Replicate alters state of ASM and its files or not

3) Why it is needed to grant SYSASM privileges? Is it possible to work with ASMOPER privilege?
4) List of commands/calls that are executed by Replicate while working with ASM (including which of the procedures from DBMS_DISKGROUP package are used and in what modes)?

Labels (1)
1 Reply
-mjl-
Contributor III
Contributor III

Hi,

1. and 2. No. Redo logs are read and parsed on the Replicate server.

3. and 4. There is no other role available in Oracle that grants all of the permissions Replicate needs, so you have to give it super privilege. You can get a list of operations that Replicate performs from Qlik Support.

 

Cheers!