Setting OS ulimit value to max or unlimit on Oracle RAC servers

Solution Verified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.