permission denied on ASM disk group | Oracle DB Source

shnaqi — Wed, 05 Feb 2025 12:05:53 GMT

I am using Oracle Database 19c (ExaCC) as source where the redo logs are stored over ASM. I have provided all the required details of ASM and can see test connection is working fine but when I try to run the task on Qlik Replicate using this source, I am getting the below ASM DBMS_DISKGROUP Error:

Failed opening ASM file '+DATAC1/DBEXA/ONLINELOG/group_1.4969.1184945029', thread id '1'
OCI error 'ORA-15056: additional error message
ORA-17503: ksfdopn:2 Failed to open file +DATAC1/DBEXA/ONLINELOG/group_1.4969.1184945029
ORA-15260: permission denied on ASM disk group
ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 405
ORA-06512: at line 1'

From SQLPlus, I can see its working for the same account by running below:

sqlplus / as sysasm

SQL>
set serveroutput on;
declare
v_handle number;
v_pblksz number;
v_fsz number;
begin
dbms_diskgroup.open('+DATAC1/DBEXA/ONLINELOG/group_1.4969.1184945029','r',2,8192,v_handle,v_pblksz,v_fsz);
dbms_output.put_line('open file sucess file,file handle NO. '||v_handle);
dbms_output.put_line('open file sucess file,file file size is'||v_fsz);
dbms_diskgroup.close(v_handle);
end;
SQL> /
open file sucess file,file handle NO. 0
open file sucess file,file file size is409600

Can anyone please assist on this issue.

Re: permission denied on ASM disk group | Oracle DB Source

OritA — Thu, 06 Feb 2025 08:51:59 GMT

Hi,

Please make sure you provided the user used by Replicate all the required permissions as defined in the Replicate users guide (see link below). Did you define the Replicate user that is used to access the endpoint as sysdba or sysasm? Specifically, Please review the section 'required ASM priviliges' section in this link.

https://help.qlik.com/en-US/replicate/November2024/Content/Global_Common/Content/SharedReplicateHDD/Oracle/OracleDBSource_Security.htm

Regards,

Orit

topic permission denied on ASM disk group | Oracle DB Source in Qlik Replicate

permission denied on ASM disk group | Oracle DB Source

Re: permission denied on ASM disk group | Oracle DB Source