Re: ?Only DB owner can run sqlplus?

From: Martyn Jones <martyn1>
Date: 1996/07/05
Message-ID: <4rig6q$dbu_at_news-s01.ny.us.ibm.net>#1/1


In article <4rgnjp$9vd_at_tpd.dsccc.com>, jstrange_at_imtn.dsccc.com (John Strange) says:
>
>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.

Check the PATH and ORACLE_HOME etc. environment variables are set up to include your Oracle directories etc. (Just like the owner ...)

Martyn Jones
The Data Warehouse Initiative Received on Fri Jul 05 1996 - 00:00:00 CEST

Original text of this message