CentOS - Mar 2013 - change /etc/security/limits.conf need reboot or not?

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 at 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 at centos.org
> http://lists.centos.org/mailman/listinfo/centos
>