tOracleBulkExec_1 Cannot run program "sqlldr": error=2, No such file or directory

[Anonymous]

Hi All,

I'm using Talend Data Fabric 6.4.1. I have millions of data to be loaded to Oracle database on a daily basis and to increase the performance, I tried using the tOracleBulkExec but i'm getting error while executing the job.We have our Linux execution servers and i'm pointing my job to Linux server for job execution. I have installed the oracle client and the environments variables are set. 

$ export ORACLE_HOME=/app/oracle/product/11.2.0/client
$ export LD_LIBRARY_PATH=/app/oracle/product/11.2.0/client/lib
$ export DISPLAY=localhost:10.0
$ echo $ORACLE_HOME
/app/oracle/product/11.2.0/client
$ echo $PATH
/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/spriya5/bin

 Even after doing this I'm getting the same error. 

Please help me in fixing this issue. Let me know what am i missing.

Regards,

Sathiyapriya

[Anonymous]

Hi,

     Could you please refer the below post which is in resolved status?

https://community.talend.com/t5/Design-and-Development/resolved-Help-on-tOracleBulkExec-cannot-run-p...

     Seems your path details is having issue? Could you please cross verify?

Warm Regards,

Nikhil Thampi

[TRF]

sqlldr must be installed on the same box where the job runs