A UNIX administrator contacted us (all the way from San Diego) with a problem regarding semaphore configuration on a new HP-UX 11i v3 server running an Oracle database:
The default semaphore settings were:
SEMMSL=2048 (semaphores per set)
SEMMNI=2048 (number of sets)
He had read Oracle’s installation documentation which said that the product of these two parameters must be at least the number of PROCESSES as defined in the Oracle database’s init.ora. By default SEMMSL x SEMMNI = 4,194,304; much higher than the database’s PROCESSES parameter of 10,000.
Following Tune’n’Tools guidance, the UNIX administrator changed the parameters to:
The new settings resulted in product of 1,048,576, which should support 10,000 database processes right? So why did the database fail to start and report the following error?