Tuesday, February 23, 2010

file-max parameter for Oracle database 11G R12 on Ubuntu

While installing a Oracle 11G release 2 database on Ubuntu Linux I encountered the following error:

OS Kernel Parameter: file-max

This is a prerequisite condition to test whether the OS kernel parameter "file-max" is properly set.
Expected Value
: 6815744
Actual Value
: 198903

Stating that the file-max kernel setting should read 6815744. The solution to this is to edit the file /etc/sysctl.conf and add the (or change a existing line to) line to the following:

fs.file-max = 6815744

After you have done so you will have to activate the new file-max setting. One can do so by a reboot or you can do it on the fly by executing the following command:

sysctl -p /etc/sysctl.conf

This should have resolved your issue. You can check it by executing the oracle database installer or you can directly check from the command line by executing the following command:

cat /proc/sys/fs/file-max

The result of this should now list 6815744


Unknown said...

thanks you ! it worked ..

Unknown said...

thanks you sir.. ...... !