Minimum Parameter Settings for Installation

Use this table to set parameters manually if you cannot use the fixup scripts.

Note:

• Unless otherwise specified, the kernel parameter and shell limit values shown in the following table are minimum values only. For production database systems, Oracle recommends that you tune these values to optimize the performance of the system. See the operating system documentation for more information about tuning kernel parameters.

• The values in this table are minimum values for manual configuration. If you used the Oracle Database Preinstallation RPM to complete your preinstallation configuration tasks, then the RPM configures these kernel parameters for you. The Preinstallation RPM can set higher values for these kernel parameters. Do not reduce a higher or different value configured by the Preinstallation RPM or by your system administrator solely to match the minimum value in this table.

• If the current value for any parameter is greater than the value listed in this table, then the Fixup scripts do not change the value of that parameter.

Table A-1 Minimum Operating System Resource Parameter Settings

Parameter	Value	File
semmsl semmns semopm semmni	250 32000 100 128	/proc/sys/kernel/sem
shmall	Greater than or equal to the value of shmmax, in pages.	/proc/sys/kernel/shmall
shmmax	Half the size of physical memory in bytes See My Oracle Support Note 567506.1 for additional information about configuring shmmax.	/proc/sys/kernel/shmmax
shmmni	4096	/proc/sys/kernel/shmmni
panic_on_oops	1	/proc/sys/kernel/panic_on_oops
file-max	6815744	/proc/sys/fs/file-max
aio-max-nr	1048576 Note: This value limits concurrent outstanding requests and should be set to avoid I/O subsystem failures.	/proc/sys/fs/aio-max-nr
ip_local_port_range	Minimum: 9000 Maximum: 65500	/proc/sys/net/ipv4/ip_local_port_range
rmem_default	262144	/proc/sys/net/core/rmem_default
rmem_max	4194304	/proc/sys/net/core/rmem_max
wmem_default	262144	/proc/sys/net/core/wmem_default
wmem_max	1048576	/proc/sys/net/core/wmem_max