I need a quick help on Oozie.
SSH actions do not support providing a password, you have to setup ssh keys for passwordless ssh to be able to use the SSH action. As for the shell action, the way it works is it runs as an MR job, so it can randomly run on any NodeManager or TaskTracker node. So you have 2 options for these:
Thanks for your response.
I have tried your option 2. Because the the ETL has been installed all the nodes.
1- move the main script to HDFSwhere all the ETL funactions are present.
2- move the ETL scripts to HDFS
3- Even i have given the 2 file path like this;
<file>/path/to/abc.sh#abc.sh</file> <- main shell script
<file>/path/to/abc.sh#abc.sh</file> < -ETL job
Main Shell Script:
exm /run Source3_2727.8917.dtl [this is the way to run the ETL job]
./check.sh: line 6: exm: command not found Failing Oozie Launcher, Main class [org.apache.oozie.action.hadoop.ShellMain], exit code 
I was able to run the shellscript from local via oozie with shell action node. I have 2 queries which I am trying to find out.
1- I have NODE1 (namenode) and NODE2, I have cretaed a shell script and put into HDFS and from that script I mentioned: sh /home/bia/dxm/action.sh <-- this is in local. But I am able to run this script NO SSH required here. But when I am trying to access the NODE2 local directory it's saying PATH not found. Can somebody advice me why isit so. Because later stage we need to move this project to 20 node clusters, so I should be confident how it works.
2- When the oozie running the local shellscript, it writing all the logs from mapred user, but we need to do via our own user like dxmbig. Even I have tried the below line in the in the master shellscript which is present in HDFS but it did not change it.
sudo -u dxmbig sh /home/bia/dxm/action.sh > /home/bia/log/bd1.log 2>&1
Please help me and suggest me further.