Setting OS ulimit value to max or unlimit on Oracle RAC servers
Issue
- Our DBA's are seeing an error in alert.log file . Oracle support suggested to set the OS ulimit value to unlimited or max for oracle user. Recommenedation from Oracle support is below.
- Does Red Hat agree with this recomendation:
Oracle Support recommenation:
OS setting
1. nproc (-u) 65536 or UNLIMITED (both hard and soft)
2. stack size (kbytes) (-s) 65536 or UNLIMITED (both hard and soft)
3. Change the upper limit at either the OS or at the database level:
Change the page count at the OS level:
$ more /proc/sys/vm/max_map_count
$ sysctl -w vm.max_map_count=200000 (for example)
Environment
- Red Hat Enterprise Linux 5
- Oracle RAC
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
