Re: ORA-07279 semget error

From: Vikram Goel <vgoel_at_pts.mot.com>
Date: 1996/04/18
Message-ID: <4l5ius$so7_at_lserv1.paging.mot.com>#1/1


Bob,

The error you are receiving has to do with semaphores and semaphore sets on the IRIX/ Unix os. Basicly Oracle needs semaphores to have its processes coordinate access to system shared resources.
Check your ports installation manual for the specific setting of the following

Unix kernal parms: SHMMAX : Max size of a single shared memory segmwnt
                   SHMMNI : # of shared memory identifers
                   SHMSEG : Max # of segments that can be aquired by one process
                   SEMMNS : # of semaphores in the os.
                   SEMMNI : # of semaphore sets that can be created on the system.

If you are running multiple databases on a server, you will have to adjust these parms, you should also check your OS manuals on the max settings etc. Kernal rebuild of the os is usually required after changing these parms.

Hope this helps.

--
Vikram Goel                                 Motorola email: vgoel_at_pts.mot.com
Sr. Oracle DBA - Consultant
Aerotek Inc.                                My email:  vgoel_at_emi.net

Motorola Info:
Mail Stop 39, Room S1014
1500 Gateway Blvd,
Boynton Beach, FL 33426 


In article <NEWTNews.829784603.10501.bevans_at_bje.avl.com>, bevans_at_pinpoint.avl.com writes:

>
>Installing 7.2 on a Tamdem 4401 (Irix 5.3) I encountered
>the following errors:
>Action: Running crdbdtb1.sql
>Command: (/sw1/oracle/bin/sqldba _at_/sw1/oracle/dbs/crdbdtb1.sql),
>Out=/sw1/oracle/orainst/install.log, Err=/sw1/oracle/orainst/install.log
>{

>SQL*DBA: Release 7.2.2.3.0 - Production on Wed Apr 17 15:40:31 1996
>Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>Oracle7 Server Release 7.2.2.3.0 - Production Release
>PL/SQL Release 2.2.2.3.0 - Production
>File /sw1/oracle/dbs/crdbdtb1.lst opened Wed Apr 17 15:40:33 1996.
>Connected.
>ORA-07279: spcre: semget error, unable to get first semaphore set.
>SVR4 Error: 28: No space left on device
>Additional information: 1
>DBA-00342: unable to complete internal login
>ORA-01034: ORACLE not available
>ORA-07429: smsgsg: shmget() failed to get segment.
>SVR4 Error: 2: No such file or directory
>Disconnected.
>I had just successfully completed 3 installations on SGI Indy workstations
>also under Irix 5.3
>BOB
>
>---------------------------------------
>Bob Evans
>Pinpoint Communications
>14651 Dallas Parkway
>Suite 600
>Dallas, Texas 75240
>
>bevans_at_pinpoint.avl.com
Received on Thu Apr 18 1996 - 00:00:00 CEST

Original text of this message