Re: Somewhat Perplexed - Very Sheepish - Totally Ignorant:SQPLUS after Upgrade

From: David Barbour <>
Date: Tue, 4 Nov 2008 10:21:56 -0500
Message-ID: <>


orapr1_at_r3prdci1>which sqlplus

Now the problem is why the heck is that still in the path. I suspect it has to do with our AIX Systems Administrators and their invocation of HACMP (which was dismantled but all the scripts left in place).

orapr1_at_r3prdci1>echo $PATH

On Tue, Nov 4, 2008 at 3:41 AM, Nigel Thomas <
> wrote:

> David
> None of your tests so far show you which directory you are actually in. It
> is possible that some kind soul has put a sqlplus shell script earlier in
> the PATH than the Oracle sqlplus executable which does something like:
> cd some-directory
> $ORACLE_HOME/rdbms/bin/sqlplus
> So: to check this, you try the following:
> orapr1_at_r3prdci1> *which sqlplus*
> On most unixes *which* should tell you if you have a script in the way
> (and where it is hiding).
> Otherwise, try
> orapr1_at_r3prdci1> *pwd*
> orapr1_at_r3prdci1> *sqlplus user/pass*
> SQL>* !pwd*
> Are you in the same directory as before?
> Another way you could end up in a different directory is if your shell (eg
> ksh) runs a login, .profile, or other startup file (like .bashrc) which
> includes a *cd* command. Check *man ksh* for the files that are executed
> when you launch a new shell.
> Regards Nigel

Received on Tue Nov 04 2008 - 09:21:56 CST

Original text of this message