Home > Database, ESX, ESXi, Linux, Oracle, SLES, VMware > Oracle 10g RAC on ESXi3 using SLES9 SP5 – Part 6

Oracle 10g RAC on ESXi3 using SLES9 SP5 – Part 6

February 14th, 2009

Linux OS Parameters

Here is the list of the required parameters for clusterware and oracle database 10g

Parameter Value File
semmsl semmns semopm semmni 25 032 000 100 128 /proc/sys/kernel/sem
shmmax The minimum of the following (4 GB – 1 byte), or half the size of physical memory (in bytes), whichever is lower. /proc/sys/kernel/shmmax
shmmni 4096 /proc/sys/kernel/shmmni
shmall 2097152 /proc/sys/kernel/shmall
file-max 65536 /proc/sys/fs/file-max
ip_local_port_range Minimum: 1024 Maximum: 65000 /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 4194304 /proc/sys/net/core/wmem_max

In order to check the values in your system use the sysctl command.
You will probably get the following results from the default kernel configuration:

rac01:~ # sysctl -a | grep -i sem
kernel.sem = 250 32000 32 128

rac01:~ # sysctl -a | grep shm
kernel.shm-use-hugepages = 0
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.shmmax = 33554432

rac01:~ # sysctl -a | grep -i port_range
net.ipv4.ip_local_port_range = 32768 61000

rac01:~ # sysctl -a | grep core |grep mem
net.core.optmem_max = 20480
net.core.rmem_default = 135168
net.core.wmem_default = 135168
net.core.rmem_max = 131071
net.core.wmem_max = 131071

To adjust these settings permanently I will edit the /etc/sysconfig/sysctl file as follows:

#KERNEL PARAMENTERS FOR ORACLE RAC

kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.shmmax = 2147483648

fs.file-max = 65536

net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 4194304

net.ipv4.ip_local_port_range = 1024 65000

Don’t forget to turn on your boot.sysctl!!!

#chkconfig boot.sysctl on

Test with a reboot to make sure that the kernel parameters are correctly setup.

Next in Part 7 are the RAW Partitions.

Comments are closed.