ora 01034 & 07320

Vaidhyanatha K Kumar

unread,

Jun 22, 1998, 3:00:00 AM6/22/98

to

HI guys,

I am having problems with SGA i guess.
Can some one tell me how to fix the following error.

Thanks
kumar

jane 37% sqlplus

SQL*Plus: Release 3.3.2.0.0 - Production on Mon Jun 22 13:22:55 1998

Enter user-name: kvk
Enter password:
ERROR: ORA-01034: ORACLE not available
ORA-07320: smsget: shmat error when trying to attach sga.
SVR4 Error: 13: Permission denied

rwes...@us.oracle.com

unread,

Jun 23, 1998, 3:00:00 AM6/23/98

to

Vaidhyanatha K Kumar <ku...@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
rwes...@us.oracle.com

Joel Garry

unread,

Jun 24, 1998, 3:00:00 AM6/24/98

to

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 jga...@nospameiq.com
"See your DBA?" I AM the @#%*& DBA! Remove nospam to reply. Sorry.

Vaidhyanatha K Kumar

unread,

Jun 25, 1998, 3:00:00 AM6/25/98

to

Joel Garry wrote:
>
> On 23 Jun 1998 10:42:48 -0400, rwes...@us.oracle.com <rwes...@us.oracle.com> wrote:
> >Vaidhyanatha K Kumar <ku...@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.

i need your advice.

Thanks in advance
Vaidhy Kumar

Joel Garry

unread,

Jun 26, 1998, 3:00:00 AM6/26/98

to

Be sure that the segments are owned by oracle/dba with an ipcs -a. Are
you starting up Oracle as the oracle user? (I know, silly, but have to
ask). I have seen problems like this where the segments are owned by oracle
but a different group somehow due to weird startup. Also, I have seen
(at least on SunOS) oracle killed incorrectly, keeping the segments around,
so the next person that logs in can't attach because there aren't any left.
You don't have to apologize if you have forgotten to export/setenv your
ORACLE_HOME for the user... :)

Permission denied means just that, it's trying to do something where the
group or owner is wrong.

I've seen the dbhome oratab oraenv combination mess people up after reinstalling
oracle into a new home but still having those old files around messing up the
SID whenever a subshell is made.

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

Pebble In The Sky http://www.informationquest.com mailto:jga...@nospameiq.com
http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply.
mailto:joel_...@compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA!

rwes...@us.oracle.com

unread,

Jun 29, 1998, 3:00:00 AM6/29/98

to

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.