Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 17081 invoked from network); 4 Nov 2008 09:24:24 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by air964.startdedicated.com with SMTP; 4 Nov 2008 09:24:20 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 22831AA1EE3; Tue, 4 Nov 2008 10:24:08 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14463-03; Tue, 4 Nov 2008 10:24:08 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 82C48AA1E80; Tue, 4 Nov 2008 10:24:07 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 04 Nov 2008 10:22:06 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CDFE8AA239F for ; Tue, 4 Nov 2008 10:22:05 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13996-05 for ; Tue, 4 Nov 2008 10:22:05 -0500 (EST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.183]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 30BF0AA240A for ; Tue, 4 Nov 2008 10:22:00 -0500 (EST) Received: by wa-out-1112.google.com with SMTP id v33so1721926wah.2 for ; Tue, 04 Nov 2008 07:21:56 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type:references; bh=DY5wHOB4W4XVKGcMRYxPW2HYYACk5l7kfVsTR1ZIS/8=; b=CtZClwWoAcHuhEF1uY7tUPsJSFIH1sbQkftm7NMOeVunvYOE/S1CuHAlrPUe0v9OsB zYhVELJ3duFRQDtqs5O9fiOB+tv7tjS7AlfK6HIGYY4Y5mqIweq3HXoea0a7tlPpxLDT RWiuFOgDEKSMmsIcgShaYOs/MB4ZbeYdmTRbM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:references; b=JWp8ddeNNvv3lc8veymJaVNBy+iLd0anSEQA77p9h/syYrG2+16vauvQKKW2a3jWQ9 WyEx2GbCAKtyYbynOFfNds7wWdvfHAaMGKOMaV61att1WhkY+Uihw6o3PYq9Nkelsg6S Ab/Iylx7AL2Fg6+/fkpyrciuhvYoOG5uDoemU= Received: by 10.115.75.14 with SMTP id c14mr1032386wal.45.1225812116252; Tue, 04 Nov 2008 07:21:56 -0800 (PST) Received: by 10.114.108.20 with HTTP; Tue, 4 Nov 2008 07:21:56 -0800 (PST) Message-ID: <69eafc3f0811040721g7a646a46h7d0f88abe8defdd0@mail.gmail.com> Date: Tue, 4 Nov 2008 10:21:56 -0500 From: "David Barbour" To: nigel.cl.thomas@googlemail.com Subject: Re: Somewhat Perplexed - Very Sheepish - Totally Ignorant:SQPLUS after 10.2.0.4 Upgrade Cc: ORACLE-L In-Reply-To: <53258cd50811040041y1eea9f63r35cd36a6e767babc@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_33525_1706834.1225812116213" References: <69eafc3f0811030759o35074da1p67b218ab8ca4afde@mail.gmail.com> <6AFC12B9BFCDEA45B7274C534738067F07D3B437@AAPQMAILBX02V.proque.st> <69eafc3f0811030822r1e22b20ake48adb07b3440cb2@mail.gmail.com> <6AFC12B9BFCDEA45B7274C534738067F07D3B4CF@AAPQMAILBX02V.proque.st> <69eafc3f0811030840h7f3b2501ya0e7395869540b1b@mail.gmail.com> <53258cd50811040041y1eea9f63r35cd36a6e767babc@mail.gmail.com> X-archive-position: 12204 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: david.barbour1@gmail.com Precedence: normal Reply-to: david.barbour1@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------=_Part_33525_1706834.1225812116213 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Bingo. orapr1@r3prdci1>which sqlplus /oracle/PR1/920_64/bin/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@r3prdci1>echo $PATH /oracle/PR1/102_64/bin:/usr/sap/PR1/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java14/jre/bin:/usr/java14/bin:/usr/tivoli/tsm/client/ba/bin:/usr/tivoli/tsm/client/oracle/bin64:/usr/local/scripts:/usr/local/scripts/operator:/opt/CA/UnicenterNSM/atech/services/bin 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@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@r3prdci1> *pwd* > > orapr1@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 > > ------=_Part_33525_1706834.1225812116213 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Bingo. 

orapr1@r3prdci1>which sqlplus
/oracle/PR1/920_64/bin/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@r3prdci1>echo $PATH
/oracle/PR1/102_64/bin:/usr/sap/PR1/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java14/jre/bin:/usr/java14/bin:/usr/tivoli/tsm/client/ba/bin:/usr/tivoli/tsm/client/oracle/bin64:/usr/local/scripts:/usr/local/scripts/operator:/opt/CA/UnicenterNSM/atech/services/bin



On Tue, Nov 4, 2008 at 3:41 AM, Nigel Thomas <nigel.cl.thomas@googlemail.com> 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@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@r3prdci1> pwd

orapr1@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
 

------=_Part_33525_1706834.1225812116213-- -- http://www.freelists.org/webpage/oracle-l