Re: sqlplus "command not found" connecting with ssh

From: _mamarin_ <ma.marin.m_at_gmail.com>
Date: 11 Dec 2006 05:40:20 -0800
Message-ID: <1165844420.505214.279180@16g2000cwy.googlegroups.com>

Thanks to you all...

"sourcing" the bash_profile into my script was the besto option at least!!

#!/bin/bash
. ~/.bash_profile

:D

Matthias Hoys ha escrito:

> "_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 - 07:40:20 CST