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

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

Anonymous — Sat, 16 Nov 2024 07:24:58 GMT

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

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

Anonymous — Tue, 23 Oct 2018 17:22:30 GMT

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-program-quot-sqlldr/td-p/102338

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

Warm Regards,

Nikhil Thampi

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

TRF — Tue, 23 Oct 2018 20:31:34 GMT

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