I want to use tOracleBulkexe component to load data from file into Oracle DB from file placed into Job server. So I have installed Oracle Client on Job server.
When I ran this job from Studio installed on Job server, it works fine but when I ran the same job from studio installed in another virtual machine, it does not work though I have selected target execution as Job server IP. The error is "Cannot run program "sqlldr": java.io.IOException: error=2, No such file or directory" . I have setup Oracle_Home and Path environment variable in Job server machine.
When I run from studio installed on Virtual machine, it is creating *.ctl file. That means studio from VM able to access file available on Job server.
My question is do we need to install Oracle client on each VM, which I do not think is the right option. Please provide your views to resolve this issue.