My Oracle Support Banner

Ulimit -a Shows Different Values For Nofile When Executed At Sql Prompt For Oracle User (Doc ID 2354773.1)

Last updated on AUGUST 04, 2018

Applies to:

Linux OS - Version Oracle Linux 6.0 and later
Information in this document applies to any platform.

Symptoms

On an Oracle Linux 6 system, we can see the following is configured:

1. limits.conf

--/etc/security/limits.conf
oracle soft nproc 2047 -->a
oracle hard nproc 16384 -->b
oracle soft nofile 1024 -->c
oracle hard nofile 65536 -->d

 

2. ulimits

[oracle@test ~]$ ulimit -a

open files (-n) 1024 <<-- Output = c
max user processes (-u) 2047 <<-- Output = a

 

3.SQL reported ulimits:

Note: In the below sql prompt "ho ulimit -a" is a command 

 SQL> ho ulimit -a
nofile (-n) 65536 <<--Output ≠ c <hard nofile value is 65536 from limits.conf file but output should reflect soft nofile value>
nproc (-u) 2047 <<-- Output = a

4.  "pmon" process limits

[oracle@test ~]$ ps -ef |grep pmon
10000 13835 1 0 Jan17 ? 00:01:18 ora_pmon_PGWGP0C01
10000 45601 45466 0 08:31 pts/1 00:00:00 grep pmon

[oracle@test ~]$ cat /proc/13835/limits
Limit Soft Limit Hard Limit Units

Max open files 65536 65536 files <<--- Output = d

 

 

            

 There is therefore inconsistency in what is being reported for ulimits by sql vs the system.

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.