Oracle-L: Re: Unrecognized shared memory "entry"

From: Christian Trassens <ctrassens_at_yahoo.com>
Date: Mon, 11 Mar 2002 09:58:27 -0800
Message-ID: <F001.00424C2E.20020311095827@fatcity.com>

It is usually a leakable problem. Processes might have taken a set and might have not released it. Try with ipcrm to deallocate it:

ipcrm -s <no-entry set>

Regards
--- Louis Avrami <avramil_at_concentric.net> wrote:
>
> Hi folks,
>
> We're running an Oracle 8.1.7.2 database on a Sun
> 420R, Solaris
> 2.6.
>
> Recently we had a look at the shared memory
> allocation via the
> 'ipcs -a'
> command and noticed that there is a "no-entry"
> listing in the
> semaphore
> section:
>
> $ ipcs -a
> IPC status from <running system> as of Sun Mar 10
> 15:07:42 2002
> Message Queue facility not in system.
> T ID KEY MODE OWNER
> GROUP CREATOR
> CGROUP NATTCH SEGSZ CPID LPID ATIME
> DTIME CTIME
> Shared Memory:
> m 0 0x50000a88 --rw-r--r-- root
> root root
> root 1 68 248 248 21:24:00 21:24:00
> 21:24:00
> m 1301 0x03309dc4 --rw-rw---- oracle
> dba oracle
> dba 15 687087616 14289 14409 15:06:06 15:06:08
> 15:04:26
> T ID KEY MODE OWNER
> GROUP CREATOR
> CGROUP NSEMS OTIME CTIME
> Semaphores:
> s 3801088 0xe8945334 --ra-ra---- oracle
> dba oracle
> dba 152 15:05:09 15:04:36
> s 1048577 0xe8945335 --ra-ra---- oracle
> dba oracle
> dba 152 no-entry 15:04:36
> s 851970 0xe8945336 --ra-ra---- oracle
> dba oracle
> dba 152 15:04:39 15:04:36
>
>
> This doesn't appear on any of our other Solaris 2.6,
> 2.7 or 2.8
> servers.
>
> Does anyone know what the "no-entry" semaphore
> listing means?
>
> The specific OS version is:
>
> $ uname -a
> SunOS scmsdb01 5.6 Generic_105181-29 sun4u sparc
> SUNW,Ultra-60
>
>
> Lou Avrami
>
>
>
>
>
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Louis Avrami
> INET: avramil_at_concentric.net
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).

Ing. Christian Trassens
Senior DBA & Unix Administrator
Phone: 0034-699240979
0034-649824704

Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christian Trassens
  INET: ctrassens_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Mar 11 2002 - 11:58:27 CST