Qlik Replicate log reader create directories manually in oracle rac

[lguevara]

Hi,

I have a source oracle 19c in rac architecture as source with qlik replicate 202411. I configure using 

- replicate log reader

- Use archived redo logs only

but  we dont have CREATE ANY DIRECTORY privilege, and  we want to create corresponding directories manually.

What are the steps to create the corresponding directories, considering that it is a RAC  oracle architecture?

thanks.

[john_wang]

Hello @lguevara ,

Thanks for posting this.

When using the Replicate Log Reader to access an Oracle source, the necessary Oracle directories must be defined so that Qlik Replicate can access them. For more details, see “What’s the usage of Oracle directories in a Replicate Oracle source.”

In your case, the setup is straightforward: all directories containing archived redo log files (from which Replicate reads) need to be defined. You can list the archived redo logs and their locations with the following query:

SELECT * FROM v$archived_log WHERE name IS NOT NULL;

A few important notes:

1. Manually created directories must not use the prefixes ATTUREP_, ATTUTMP_, or ATTUGRP_.

2. If the Oracle user defined in the Replicate source endpoint is not the one who created the directories, make sure to grant it READ privilege on those directories.

3. If the Oracle database is running in STANDBY mode, please refer to my comment in “Why do we get an ORA-16000 error when the DBA says privileges are correct?”

Alternatively, you can grant the user CREATE DIRECTORY privilege first, then set SOURCE_UNLOAD/SOURCE_CAPTURE to Verbose in Replicate. Run the task and review the task log — you’ll find all the CREATE DIRECTORY SQL statements there.

Hope this helps.

John.