Tuesday, February 23, 2010

semopm parameter for Oracle database 11G R12 on Ubuntu

When installing a Oracle database 11G release 2 database on Linux you can encounter the following error. I received this when installing Oracle database 11G release 2 on a Ubuntu Linux system.

OS Kernel Parameter: semopm

This is a prerequisite condition to test whether the OS kernel parameter "semopm" is properly set. (more details)
Expected Value : 100
Actual Value : 32


The SEMOPM kernel parameter is used to control the number of semaphore operations that can be performed per semop system call.

The semop system call (function) provides the ability to do operations for multiple semaphores with one semop system call. A semaphore set can have the maximum number of SEMMSL semaphores per semaphore set and is therefore recommended to set SEMOPM equal to SEMMSL. Oracle recommends setting the SEMOPM to a value of no less than 100. When you need to change the semopm value you can do the following:

echo "kernel.sem=250 32000 100 128" >> /etc/sysctl.conf
sysctl -p /etc/sysctl.conf

This should solve this issue and you should be able to install the database.

No comments: