I want to understand why the oozie documentation says that the SSH Action is deprecated. While in the latest releases they have the SSH Action.
I also have searched in Apache JIRA for this. Reference. Which says that SSH actions are supported and will be supported in the future.
Secondly, one question that bugs me is why is it not recommended to use the SSH action?
You are referencing a real old jira which was resolved, and the action is still supported.
In the oozie documentation we keep I am not able to find the deprecation message.
SSH actions has limitations in its usage, that is why we do not recommend it.
my problem is that, run "ls" or"pwd" or "mkdir dirtest" or "java -version" with ssh action is successful. but, when i run "sqlplus","sqlplus user/pass","sqlplus user/pass@localhost/pdb1 @test.sql " is failed and there is not any useful log in "log" tab or "oozie-oozie" directory. and you know i want execute some oracle sql statement bu oozie ssh action. help!.
You have to do all the work yourself: you get a clean environment with just the basics. Anything you need to setup you have to do yourself. There is nothing that is configured and you cannot assume anything.
You would need to make sure that sqlplus and all dependencies are on the path and available.
thank you very much.!
"get a clean environment with just the basics. Anything you need to setup you have to do yourself....." it sounds difficult to build oracle environment ..
i have input "export ORACLE_SID=some_path export ORACLE_HOME=some_path etc.." in the oozie ssh action and then "sqlplus" cammand executed successfully, i think it only means that "sqlplus" command can be found in the environment,however,commands such as "sqlplus user/pass" and "sqlplus user/pass@firstname.lastname@example.org" is failed,you know oracle's security strategy isn't simple.
do you have any suggestion? thanks!
The easiest way is to check what is set when you login and things work for you. Oracle requirements change per version and the best way forward is copy from a working install and make sure that everything that is set there is set in the action that is executed.