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

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content