Re: SQLPlus errors

"Alex" <agrasic_at_sympatico.ca> wrote in
news:3%L5a.9267$sv3.1044775_at_news20.bellglobal.com:

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

1. login as user oracle
2. env | sort -o /tmp/oracle.env
3. login as "another" user
4. env | sort -o /tmp/other.env
5. diff /tmp/other.env /tmp/oracle.env adjust as necessary

HTH & YMMV HAND! Received on Sat Feb 22 2003 - 09:24:49 CST