# How to increase open files limit for a specific user?

Currently we have below entry in /etc/security/limits.conf

* hard nofile 65000

I want to increase that limit for a specific user called oracle, so if I add a line below like

oracle hard nofile unlimited which one will have precedence?

Also does increasing this specific limit require more resources in the server? I am making this change because the server is reaching current limit 65000 open files. And I am getting too many open files in the system error message when I try to login. An oracle database is hosted on the server. Is it required to bounce the database or reboot the server after making this change?

• I would assume the precedence will be based on the order of the limits in the conf file. So if * is set first, this will be set and then the with oracle will overwrite the setting just for Oracle afterwards. – Raman Sailopal Oct 19 '17 at 12:25

The man page man limits.conf states: