Installation guide

oracle hard nofile 131072
These are the recommended values used in Oracle validated configurations. The "soft limit" in the first line de-
fines the number of file handles or open files that the Oracle user will have after login. You can set the "soft"
and "hard" limits higher if necessary.
NOTE:
It is not recommend to set the "hard" limit for nofile for the oracle user equal to
/proc/sys/fs/file-max. If you do that and the user uses all the file handles, then the entire system will
run out of file handles. This could mean that you will not be able to initiate new logins any more since the sys-
tem will not be able to open any PAM modules that are required for the login process.
To apply these limits you also need to ensure that pam_limits is configured in the /etc/pam.d/system-
auth file, or in /etc/pam.d/sshd for ssh, /etc/pam.d/su for su, or /etc/pam.d/login for local
logins and telnet if you do not want to enable it for all login methods. Here are examples of the two session en-
tries in the /etc/pam.d/system-auth file:
session required pam_limits.so
session required pam_unix.so
Limiting Maximum Number of Processes for the Oracle User
To see the current limit of the maximum number of processes for the oracle user, run:
$ su - oracle
$ ulimit -u
Note the ulimit options are different for other shells.
To change the "soft" and "hard" limits for the maximum number of processes for the oracle user, add the fol-
lowing lines to the /etc/security/limits.conf file:
oracle soft nproc 131072
oracle hard nproc 131072
These are the recommended values for Oracle validated configurations.
Increasing Maximum Size of Per-Processes Locked Memory
To use hugepages you must increase the default maximum size of the per-process locked memory. To in-
crease the per-process max locked memory limit, add the following lines to the /etc/security/limits.-
conf file:
oracle soft memlock 3145728
oracle hard memlock 3145728
The size is in KB and should correspond to the size of hugepages allocated to Oracle. In the example above, the
memlock value allows to use 1536 huge pages ( 3145728 KB / (1024 KB * 2) = 1536 huge pages).
30 | www.redhat.com