Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus "command not found" connecting with ssh

Re: sqlplus "command not found" connecting with ssh

From: Matthias Hoys <anti_at_spam.com>
Date: Mon, 11 Dec 2006 13:53:20 +0100
Message-ID: <457d54c1$0$31474$ba620e4c@news.skynet.be>

"_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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US