I'm reading a oracle guide for installing a Database on redhat 6, but i don't understand why oracle recommend to set the file-max system parameter and nofile in /etc/sysctl.conf


So if i set nofile in /etc/security/limits.conf for oracle user, why i need to set a limit for the system wide?

Oracle parameters example in /etc/sysctl.conf:

fs.file-max = 65536  <------ UMMMMMMM ---->
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

Oracle parameters example /etc/security/limits.conf:

oracle           soft    nproc   2047
oracle           hard    nproc   16384
oracle           soft    nofile  1024
oracle           hard    nofile  65536 <----- UMMM so the hard limits of the oracle users is equal to the maximum system wide ---->

I think this oracle parameters are incorrect, but i would like have some feedback about this.


The documentation says:

Verify that the kernel parameters shown in the following table are set to values greater than or equal to the minimum value shown. The procedure following the table describes how to verify and set the values.

So you dont have to set the system-wide limit to that value, just at least that (personally I think the system wide limit there would be too low).

Setting the per-user limit to 65536 seems reasonable.

  • if don't see any reason to the system wide limits, if set a limit on oracle user, why oracle says to limit the system wide limit? – c4f4t0r Feb 20 '14 at 18:56
  • The system values if already set need to be at least what is shown. You don't need to add lines, mentioned in the notes as Include lines only for the kernel parameter values that you want to change. – Brian Feb 20 '14 at 19:06
  • @Brian my problem is, many people doesn't read the notes and just copy and paste the above parameters – c4f4t0r Feb 20 '14 at 19:31
  • /people/c4f4t0r/ – Matthew Ife Feb 20 '14 at 19:35

When Oracle verify this values, it's verify with superuser, i had this problem when i installed Oracle 11 in Red Hat 6. I fixed problem when I configured this value in /etc/sysctl.conf

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.