LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 08-11-2014, 11:06 PM   #1
thiyagusham
Member
 
Registered: Apr 2012
Posts: 213

Rep: Reputation: Disabled
limits.conf purpose for oracle 10g installation on linux


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 ?
  1. why nproc having 2047 to 16384 ?
  2. what is soft and hard here ?
  3. what means open file descriptors
?

Thanks ..
 
Old 08-12-2014, 12:32 AM   #2
AnanthaP
Member
 
Registered: Jul 2004
Location: Chennai, India
Distribution: UBUNTU 5.10 since Jul-18,2006 on Intel 820 DC
Posts: 805

Rep: Reputation: 186Reputation: 186
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
 
1 members found this post helpful.
Old 08-12-2014, 04:05 PM   #3
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 17,926

Rep: Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690
Quote:
Originally Posted by thiyagusham View Post
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 ?
  1. why nproc having 2047 to 16384 ?
  2. what is soft and hard here ?
  3. 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
 
Old 08-12-2014, 04:43 PM   #4
Habitual
LQ Addict
 
Registered: Jan 2011
Location: Youngstown, Ohio
Distribution: LM17.1/Xfce4.11.8
Posts: 7,163
Blog Entries: 10

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


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Linux rpm pre-installation issue for oracle 10g SridharT Linux - Newbie 5 05-07-2013 09:12 AM
to increase the /u01 size while installation oracle 10g R2 on linux 5.1 irfankundi786 Linux - Newbie 9 07-29-2012 03:49 PM
[SOLVED] oracle client 10g installation on LINUX pallavibhat89 Linux - Newbie 1 01-12-2011 01:51 PM


All times are GMT -5. The time now is 07:02 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration