Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-07429: smsgsg: shmget() failed to get segment

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

From: Phillip Bump <pjbump_at_i1.net>
Date: 1997/10/05
Message-ID: <01bcd1cd$48835a40$cc30e6cf@default>#1/1

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>...

> 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
>
>
Received on Sun Oct 05 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US