Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQLPlus errors

Re: SQLPlus errors

From: Thomas Woisczyk <Thomas.Woisczyk_at_t-online.de>
Date: Sat, 22 Feb 2003 21:34:30 +0100
Message-ID: <b38mv7$p05$03$1@news.t-online.com>


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?
>
>

Hi,
is $ORACLE_SID set? Does the listener work correct, is tnsnames.ora in the directory $OH/network/admin correct, has the user access to this file, is sqlnet.ora correct ...

Greetings Thomas Received on Sat Feb 22 2003 - 14:34:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US