Re: SQLPlus errors

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sun, 23 Feb 2003 14:24:07 +1100
Message-ID: <pan.2003.02.23.03.24.05.345116@yahoo.com.au>

On Sat, 22 Feb 2003 09:01:49 +0000, Alex wrote:

> Hello! I have just installed Oracle 9i Release 9.2.0.1.0. I am trying to
> get SQLPlus working on my database server but I have one little problem.
> Only the oracle user (who setup the software) can access SQLPlus with any
> Oracle user account to do any database functions BUT when someone other than
> the unix oracle user tries to use SQLPlus, as soon as they enter their
> Oracle user ID, they get a
> ORA-01034: ORACLE not available
> ORA-27121: unable to determine size of shared memory segment
> Linux Error: 13: Permission denied
> Now, I can only assume that the file system is restricting access to some
> file, hence the Linux Error, but even after I chmod 777 every file under the
> $ORACLE_HOME directory structure, I continue to get this error.
>
> What am I doing wrong?

Not setting the Oracle environment variables for the other users, probably. If things like ORACLE_SID and ORACLE_HOME are not set correctly in .bashrc (or an equivalent), or manually before firing off SQL Plus, then these are the sorts of errors you get.

Regards
HJR
in Received on Sat Feb 22 2003 - 21:24:07 CST