Re: sqlplus "command not found" connecting with ssh

"_mamarin_" <ma.marin.m_at_gmail.com> wrote in message news:1165840799.769946.39610_at_16g2000cwy.googlegroups.com...
> Hi you all,
>
> I'm trying to execute an script which uses sqlplus from a remote ssh
> client.
> The script runs ok executing it from the server.
>
> I'm executing the following line: ssh user_at_host script.sh
> The script only connects sqlplus (sqlplus user_at_pass/DB_SID)
> And I get the followin message:
> bash: sqlplus: command not found
>
>
> Any ideas?
>
> Thanks a lot
>

Define the environment variables (ORACLE_HOME, ...) in the shell script, or use the full path to the sqlplus executable, or (the best solution maybe), "source" the .bash_profile file inside your script :

#!/bin/bash
. ~/.bash_profile
sqlplus ...

Matthias Received on Mon Dec 11 2006 - 06:53:20 CST