Created 05-11-2016 08:45 PM
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?
Created 05-18-2016 09:05 PM
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.
Wilfred
Created 05-18-2016 10:48 PM
Created 05-18-2016 10:59 PM
There is an open jira in Apache Oozie for that documentation issue: OOZIE-1283 So you can ignore that one and use the action extension as documented in the link given.
Wilfred
Created 12-19-2017 06:17 PM
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!.
Created 12-19-2017 10:49 PM
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.
Wilfred
Created 12-20-2017 04:36 AM
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@host/oracle_sid@some.sql" is failed,you know oracle's security strategy isn't simple.
do you have any suggestion? thanks!
Created 12-20-2017 04:45 AM
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.
Wilfred