Re: Do you know why this is happening in Oracle?
Date: 22 Apr 1994 13:06:02 -0400
Message-ID: <2p905q$fll_at_access3.digex.net>
In article <2p3rccINNa09_at_life.ai.mit.edu>,
Stuart Cracraft <cracraft_at_rice-chex.ai.mit.edu> wrote:
>
>> sqldba
>
>SQL*DBA: Version 6.0.36.4.1 - Production on Wed Apr 20 11:10:35 1994
>
>Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.
>
>ORACLE RDBMS V6.0.36.4.1, transaction processing option - Production
>PL/SQL V1.0.35.1.1 - Production
>
>SQLDBA> startup
>ORA-07252: spcre: semget error, could not allocate semaphores.
>SunOS Error: 28: No space left on device
>Additional information: 2
>SQLDBA> exit
>SQL*DBA complete.
>
By deault, if more than 60 Oracle processes are required (56 concurrent Oracle users) you will receive a SEMGET (SEMaphore GET) error from the operating system:
(Oracle error ORA-07252 with an accompanying SunOS Error 28).
To eliminate this, edit the file param.c file (the param.c file is in the /usr/kvm/sys/<machine type>/<kernel name> directory) to read as follows:
#ifdef IPCSEMAPHORE
#include <sys/sem.h>
#define SEMMNS 68 /* Number of semaphores system wide. */
#endif IPCSEMAPHORE
When the kernel is re-made, the compiler will provide a warning indicating that SEMMNS was redefined, ignore this warning. Received on Fri Apr 22 1994 - 19:06:02 CEST