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.
