Re: SQL*Plus/Net error ORA-01034:ORA-07429

From: Andrew Semple <bart_at_ionews.io.org>
Date: 11 Apr 1994 08:59:05 -0000
Message-ID: <2ob3gp$2rt_at_ionews.io.org>


In article <1994Apr7.024351.15162_at_schbbs.mot.com>, Jeff Mounce <mounce_at_mot.com> wrote:
>Hello,
>
>I am getting an error that Oracle Tech Support has been unable to solve.
>(So, I am posting it here....)
>
>When I run SQL*Plus on either my PC or another SunOS 4.1.3 machine to my
>server (Solaris 2.3), I get the following error:
>
>ERROR: ORA-01034: ORACLE not available
>ORA-07429: smsgsg: shmget() failed to get segment.
>SVR4 Error: 2: No such file or directory
>
>Yes, the instance is running, and the database is available and open and
>mounted.
>Locally as either ORACLE or any other USER, SQL*Plus has no problem. But
>remotely, this same error comes up. Logs and Traces (client & server)
>have no apparent errors.
>

  I believe we encountered this problem under AIX 3.2.5 and Oracle 7.0.15 when the oracle executable in ~whereveroracleis/product/blah/bin is not setuid. This arised after we forgot to run the root<whatever>.sh after install.

  Sorry for the lack of details.

-- 
------------------------------------------------------------------------------
Andrew D. Semple                    bart_at_io.org
Toronto, Canada
Received on Mon Apr 11 1994 - 10:59:05 CEST

Original text of this message