Re: ora 01034 & 07320

On 23 Jun 1998 10:42:48 -0400, rwessman_at_us.oracle.com <rwessman_at_us.oracle.com> wrote:
>Vaidhyanatha K Kumar <kumar_at_engr.orst.edu> writes:
>>
>> HI guys,
>>
>> I am having problems with SGA i guess.
>> Can some one tell me how to fix the following error.
>>
>> Thanks
>> kumar
><snip>
>>
>> ERROR: ORA-01034: ORACLE not available
>> ORA-07320: smsget: shmat error when trying to attach sga.
>> SVR4 Error: 13: Permission denied
>Check the permissions on the Oracle executable. Make sure that they are 4755
>and that the executable is owned by the "oracle" user (or whatever user has
>been designated as the Oracle user).
>
> Hope this helps,
> Rick
> Rick Wessman
> Distributed Data Security
> Oracle Corporation
> rwessman_at_us.oracle.com

You can also get this by simply having the wrong ORACLE_HOME (or TWO_TASK) and some more obscure things having to do with shared memory.

--
These opinions are my own and not necessarily those of Information Quest

or Pebble In The Sky                     http://www.informationquest.com

http://ourworld.compuserve.com/homepages/joel_garry jgarry@nospameiq.com
"See your DBA?"  I AM the @#%*& DBA!     Remove nospam to reply.  Sorry.