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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to