Re: ?Only DB owner can run sqlplus?

You might try

        export TWO_TASK=$ORACLE_HOME

Bob Stewart (bob_at_latcost1.alaao.ats.eds.com) wrote:
: 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.

--
This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.