question Re: oozie ssh action failed in Archives of Support Questions (Read Only)

oozie ssh action failed

eniac27427 — Tue, 21 Apr 2026 13:45:05 GMT

my oozie 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 failed

eniac27427 — Wed, 20 Dec 2017 06:34:44 GMT

hello . i find in the log "oozie-oozi/0000085-171216193057252-oozie-oozi-W/ssh-10af--ssh/ssh-wrapper.sh: line 49: sqlplus: command not found" ---sqlplus: command not found

but sqlplus command is executed successfully on the local machine by user oracle . ...........what can i do ?

Re: oozie ssh action failed

eniac27427 — Sun, 31 Dec 2017 02:06:26 GMT

hello.

the cause of this probelm is ENV variable. so,executing 'source /home/oracle/bash_profile' before any shell.