System kernel parameters to be configured for Oracle Installation

When installing the Oracle database, Oralce needs to set the following system kernel parameters, which are described below (the parameter values are kept in the etcsysctl file ).

When installing the Oracle database, Oralce needs to set the following system kernel parameters, which are described below (the parameter values are kept in the file/etc/sysctl

When installing the Oracle database, you need to set the following system kernel parameters for Oralce propulsion. These parameters are briefly described as follows (the parameter values are kept in the file/etc/sysctl. conf)

Kernel. shmmax: the maximum size (in bytes) of the shared memory segment ).
Kernel. shmmni: Maximum number of shared memory segments in the system.
Kernel. shmall: Total shared memory, in pages.
Fs. file-max: number of file handles, indicating the number of files that can be opened in Linux.
Net. ipv4.ip _ local_port_range: IPv4 port range that can be used by the application.

Kernel. shmmax
Oracle SGA is composed of shared memory. If the SHMMAX setting is incorrect, it may limit the size of the SGA, and insufficient SHMMAX settings may cause the following problems: ORA-27123: unable to attach to shared memory segment, if this parameter is smaller than the Oracle SGA setting, SGA will be allocated with multiple shared memory segments. This may be a performance burden in a busy system and cause system problems. Oracle recommends that Kernel. shmmax be better than sga to make the oracle shared memory SGA in a shared memory segment to improve performance.

Kernel. shmall
The total size of the system shared memory, in pages. A 32-bit Linux system with 8 GB memory can be configured with kernel. shmall = 2097152, that is: 2097152*4 k/1024/1024 = 8G, that is, a total of 8 GB of available shared memory, here 4 k is the size of a 32-bit operating system page, that is, 4096 bytes.

Kernel. shmmni
The maximum number of shared memory segments in the system. The default value is 4096, which does not need to be modified. The Kernel. shmmin parameter is also available in sun OS, indicating the minimum size of the shared memory segment.

You can modify/proc/sys/kernel/shmmax to configure the preceding parameters, for example:
# Echo 1073741824>/proc/sys/kernel/shmmax, but it will be reset after the system is restarted. To make the modification take effect permanently, you need to go to/etc/sysctl. add the Kernel in the conf file. shmmax = 1073741824, where 1G is set.

-- The End --