Checking Resource Limits for Oracle Software Installation Users

For each installation software owner user account, check the resource limits for installation.

On Oracle Linux systems, Oracle recommends that you install Oracle Database Preinstallation RPMs to meet preinstallation requirements like configuring your operating system to set the resource limits in the limits.conf file. Oracle Database Preinstallation RPM only configures the limits.conf file for the oracle user. If you are implementing Oracle Grid Infrastructure job role separation, then copy the values from the oracle user to the grid user in the limits.conf file.

Use the following ranges as guidelines for resource allocation to Oracle installation owners:

Table 6-1 Installation Owner Resource Limit Recommended Ranges

Resource Shell Limit	Resource	Soft Limit	Hard Limit
Open file descriptors	nofile	at least 1024	at least 65536
Number of processes available to a single user	nproc	at least 2047	at least 16384
Size of the stack segment of the process	stack	at least 10240 KB	at least 10240 KB, and at most 32768 KB
Maximum locked memory limit	memlock	at least 90 percent of the current RAM when HugePages memory is enabled and at least 3145728 KB (3 GB) when HugePages memory is disabled	at least 90 percent of the current RAM when HugePages memory is enabled and at least 3145728 KB (3 GB) when HugePages memory is disabled

To check resource limits:

Log in as an installation owner.
Check the soft and hard limits for the file descriptor setting. Ensure that the result is in the recommended range. For example:
```
$ ulimit -Sn
1024
$ ulimit -Hn
65536
```
Check the soft and hard limits for the number of processes available to a user. Ensure that the result is in the recommended range. For example:
```
$ ulimit -Su
2047
$ ulimit -Hu
16384
```
Check the soft limit for the stack setting. Ensure that the result is in the recommended range. For example:
```
$ ulimit -Ss
10240
$ ulimit -Hs
32768
```
Repeat this procedure for each Oracle software installation owner.

If necessary, update the resource limits in the /etc/security/limits.conf configuration file for the installation owner. However, the configuration file may be distribution specific. Contact your system administrator for distribution specific configuration file information.

Note:

If you make changes to an Oracle installation user account and that user account is logged in, then changes to the limits.conf file do not take effect until you log these users out and log them back in. You must do this before you use these accounts for installation.

Parent topic: Configuring Grid Infrastructure Software Owner User Environments