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

From: Nigel Thomas <>
Date: Tue, 4 Nov 2008 08:41:26 +0000
Message-ID: <>


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

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.

HTH Regards Nigel

Received on Tue Nov 04 2008 - 02:41:26 CST

Original text of this message