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
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:Received on Thu Apr 18 1996 - 00:00:00 CEST
>
>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