Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-07279: spcre: semget error, unable to get first semaphore

RE: ORA-07279: spcre: semget error, unable to get first semaphore

From: Philip West <P.West_at_g-icap.com>
Date: Tue, 8 Aug 2000 11:55:27 +0100
Message-Id: <10583.114048@fatcity.com>


semaphore are 'flags' that control access to resources. If you increase oracle processes you must increase semaphores. If you have a unix sysadmin get them to do it. If you are the sysadmin you need to edit the /etc/system file and increase the semsys: seminfo_semmns parameter (oracle recommends to twice the combined value of 'processes' for all oracle instances. You must then reboot the machine for the change to take effect.

If you cannot reboot right now, then compare the /etc/system value with the processes value in the init.ora and adjust it downward so that you can get the instance up and running.

Phil West
Unix Sys Admin and Oracle Financials DBA +44 (0) 20 7623 5222 x5221

-----Original Message-----
From: Weerd de E.C. Kirsten [mailto:Kirsten.deWeerd_at_oranjewoud.nl] Sent: 08 August 2000 12:34
To: Multiple recipients of list ORACLE-L Subject: ORA-07279: spcre: semget error, unable to get first semaphore set

Hi,

I Increased the processes in my init.ora file, and got the following error on startup :

07279, 00000, "spcre: semget error, unable to get first semaphore set."
// *Cause: An error occurred when trying to get first semaphore set.
// *Action: Check errno. Verify that system is configured to have
semaphores.
// Verify that enough semaphores are available. Additional information
// indicates how many semaphores were requested.

HP-UX Error: 28: No space left on device Additional information: 1

Oracle 7.2.3 on HP-UX 10.20

I'm no expert (what else is new) so as always, help is greatly appreciated ...

Greets,

Kirsten

-- 
Author: Weerd de E.C. Kirsten
  INET: Kirsten.deWeerd_at_Oranjewoud.nl

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


*******************************************************************************
The information in this Internet e-mail is confidential and may be legally privileged.  It is intended solely for the addressee.  Access to this Internet e-mail by anyone else is unauthorised and any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. 
 When addressed to our clients any opinions or advice contained in this Internet e-mail are subject to the terms and conditions expressed in any applicable documentation or market practices governing the relationship between Garban Intercapital plc and its clients.

Any views expressed in this message are those of the individual sender except where they are stated to be the views of Garban Intercapital plc.
*******************************************************************************
Received on Tue Aug 08 2000 - 05:55:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US