limits.conf purpose for oracle 10g installation on linux

thiyagusham · 08-11-2014, 10:06 PM

Hi All;

what is file

PHP Code:



Path should be /etc/security/limits.conf 
----------------------------------------- 
 
 
    *               soft    nproc   2047 
    *               hard    nproc   16384 
    *               soft    nofile  1024 
    *               hard    nofile  65536

nproc means , maximum number of open file descriptors;
nofile means , max number of process avail to oracle user.

could anyone expalin clearly ?

why nproc having 2047 to 16384 ?
what is soft and hard here ?
what means open file descriptors

?

Thanks ..

AnanthaP · 08-11-2014, 11:32 PM

1024, 2047, 16384 and 65536 are easily recognizable as binary value of 2^10, 2^11-1, 2^14 and 2^16 respectively.

As you can infer, Oracle probably uses just one 16 bit word for each of these parameters.

Soft probably means limit in the SGID (or whatever) and hard probably means in the cache/ram.
This last question is pure Oracle related and better posted in an Oracle forum.

Open file descriptors is the number of files that Oracle can keep open at any given point in time.

OK

TB0ne · 08-12-2014, 03:05 PM

Quote:

Originally Posted by thiyagusham

Hi All;
what is file

PHP Code:



Path should be /etc/security/limits.conf 
----------------------------------------- 
    *               soft    nproc   2047 
    *               hard    nproc   16384 
    *               soft    nofile  1024 
    *               hard    nofile  65536

nproc means , maximum number of open file descriptors;
nofile means , max number of process avail to oracle user.

could anyone expalin clearly ?

why nproc having 2047 to 16384 ?
what is soft and hard here ?
what means open file descriptors

?

The man page on limits.conf can...did you try to read it, or look it up on Google???
http://ss64.com/bash/limits.conf.html

And since you've been working with Oracle for years now, you will STILL be aware that Oracle 10g is OLD, and that you are paying for support with Oracle, and can call them for explanations. Perhaps even look things up in THEIR documentation???? Limits.conf is one of the pre-installation tasks you have to accomplish...an 'experienced DBA' would be very familiar with this:
http://docs.oracle.com/cd/B19306_01/...re_install.htm

Habitual · 08-12-2014, 03:43 PM

See also (and bookmark) http://www.puschitz.com/TuningLinuxForOracle.shtml