Re: SQLPlus only works on 'oracle' user

From: Greg Stark <greg-spare-1_at_mit.edu>
Date: Thu, 03 Feb 2000 03:00:33 GMT
Message-ID: <87d7qfat2u.fsf@HSE-Montreal-ppp33976.qc.sympatico.ca>

daveewall_at_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 Received on Wed Feb 02 2000 - 21:00:33 CST