Re: SQLPlus only works on 'oracle' user

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_at_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
Received on Wed Feb 02 2000 - 04:18:23 CST