Modifying limits.conf & pam.d

luft · September 30, 2009, 3:57pm

Hello all,

I'm running Oracle 10.2 on RHEL5. Current value of ulimit -n is set to a low value of 1024. I need to increase it to 65536 using the following procedure.

cat >> /etc/security/limits.conf <<EOF
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF

cat >> /etc/pam.d/login <<EOF
session required /lib/security/pam_limits.so
EOF

Question: will the new values take effect as soon as I complete the above 2 steps or should I run something manually so that these new values take effect?

Thanks for your time.

fpmurphy · October 3, 2009, 9:46am

No. You have to restart all Oracle processes.

jim_mcnamara · October 3, 2009, 9:52am

Shut down all of the oracle instances running, then restart them.

luft · October 5, 2009, 9:51am

Thanks Murphy & Jim for your responses. I'll restart the Oracle instance as you suggested.