LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Red Hat
User Name
Password
Red Hat This forum is for the discussion of Red Hat Linux.

Notices

Reply
 
LinkBack Search this Thread
Old 08-16-2011, 08:55 AM   #1
unix1adm
Member
 
Registered: Oct 2008
Posts: 624

Rep: Reputation: 30
best way tot set ulimits or orcale to unlimited


We have a test system and our users need oracle to have the following limits.

Ulimit needs to be unlimited for all areas.
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 57344
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 57344
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited


What is the best method for doing this? In AIX we use /etc/security/limits.

I looked at the /etc/security/limits.conf but I am not sure of the syntax for all these fields.

Anyone have a sample oracle limits file I could look at?

I tried google and man pages. Not much luck still looking.

AIX looks like this:

oracle:
fsize = -1
fsize_hard = -1
cpu = -1
data = -1
stack = -1
rss = -1
stack_hard = -1
nofiles = -1

Last edited by unix1adm; 08-16-2011 at 09:17 AM.
 
Old 08-16-2011, 09:37 AM   #2
TB0ne
Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 13,772

Rep: Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346
Quote:
Originally Posted by unix1adm View Post
We have a test system and our users need oracle to have the following limits.

What is the best method for doing this? In AIX we use /etc/security/limits. I looked at the /etc/security/limits.conf but I am not sure of the syntax for all these fields. Anyone have a sample oracle limits file I could look at?

I tried google and man pages. Not much luck still looking.
Huh. I get 562K hits from Google on "linux ulimit". What version/distro of Linux are you using?
http://www.cyberciti.biz/faq/linux-i...of-open-files/

Usually this is done via /etc/sysctl.conf, or you can set them per-user with the ulimit command in a .bashrc/.profile file, if you don't want to set them interactively. This is also covered well in the Oracle installation documentation for Linux.
 
Old 08-17-2011, 04:48 AM   #3
unix1adm
Member
 
Registered: Oct 2008
Posts: 624

Original Poster
Rep: Reputation: 30
Well I am not the Oracle person and I dont know what documentation you refer to.

But I did figure it out.
I edited the /etc/security/limits.conf file and added the following lines:

* core 0
* data unlimited
* priority 0
* fsize unlimited
* soft sigpending 57344
* hard sigpending 57444
* memlock unlimited
* nofile 1024
* msgqueue 819200
* rtprio 0
* stack 10240
* cpu unlimited
* soft nproc 57344
* hard nproc 57444
* locks unlimited


I then exited and re-login from my terminal for the change to take effect.

Here, the wildcard *, for default entry. You can use username or groupname as per your requirement.

I will replace the wildcard with oracle id to narrow it down to just this user.

I did read some documents that said you can use the .bashrc the /etc/security/limits.conf. Not sure why you would not use the /etc/security/limits.conf file and use the /etc/sysctl.con or the .profile.

I was more looking for the syntax so I hope this help someone else if they need it.

I guess there is more than one file to add it to. In AIX there is only one.
 
Old 08-17-2011, 10:40 AM   #4
TB0ne
Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 13,772

Rep: Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346
Quote:
Originally Posted by unix1adm View Post
Well I am not the Oracle person and I dont know what documentation you refer to.
But I did figure it out. I edited the /etc/security/limits.conf file and added the following lines:

I then exited and re-login from my terminal for the change to take effect. Here, the wildcard *, for default entry. You can use username or groupname as per your requirement. I will replace the wildcard with oracle id to narrow it down to just this user.

I did read some documents that said you can use the .bashrc the /etc/security/limits.conf. Not sure why you would not use the /etc/security/limits.conf file and use the /etc/sysctl.con or the .profile. I was more looking for the syntax so I hope this help someone else if they need it.
I guess there is more than one file to add it to. In AIX there is only one.
You only have to edit one file in Linux too, and the documentation I'm referring to is the installation documentation that comes on the Oracle installation media, or can be found on Oracle's knowledgebase.

You still don't say what version/distro of Linux you're using, or what version of Oracle you're installing, so it's hard to be specific. The .bashrc/.profile entries are again, used for interactive setting of those limits, just as you can set them that way in AIX.
http://www.oracle.com/technetwork/articles/index.html
http://www.puschitz.com/InstallingOracle9i.shtml
http://www.puschitz.com/InstallingOracle10g.shtml

The installation docs that come with the Oracle installation media, are quite detailed, and tell you exactly which files to edit, and why.
 
Old 08-17-2011, 04:59 PM   #5
unix1adm
Member
 
Registered: Oct 2008
Posts: 624

Original Poster
Rep: Reputation: 30
I am using RHEL 5.7

As for oracle No clue. I am not the dba doing the install. He did not provide me any info. Just that he needed the user oracle to have unlimited. We do this all the time in AIX so it was not a big deal to me. I know they need it for Oracle.

I don't have access to the Oracle media etc. Separate department. I am just OS and HDW so I could not answer your questions. He was out today so I could not get the info sorry about that.

Thank you for the links I will review them. But as of now the solution i found seems to be working fine. It seems to be an acceptable solution although lengthy.
 
  


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
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Installing orcale 10g xe on Linux mint 10 linuxwhacko Linux Mint 7 03-11-2011 06:19 AM
Setting ulimits rnash AIX 2 08-23-2010 02:22 AM
how to set ulimits for a specific user with no login shell polemon Linux - General 1 10-11-2007 03:54 AM
File Descriptors and Ulimits ALInux Linux - Software 1 07-25-2007 06:46 AM
how to set /tmp to unlimited size bcos it's blocked to 256MB msalimane Mandriva 4 01-30-2005 03:39 AM


All times are GMT -5. The time now is 05:24 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration