Re: ?Only DB owner can run sqlplus?

bob_at_latcost1.alaao.ats.eds.com (Bob Stewart) wrote:

>For some reason, only the Oracle user can run
>sqlplus. When another user tries to run sqlplus, I get the following
>messages:
>
>$ sqlplus x/y
>
>SQL*Plus: Release 3.1.3.5.1 - Production on Tue Jul 2 13:25:46 1996
>
>Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
>ERROR: ORA-01034: ORACLE not available
>ORA-07320: smsget: shmat error when trying to attach sga.
>SVR4 Error: 13: Permission denied
>
>
>Note that the Oracle userid CAN run sqlplus. Can anyone offer any help?
>
>TIA.
>--
>Bob Stewart ASE
>(310) 335-7152 Air Transportation Division
>bob_at_latcost1.alaao.ats.eds.com
>
>I am definitely NOT speaking for EDS.

You might want to make sure that permissions on $ORACLE_HOME/bin/oracle are set to 4761 and the owner is oracle (which it sounds like it is). If the setuid bit is not there (i.e. not -rwsr-x--x ) then only oracle will be able to connect to the SGA.

Hope this solves it!
Mike Morgan

#include <disclaimer.std> Received on Wed Jul 03 1996 - 00:00:00 CEST