Query the Oracle database for the online and archived redo log locations in the Oracle server file system. You can use the following example queries:

select * from v$logfile;

select dest_id, dest_name, destination, status from V$ARCHIVE_DEST;

Create the ONLINELOG_DIR and ARCHIVELOG_DIR directory objects that point to the locations of log files from step 1. An Oracle directory object specifies a logical alias name for a physical directory on the Oracle server file system under which the log files to be accessed are located. For example:

CREATE DIRECTORY ONLINELOG_DIR AS '/u01/oracle/data';
CREATE DIRECTORY ARCHIVELOG_DIR AS '/u01/oracle/archivedata';

To verify that the directory objects were created with the correct file system paths for the redo logs, issue a select statement such as:

select * from all_directories;
OWNER    DIRECTORY_NAME      DIRECTORY_PATH
-------- ------------------- ----------------------------------
SYS      ARCHIVELOG_DIR      /u01/oracle/data/JO112DTL
SYS      ONLINELOG_DIR       /u01/oracle/data/JO112DTL

Grant read and write access on the ONLINELOG_DIR and ARCHIVELOG_DIR directory objects to the Mass Ingestion Databases user who is specified in the Oracle Database Ingestion connection properties. For example:

grant read, write on directory "ARCHIVELOG_DIR" to "
cmid_user";
grant read, write on directory "ONLINELOG_DIR" to "
cmid_user";

In the Oracle Database Ingestion connection properties, select the

BFILE Access

check box.