Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-07429: smsgsg: shmget() failed to get segment
The ORA-01034 means that your instance is not up. By instance, I mean all the background processes that access the database files. Try shutting down and restarting your instance(s). If it were a SQL*Net error, you would get an TNS-12xxx error message stating that the specified database could not be reached. Questions? pbump_at_us.oracle.com
-- Phillip Bump pjbump_at_i1.net Louis Lajoie <llajoie_at_videotron.ca> wrote in article <3431064B.B1C71F1F_at_videotron.ca>...Received on Sun Oct 05 1997 - 00:00:00 CDT
> Hello all:
>
> When trying to access our database 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
>
>