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

From: Ronald <ronr_at_wxs.nl>
Date: Thu, 8 Oct 1998 21:22:21 +0200
Message-ID: <01HW.B242DD8D000A1E05020AF420@news.wxs.nl>

On Wed, 7 Oct 1998 18:44:46 +0200, Brian Fane wrote (in message <361B9A7E.1459BE77_at_indstate.edu>): snip
> on the SID, permissions on files, etc. Everything SEEMS to check out okay.
> It'll even work fine if I set TWO_TASK.
>
> I'm about optioned out... Anyone have a suggestion? I'd appreciate it...
>
> $ sqlplus ccfane
>
> SQL*Plus: Release 3.3.3.0.0 - Production on Wed Oct 7 11:18:28 1998
>
> Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
>
> Enter password: ERROR: ORA-01034: ORACLE not available ORA-07429: smsgsg:
> shmget() failed to get segment. HP-UX Error: 2: No such file or directory

Hi Brian,

could it be that the database you try to connect is remote ? (not on the same machine where you start sqlplus from). By setting TWO_TASK you force to go via sql*net and this is the way to connect a remote database. How about different tnsnames.ora files hanging around ?

--
Ronald

---

mailto:ronr_at_wxs.nl
http://home.wxs.nl/~ronr/RonR.html (last update: june 8th, 1998) http://www.maccentral.com/news/9804/migration.shtml (forward migration home)

The best way to accelerate a machine running windows is at 9.8 m/s^2 Received on Thu Oct 08 1998 - 14:22:21 CDT