Re: ORA-07429: smsgsg: shmget() failed to get segment.

Check the Operating System Privileges on both the oracle executable (should be chmod 6751 oracle)

and if running sqlnet v1 then the orasrv process must be owned by root and have the sticky bits set as well (chown root orasrv; chmod 6751 orasrv)

Billy Verreynne <vslabs_at_onwe.co.za> wrote in article <01bcce31$c5855420$ba030059_at_billyv.vslabs.co.za>...
> Louis Lajoie <llajoie_at_videotron.ca> wrote in article
> <3431260B.B6D19E4F_at_videotron.ca>...
> > When trying to access our database (with 3 instances) on our HP-UX
> > server from a PC with
> > SQL*Plus, we get these messages:
> >
> > ERROR: ORA-01034: ORACLE not available
> > ORA-07429: smsgsg: shmget() failed to get segment.
> > HP-UX Error: 2: No such file or directory
> >
> > The same DB can be accessed without any problem on the server itself.
>
> A shot in the dark. If you can access the db locally, it means that the
> oracle instance is up and running ok. If you try and connect from a
 client,
> the client first connects to the oracle listener on the server. If the
> listener was not running, you should be getting a message regarding
 failed
> to resolve/use the specified tns name. And you're not getting that error.
> Ok, after the client has connected to the listener, the listener opens a
> connection with the oracle db instance. I think that the problem occurs
> there. I've hit my head against the above error message whenever my
> ORACLE_SID is wrong. I think that either your listener's config is wrong
> and it's trying to connect to a non-existance db instance, or the
> environment/userid the listener runs in do not contain the correct oracle
> variables (like ORACLE_HOME, ORACLE_SID etc.).
>
> Hope this helps. :-)
>
> regards,
> Billy
>
>
Received on Thu Oct 02 1997 - 00:00:00 CDT