Re: Server / Listener Problems

In article <NEWTNews.840472484.28504.Kevin_Hrim_at_XCO3550khrim.co.xerox.com> khrim_at_roch875.mc.xerox.com writes:
>
>In Article<4v16em$1pj_at_mtinsc01-mgt.ops.worldnet.att.net>, <wsluk_at_postoffice.worldnet.att.net> writes:
>> Path: rocksanne!parc!news.Stanford.EDU!agate!howland.erols.net!panix!netaxs.com!hunter.premier.net!news-res.gsl.net!news.gsl.net!usenet.eel.ufl.edu!arclight.uoregon.edu!netnews.worldnet.att.net!newsadm
>> From: William Luk <wsluk_at_postoffice.worldnet.att.net>
>> Newsgroups: comp.databases.oracle
>> Subject: Server / Listener Problems
>> Date: 16 Aug 1996 07:02:46 GMT
>> Organization: Self
>> Lines: 19
>> Message-ID: <4v16em$1pj_at_mtinsc01-mgt.ops.worldnet.att.net>
>> NNTP-Posting-Host: 46.los-angeles-3.ca.dial-access.att.net
>> Mime-Version: 1.0
>> Content-Type: text/plain; charset=us-ascii
>> Content-Transfer-Encoding: 7bit
>> X-Mailer: Mozilla 1.22ATT (Windows; U; 16bit)
>>
>>
>> We are running Oracle 7 server on an X86 Solaris 2.5.
>> I finished installing the Oracle 7 server (version 7.3.2.1)
>> with SQL*Net version 2.3. When I tried to access the
>> server from a sqlplus client, I got the following errors on
>> the client:
>>
>> ERROR: ORA-01034: ORACLE not available
>> ORA-07429: smsgsg: shmget() failed to get segment.
>> NCR System 3000 Error: 2: No such file or directory
>>
>> Oracle support has been working on this for couple weeks, and
>> is not sure where the error is coming from.
>>
>> Any help will be greatly appreciated...
>>

Could you be a little more exact as to what you are typing in when you get this. It's almost as if you are looking at the wrong server...

>> WSL
>>
>>
>
>Make sure to check the ownership of files,shared memory etc..
>
>The command "ipcs" should show ownership of "oracle" and a group of "dba" for
>the existing instance structures.
>
>If your system starts oracle automatically (most do) after a reboot, the "ipcs
>" could show an ownership of "root" and group of "other" for the shared memory

If the ownership is incorrect, someone probably didn't follow the directions for starting up. The rc startup file should have a command like:

su oracle -c "$ORACLE_HOME/bin/dbstart"

I usually like to redirect the output to its own file in $ORACLE_HOME, so I can look at it later if necessary.

>and semaphores. The following is an output of "ipcs"
>
>Shared Memory:
>m 9000 0x0a52f50b --rw-rw---- oracle dba
>m 1 0x1252f50b --rw-rw---- oracle dba
>m 2 0x1a52f50b --rw-rw---- oracle dba
>m 3 0x0c94c199 --rw-rw---- oracle dba
>m 8004 0x0d297b01 --rw-rw---- oracle dba
>m 5 0x15297b01 --rw-rw---- oracle dba
>m 6 0x1d297b01 --rw-rw---- oracle dba
>m 1007 0x0e94c082 --rw-rw---- oracle dba
>m 5008 0x0d297feb --rw-r----- oracle dba
>m 9 0x00000184 --rw-rw-rw- arbor staff
>Semaphores:
>s 0 0x0x00000000 --ra-ra---- oracle dba
>s 1 0x0x00000000 --ra-ra---- oracle dba
>s 2 0x0x00000000 --ra-ra---- oracle dba
>s 65539 0x0x00000000 --ra-ra---- oracle dba
>s 327684 0x0x00000000 --ra-r----- oracle dba
>
>I have a number of oracle instances running on this server, but note that all
>of the structures have ownership of oracle and group of dba.
>
>If yours does not look similar to this you have a problem. This can be caused
>by incorrect ownership/sticky bit settings of the oracle executeable. The
>following directory entry was cut from my Solaris 2.4 / Oracle 7.1.6 system.
>
>-rwsr-s--x 1 oracle dba 9159320 Jul 23 1995 oracle
>
>I hope this info helps
>
>Kevin Hrim
>
>//Been there, Done that//
>
>

-- 
Joel Garry               joelga_at_rossinc.com               Compuserve 70661,1534
These are my opinions, not necessarily those of Ross Systems, Inc.   <> <>
%DCL-W-SOFTONEDGEDONTPUSH, Software On Edge - Don't Push.            \ V /
panic: ifree: freeing free inodes...                                   O