question oozie ssh-action execute command failed in Support Questions

oozie ssh-action execute command failed

eniac27427 — Fri, 16 Sep 2022 12:39:28 GMT

my ssh-action 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. thank you very much.

Re: oozie ssh-action execute command failed

Wilfred — Wed, 20 Dec 2017 12:48:38 GMT

This looks like it is a duplicate of what I already answered in: this thread

Re: oozie ssh-action execute command failed

eniac27427 — Fri, 29 Dec 2017 10:04:48 GMT

hello.everyone. the first step in ssh-action is "source /home/oracle/bash_profile",and then you can run oracle command. thanks