Re: ORA-07279: ...unable to get first semaphore set

I ran into the same error the other day with multiple V6 instances. The problem is probably related to the setting for SEMMNS kernel parameter and its relationship to the value(s) used for the processes parameter in your init.ora files. As I understand it, SEMMNS sets the upper bound for the maximum number of semaphores that are available for all processes running on the system. So, if this is set to 100, for example, and one Oracle instance starts up with processes=100, then all the semaphores are spoken for. For the platform I work with, I believe the default processes parameter is 20 or 25, so it may be that 4-5 instances are exceeding the limit established by the kernel parameter SEMMNS. Hope this helps.

Tom Getts
Database Administrator/Geophysicist
Conoco, Inc.
Houston, TX Received on Sat Dec 10 1994 - 14:45:57 CET