Re: ora 01034 & 07320

On Thu, 25 Jun 1998 12:43:41 -0700, Vaidhyanatha K Kumar <kumar_at_engr.orst.edu> wrote:
>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.
>
>i need your advice.
>
>Thanks in advance
>Vaidhy Kumar

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:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Thu Jun 25 1998 - 19:53:17 CDT