Xref: alice comp.databases.oracle.server:83016
Path: alice!news-feed.fnsi.net!netnews.com!feed1.news.rcn.net!rcn!not-for-mail
From: daveewall@home.com (Dave Ewall)
Newsgroups: comp.databases.oracle.server
Subject: Re: SQLPlus only works on 'oracle' user
Date: Wed, 02 Feb 2000 10:18:23 GMT
Lines: 61
Message-ID: <389b040a.170678713@news.erols.com>
References: <86uv00$sr1$1@bob.news.rcn.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: BGDwMIHgpgDUx6eaBSOzoJNOg4FgXGFXXL/NUMXZTyA=
X-Complaints-To: abuse@rcn.com
NNTP-Posting-Date: 2 Feb 2000 10:20:33 GMT
X-Newsreader:  Forte Agent 1.5/32.452

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>

Dave

On Sat, 29 Jan 2000 09:54:44 -0500, Dave Ewall <daveewall@home.com>
wrote:

>Question for anybody who can answer it:
>
>I installed 8.1.5.0.0 on Redhat 6.1, and since you have to do the
>8.1.5.0.1 upgrade to make the database, I did.  Everything's working
>fine while I'm the oracle user.  I have a dba group, which I installed
>Oracle from, but that's the only group for Oracle that I have.  I
>installed the database fine, created tablespaces, ran an imp (which
>worked), created users, and all those users log in fine while I'm the
>oracle user on the box.
>
>I looked through the docs on technet.oracle.com, and found that there
>was a related bug fixed in the service pack 8.1.5.0.1, so I even tried
>upgrading to 8.1.5.0.2, which is what it is now.
>
>After logging into sqlplus with any other user, it says:
>
>ERROR:
>ORA-01034: ORACLE not available
>
>The database is up and running, obviously, since it works with the
>oracle user.  When I tried to log in as the database user I wanted to
>log in as (when I'm oracle on the system), it said this:
>
>Error accessing PRODUCT_USER_PROFILE
>Warning:  Product user profile information not loaded!
>You may need to run PUPBLD.SQL as SYSTEM
>
>I tried running doing just that, and now it doesn't say that message
>when I'm the oracle user, but STILL says the ORA-01034 when I'm the
>normal user on the system.
>
>I definitely have the environment variables set (at least, the
>ORACLE_HOME, ORACLE_SID, and ORACLE_BASE), or else I wouldn't be able to
>get INTO sqlplus in the first place.
>
>I even tried putting my other user account in the dba group for the
>box.  Didn't help.
>
>What am I doing wrong?
>
>A big "Thank you very much" for any input ahead of time.
>
>Kia