We have CEntos 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?
Thanks.
mcclnx mcc wrote:
We have CEntos 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?
Google for tuning linux for oracle. Here's a good tutorial with recommendations.
http://labite.wordpress.com/2012/08/31/tuning-linux-server-for-oracle-database/
You should really talk to Oracle, or Dell, for that matter, about performance tuning for Oracle. If you're still under warranty, They'll give you good numbers.
mark
I rmeember you can just exist the shell and log on again to apply the changes. Not really a reboot.
You can check it with ulimit -a for the list items of the changes.
------------ Banyan He Blog: http://www.rootong.com Email: banyan@rootong.com
On 3/21/2013 2:52 AM, mcclnx mcc wrote:
We have CEntos 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?
Thanks. _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
I rmeember you can just exist the shell and log on again to apply the changes. Not really a reboot.
You can check it with ulimit -a for the list items of the changes.
Yes logout and login again helps - but only your shell environment. Every process/daemon/database has its own (unchanged) environment. So you have to restart also the database processes, to force a new setup for the environment variables. If you want to be really save, a reboot will be the best.
Banyan He Blog: http://www.rootong.com Email: banyan@rootong.com
On 3/21/2013 2:52 AM, mcclnx mcc wrote:
We have CEntos 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?
Thanks.
-
Banyan He -
m.roth＠5-cent.us -
mcclnx mcc -
Woehrle Hartmut SBB CFF FFS (Extern)