Qlik Replicate and Amazon RDS for Oracle source endpoint: Cannot create Oracle directory name

[shashi_holla]

Working with an Amazon RDS for Oracle endpoint as a source, we might encounter an issue where CDC doesn't start and fails with the following error:

Cannot create Oracle directory name 'ATTUREP_XXXXXX_XXX' with path '/XXXXX/log/arch'

Resolution

This is because of undocumented access request required which is not available in the User Guide yet. We have to execute the following grant statements to provide read only access to Qlik user to the online and archive redo logs:

grant read on directory ONLINELOG_DIR to qlik; 

grant read on directory ARCHIVELOG_DIR to qlik;

or

exec rdsadmin.rdsadmin_util.grant_sys_object('ONLINELOG_DIR','QLIK','READ');
exec rdsadmin.rdsadmin_util.grant_sys_object('ARCHIVELOG_DIR','QLIK','READ');

Where qlik/QLIK is the user specified in the source endpoint connection.

Related Content:

Access privileges when using Replicate Log Reader to access the redo logs | Qlik Replicate Help 

Environment

Qlik Replicate 

[MoeE]

Hi Shashi,

Can this also occur on Oracle if it isn't on RDS? I am seeing this error for an on-prem Oracle source.

Thanks,

Mohammed

[Sonja_Bauernfeind]

Hello @MoeE 

This can occur with Oracle not on RDS as well.

All the best,
Sonja