Re: ORA-07429 ..Any idea what my problem is?

Bill Tierney (wtierney_at_stanford.edu) wrote:
: I've installed Oracle 7.2.2.3 on AIX 4.1.
: When I'm on the system I can connect to
: the instance just fine. However,
: if I'm on another machine and try
: to connect I get:
:
:
: SQL*Plus: Release 3.2.2.0.0 - Production on Sun Jul 7 13:58:59 1996
:
: Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
:
: ERROR: ORA-01034: ORACLE not available
: ORA-07429: smsgsg: shmget() failed to get segment.
: IBM AIX RISC System/6000 Error: 2: No such file or directory
:
:
: Does anyone have any ideas? My listener
: is running. My database is up..

Looks like a protection problem. Make sure oracle is setgid dba and setuid oracle, e.g.:

-rwsr-s--x 1 oracle dba 7975351 May 26 21:40 /opt/oracle/bin/oracle

dave

-- 
David-Michael Lincke
Research Assistant
Institute for Information Management IWI-HSG, University of St. Gallen
EMail:	David-Michael.Lincke_at_iwi.unisg.ch, dlincke_at_sgcl1.unisg.ch
URL:	http://www-iwi.unisg.ch/about/team/dal.html