[olug] Ulimit defaults

Kenton Brede xyf at nixnotes.org
Tue Sep 16 15:00:08 UTC 2003


On Tue, Sep 16, 2003 at 08:48:28AM -0500, Nick Walter wrote:
> I'm trying to configure a RH 2.1 AS server for a database application. 
> Since this is going to be a very large database I'm running into
> problems with the ulimit default for number of open files allowed in a
> single session.  
> 
> As the database user, I can type ulimit -Hn and ulimit -Sn and find out
> I have a 1024 open file limit.  That is way too small for my needs.  I'm
> having a devil of a time figuring out a way to permanently raise that
> limit.  I can manually set higher limits as root user and then su to the
> database user and have higher limits, but that doesn't work long term as
> this database software needs to start automatically at boot without
> human intervention.  
> 
> I've tried mucking with /etc/security/limits.conf and that doesn't seem
> to have any effect at all.  Anyone know of a config file or perhaps init
> script modification I can make to set some very high hard and soft
> ulimit numbers for one specific user?
> 

Did a quick search in redhat docs at their web site the following URL might 
give you a start, before you get some expert help -

http://www.redhat.com/docs/manuals/database/RHDB-2.1-Manual/admin_user/kernel-resources.html

You mean your not going to use that A.S. tech support you payed so dearly
for? ;)
Kent

-- 
"I am always doing that which I can not do, 
   in order that I may learn how to do it." --Pablo Picasso



More information about the OLUG mailing list