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, tools, and much more.