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

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

>> Any help is appreciated. As I said, Oracle Support has been stumped.
 

>We had the same problem using HP-UX 9.0 in our environment. The reason for
>this problem is in our environment, the mounting of the file-systems on
>each client. We solve the problem using automount instead of hard unix-mounts.
 

>Bye, Timo.

We had the same Problems on a RS/6000; Try setting user id for programmes 'oracle' ans 'orasrv' (chmod ...)!

Bye Manfred

Dr. Manfred BENEDER

Johannes Kepler University Linz                ///////  ///////  ///////
Institute for Systems Sciences                /        /        /     /
Dept. of Systems Engineering & Automation    /        /        /     /
Altenbergerstr. 69                          ///////  ///////  ///////
A-4040 Linz / Austria / Europe                   /  /        /     /
Tel.: +43 732 2468 871                          /  /        /     /
Fax : +43 732 2468 878                    //////  ///////  /     /