Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

SQLLDR Functionality Usage

Hi experts,
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.

 

Labels (3)
1 Reply
Anonymous
Not applicable
Author

Please let me know experts views. Really Urgent.