Re: ora 01034 & 07320

Vaidhyanatha K Kumar <kumar_at_engr.orst.edu> writes:
>
> Joel Garry wrote:
> >
> > 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).
>
> Hi guys,
> I am still not able to fix the above problem. The permission on oracle
> binary is
> 4755. $ORACLE_HOME, TWO_TASK is set ok.
>
> Let me explain the scenario a little bit. I have 'oracle' user where the
> oracle software resides (software owner of oracle) and another user
> "meta" who is also of dba group.
> sqlplus runs fine from "oracle" user but not as meta user. I get the
> above error messages only as meta user. Do i need to reformat the unix
> kernel to fix sga problem ?
> if i use tstshm,I get the message "segments not attached contigously !"
> Does it mean anything ?. I checked with some oracle installations and
> they get the same message.
> Also, i am using only the mandatory environment variables
> ORACLE_HOME,ORACLE_SID,ORACLE_TERM and path of oracle binaries.
You didn't say what the owner of the oracle executable is. Make sure that it's "oracle".

The message from tstshm is OK. It just means that Oracle could not get a contiguous piece of shared memory for the SGA. Instead, it got it in pieces.

Hope this helps.

                                        Rick
                                        Rick Wessman
                                        Distributed Data Security
                                        Oracle Corporation
                                        rwessman_at_us.oracle.com