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

It turns out there is a bug in the parsing of the listener.ora file. If the string used for $ORACLE_HOME ends with a "/", e.g. "/oracle/home/", the listener apparently tries to establish a connection to a nonexistent instance.

Needless to say, it will be fixed.

                                    Rick
                                    Rick Wessman
				    Server Techologies - Network Products
				    Oracle Corporation
                                    rwessman_at_us.oracle.com

In article <2ob3gp$2rt_at_ionews.io.org> bart_at_ionews.io.org (Andrew Semple) writes:

>Path: oracle!gatekeeper.us.oracle.com!sgiblab!swrinde!cs.utexas.edu!utnut!torn!uunet.ca!uunet.ca!ionews.io.org!nobody
>From: bart_at_ionews.io.org (Andrew Semple)
>Newsgroups: comp.databases.oracle
>Date: 11 Apr 1994 08:59:05 -0000
>Organization: Internex Online (io.org) Data: 416-363-4151 Voice: 416-363-8676
>Lines: 32
>References: <1994Apr7.024351.15162_at_schbbs.mot.com>
>NNTP-Posting-Host: nudge.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 - 16:49:32 CEST