Linux kernel with Oracle

Apr 7 posted in Oracle (RSS), 297 views.

Under the light of oracle installation in linux the whole document is as follows:
1, vi / etc / sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144
So that the effective implementation of this;
/ sbin / sysctl-p
2, vi / etc / security / limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
3, vi / etc / pam.d / login
session required / lib / security / pam_limits.so
session required pam_limits.so
4, vi / etc / profile
if [$ USER = "oracle"]; then
if [$ SHELL = "/ bin / ksh"]; then
ulimit-p 16384
ulimit-n 65536
else
ulimit-u 16384-n 65536
fi
fi

Linux X86-64 operating system, Oracle 10g databases, 8G added by the 16G, to put parameters kernel.shmmax to 17179869184 (16G), we found that as long as the modified parameters sga_max_size and sga_target more than 8G, Oracle will not start at memory not enough, check the shared memory parameters of the other two relevant parameters: kernel.shmall and kernel.shmmni, kernel.shmall control parameter is the shared memory pages, kernel.shmmni control parameter is the total number of shared memory segment, the current parameter value is 4096, large enough, then the problem should be on at kernel.shmall by 8589934592 (8G) divided by the current parameter value 2,097,152, resulting in 4096 on page size is 4K, now to make SGA more than 8G, we must transfer large kernel.shmall parameters to adjust the current value of 2 times (4,194,304), you can successfully set up to 13G of the sga.

kernel.shmmax parameter value must be less than or equal to the value of physical memory, otherwise set up is not in force, unable to create database

Oracle installation usually required before setting the parameters kernel.sem, following a brief introduction to some
sem are the initials of the semaphores, see the current settings
[oracle @ ebsse oracle] $ cat / proc / sys / kernel / sem
250 32000 100 128
Corresponding to four data
SEMMSL SEMMNS SEMOPM SEMMNI
Such as initialization parameters when the oracle DB files larger PROCESSES parameter setting, the need to adjust settings SEMAPHORES
SEMMSL server should be set to various examples of the largest PROCESSES parameter of +10, for example, when the largest PROCESSES parameter for 5000, SEMMSL should be set to 5010.
SEMMNS parameters should be set to SEMMSL * SEMMNI, connect to SEMMSL Example 5010, SEMMNS parameters should be (5010 * 128) = 641280.
SEMOPM parameters SEMMSL parameters should be set up with the same access to the cases should be set to 5010 here