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

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 Wed Oct 01 1997 - 00:00:00 CDT