Re: ?Only DB owner can run sqlplus?

Most likely your other users are not getting the ORACLE_SID and/or the ORACLE_HOME
variables set.

HTH
Jim Gregory

>==========Bob Stewart, 7/2/96==========
>
>I'm having a problem with a seldom used instance we host for another
>group in our company. 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.

Opinions expressed are mine and do not reflect those of my company or clients. Received on Wed Jul 03 1996 - 00:00:00 CEST