Re: SQLPlus errors

I would suspect that the setuid permissions on the 'oracle' executable may have been lost.

If you :-
ls -l $ORACLE_HOME/bin/oracle

Does it say something like
-rwsr-s--x .....etc....etc......... oracle

There are other files that need this set to.

This means that anyone that connects and uses oracle runs under the permissions of the oracle user and not themselves. If the little 's's are missing then you would get the below error (possibly).

You would need to
chmod u+s oracle
chmod g+s oracle
to fix it.

BUT it is very worrying if these have been lost. Did you run all the root.sh bit correctly when you installed it properly off the CDs?

Also ensure that all the relevant PATH/ORACLE_SID/ORACLE_HOME are set correctly too.

Liggs

"Alex" <agrasic_at_sympatico.ca> wrote in message 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?
>
>
Received on Sat Feb 22 2003 - 09:47:35 CST