Well it's not the local SQLPlus on the machine I'm having a problem with
anymore, it's the SQLPlus Client on Windows that won't connect properly
"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
news:pan.2003.02.23.03.24.05.345116_at_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 Sun Feb 23 2003 - 20:08:17 CST
