Check and change the kernel parameter of Oracle in Linux platform

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.