I'm trying to increase the hard and soft limits for the oracle user by
specifying them in /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 4096
oracle hard nofile 65536
oracle soft stack 10240
All the limits are being applied correctly except the nofile limits.
If I log in as that user, either with a new session or "su - oracle"
the nofile limit is 1024 and can't be adjusted any higher. However, if I
just "su oracle" from the root user the nofile limits are what is
specified in the file.
From what I can gather I need to have the "session require
pam_limits.so" specified in /etc/pam.d/login but as far as I can tell it
is included via the "session include common-session" line.
Any one else have this problem or know of a solution?