Tuesday, February 23, 2010

shmmax parameter for Oracle database 11G R12 on Ubuntu

When installing a Oracle database 11G release 2 on a Linux system you can encounter the following error:

OS Kernel Parameter: shmmax
This is a prerequisite condition to test whether the OS kernel parameter "shmmax" is properly set.
Expected Value : 536870912
Actual Value : 33554432

The SHMMAX parameter is used to define the maximum size (in bytes) for a shared memory segment and should be set large enough for the largest SGA size. If the SHMMAX is set incorrectly (too low), it is possible that the Oracle SGA (which is held in shared segments) may be limited in size.

The way to solve this issue is executing the following commands:

echo "kernel.shmmax=536870912" >> /etc/sysctl.conf
sysctl -p /etc/sysctl.conf

This should resolve your issue and make sure you can install your database.

1 comment:

Anonymous said...

Thank you very much indeed