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

This is a problem of SQL*Net configuration. The SID is not set correctly. You will get the same problem in the server also if you do not set ORACLE_SID. Another problem area area is the tcp port number.

Best Wishes
Anbu.

Louis Lajoie <llajoie_at_videotron.ca> wrote in article <3431260B.B6D19E4F_at_videotron.ca>...
> Hello all:
>
> 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.
>
> Does it ring a bell anyone?
>
> Thanks in advance
>
> Louis Lajoie
> Consultant
>
>
Received on Fri Oct 03 1997 - 00:00:00 CDT