Check the kernel parameter of Oracle
--Check the value of the semaphore parameters: semmsl, semmns, semopm, and semmni
/sbin/sysctl -a | grep sem
--Check the value of shared memory segment sizes: shmall, shmmax, and shmmni
/sbin/sysctl -a | grep shm
--Check the maximum number of file handles.
/sbin/sysctl -a | grep file-max
--Check a range of Port Numbers
/sbin/sysctl -a | grep ip_local_port_range
--Check other parameters:
/sbin/sysctl -a | grep rmem_default
/sbin/sysctl -a | grep rmem_max
/sbin/sysctl -a | grep wmem_default
/sbin/sysctl -a | grep wmem_max
/sbin/sysctl -a | grep aio-max-nr
Change the kernel parameter:
1. create or edit the /etc/sysctl.d/97-oracle-database-sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
2. To make effect the changed value run the following command:
/sbin/sysctl --system
3. Verify the value:
/sbin/sysctl -a