Path: news.easynews.com!easynews!news-xfer2.newshosting.com!newsfeed.rt.ru!image.surnet.ru!surnet.ru!carrier.kiev.ua!news.alkar.net!ATNS!not-for-mail
From: "Sergey Keberle" <prog@unisoft.dp.ua>
Newsgroups: comp.databases.oracle.server
Subject: OpenServer + could not allocate semaphores for Oracle
Date: Thu, 6 Jun 2002 16:15:58 +0400
Organization: Alkar Teleport News Server
Lines: 26
Message-ID: <adnngf$1hdi$4@pandora.alkar.net>
NNTP-Posting-Host: dial-225-142.alkar.net
X-Trace: pandora.alkar.net 1023369553 50610 212.86.225.142 (6 Jun 2002 13:19:13 GMT)
X-Complaints-To: abuse@alkar.net
NNTP-Posting-Date: Thu, 6 Jun 2002 13:19:13 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-Comment-To: All
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
X-FTN-Tearline: Tearline sample
X-FTN-Origin: Origin sample
FL-Build: Fidolook Express 2000 UIExt. BuildID: 3BC00FAD (7/10/2001 12:17:49).
Xref: easynews comp.databases.oracle.server:149742
X-Received-Date: Thu, 06 Jun 2002 06:16:40 MST (news.easynews.com)

Hi!

I have Oracle 7.1.6 + OpenServer 5.0.6.
There are 100 users on this server. But at the same time only 60 of 100
users can work with Oracle.
When the next user try to connect I recieve the following Oracle error:
ORA-07252 spcre: semget error, could not allocate semaphores
Cause: SEMGET system call returned an error. Possible resource limit
problem.
Action: Check errno. Verify that enough semaphores are available in system.
If additional errors occur in destroying the semaphore sets then sercose[0]
will be non-zero. If this occurs, remove the semaphore sets using IPCRM.
In init.ora I have the following parameter:
processes=200
I try to increase all core parameters of OpenServer such as:
SEMMNI    4096
SEMMAP   4096
SHMMNI    1000
SEMMNU   100
I try to increase even semaphores for XENIX :)
But nothing helps me.

Does anyone know how to solve with problem?
Sergey


