Tuesday, February 23, 2010

mem parameter for Oracle database 11G R12 on Ubuntu

When installing Oracle database 11G release 2 on a Ubuntu Linux you can come accross some mem related parameters which you have to set correctly.

Most likely those will be:
- rmem_default
- rmem_max
- wmem_default
- wmem_max

The Oracle database installer will check those and expects certain values for those parameteres.

- rmem_default = 262144
- rmem_max = 4194304
- wmem_default = 262144
- wmem_max = 1048576

To set those parameters in such a way that it will stay after a reboot you will have to make some changes to the file /etc/sysctl.conf . You will have to add the following:

net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_max=1048576

after you have added those lines you can activate them without a reboot by executing the following command:

sysctl -p /etc/sysctl.conf

After this your database should be able to install.

No comments: