This section describes about the error messages that you need to troubleshoot.
Oracle
When the IIR Table Loader spawns SQL*Loader to load files, a performance option (Direct-Path) is used which bypasses the database nucleus and directly writes data blocks to the database files. When running a Direct-Path load across a network to an Oracle server having a different architecture (byte order, etc), an error message as follows will be returned:
ORA-02352: Direct path connection must be homogeneous
The solution is to either
run the load on the same machine, or
run a Conventional-Path load by specifying the Loader-Definition