Re: ORA-07279 semget error

bevans_at_pinpoint.avl.com wrote:
>
>
> 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
>
> Of course, we are missing
> "Oracle7 Server Error Messages and Codes Manual".
>
> Can anyone shed any light on my problem ?
>
> Thanks much
>
> BOB
>
> ---------------------------------------
> Bob Evans
> Pinpoint Communications
> 14651 Dallas Parkway
> Suite 600
> Dallas, Texas 75240
>
> bevans_at_pinpoint.avl.com
>
>
>

Increase SEMMNS - number of semaphores system wide.
Increase SEMMNI - number of semaphore identifiers.
Increase SEMMSL - number of semaphore per id.

These number depends on the following factors.

Number of Oracle process you want to start. Number of Instances on the machine.

Most importantly, the amount of memory available on the system.

After increasing these system parameters 'SPIN' the kernel and try again.

GOOD LUCK Received on Sat Apr 20 1996 - 00:00:00 CEST