Xref: alice comp.databases.oracle.server:83167
Path: alice!news-feed.fnsi.net!newsfeed.eurocyber.net!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!cpk-news-hub1.bbnplanet.com!news.gtei.net!news1.bellglobal.com!news20.bellglobal.com.POSTED!not-for-mail
Sender: stark@HSE-Montreal-ppp33976.qc.sympatico.ca
Newsgroups: comp.databases.oracle.server
Subject: Re: SQLPlus only works on 'oracle' user
References: <86uv00$sr1$1@bob.news.rcn.net> <389b040a.170678713@news.erols.com>
From: Greg Stark <greg-spare-1@mit.edu>
Organization: The Emacs Conspiracy; member since 1992
Message-ID: <87d7qfat2u.fsf@HSE-Montreal-ppp33976.qc.sympatico.ca>
Lines: 21
User-Agent: Gnus/5.070095 (Pterodactyl Gnus v0.95) Emacs/20.5
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Date: Thu, 03 Feb 2000 03:00:33 GMT
X-Trace: news20.bellglobal.com 949546833 216.209.192.133 (Wed, 02 Feb 2000 22:00:33 EST)
NNTP-Posting-Date: Wed, 02 Feb 2000 22:00:33 EST


daveewall@home.com (Dave Ewall) writes:

> Just as a follow up to myself, I finally figured out what was going
> wrong.
> 
> It's such a silly thing, that I'm wondering how it can effect Oracle
> like this.
> 
> Anyway, I had the ORACLE_HOME variable set to "/u01/OraHome1/",
> and it should have been set to "/u01/OraHome1" (without the last
> slash).  Apparently, it couldn't find the database with the extra
> slash in it.  What confuses me is that usually multiple slashes are
> okay in pathnames.  <shrug>

ORACLE_HOME is more than just a path name. It's used as a key to look up the
database somewhere. This particular brokenness doesn't affect TNS only local
connections I believe.

-- 
greg