This content has been marked as final. Show 5 replies
ef8454 wrote:Google is your friend, but only if you use it
We have Redhat 5.5 on DELL server. Due to more and more databases run on same server sometime processes number read max and cause 'resource temporary unavailable".
I plan to change /etc/security/limits.conf value:
oracle soft nproc 2047 ==> 4096
Do i need reboot to make it effect?
How to test change is effect?
I googled "change /etc/security/limits.conf " and go these right off the top:
limits.conf are readed in login proces, so as EdStevens said you, you needn't reboot the sever. But, you must restart the database.
If you change the limits.conf file, current databases doesn't knows the changes, you need :
-to login with a new oracle session
-check the new limits with ulimit -a+
-If the limits are OK, shtudown the database and restart the database again
The database will start with new limits
Looking at your recent posts and user profile I wonder if you are going to show any feedback or appreciation, which is why I only have a short answer for you:
There are resource hard limits, soft limits and system wide settings. And there is the ulimit command to display and change these settings for the current shell.