OEL7-sysctl-baseline

#---------------------------------------------20250320 xuwanxin
# Oracle DB 11g Cconfiguration Parameter
kernel.sysrq = 1
net.ipv6.conf.all.disable_ipv6 = 1
net.ipv6.conf.default.disable_ipv6 = 1
kernel.pid_max = 524288
fs.file-max = 8388608
kernel.sem = 500 256000 250 8192
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
kernel.msgmax = 8192
kernel.msgmni = 2878
kernel.msgmnb = 65535
net.core.rmem_default = 4194304
net.core.rmem_max = 16777216
net.core.wmem_default = 4194304
net.core.wmem_max = 16777216
net.ipv4.tcp_rmem = 4096 87380 16777216
net.ipv4.tcp_wmem = 4096 65536 16777216
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 4194304
net.ipv4.ip_local_port_range = 9000 65500
net.ipv4.conf.all.accept_redirects = 0
net.ipv6.conf.all.disable_ipv6 = 1
net.ipv6.conf.default.disable_ipv6 = 1
net.ipv4.tcp_max_syn_backlog = 8192
net.ipv4.tcp_keepalive_intvl = 30
net.ipv4.tcp_fin_timeout = 30
net.ipv4.tcp_retries2 = 5
net.ipv4.tcp_keepalive_probes = 3
net.ipv4.tcp_syncookies = 1
net.ipv4.tcp_tw_reuse = 1
#net.ipv4.tcp_tw_recycle = 1
net.core.netdev_max_backlog = 8192
net.core.somaxconn = 4096
net.ipv4.tcp_keepalive_time = 1800
vm.min_free_kbytes = 524288
vm.dirty_ratio = 20
vm.dirty_background_ratio = 3
vm.dirty_writeback_centisecs = 100
vm.dirty_expire_centisecs = 500
net.ipv4.ipfrag_time = 120
net.ipv4.ipfrag_low_thresh = 4194304
net.ipv4.ipfrag_high_thresh = 40894464
net.ipv4.ipfrag_max_dist = 1024
vm.nr_hugepages = 30976 #60G
vm.hugetlb_shm_group = 54321
vm.swappiness = 5
#---------------------------------------------20240520 xuwanxin
# Oracle DB 19c Cconfiguration Parameter
kernel.sysrq = 1
net.ipv6.conf.all.disable_ipv6 = 1
net.ipv6.conf.default.disable_ipv6 = 1
kernel.pid_max = 524288
fs.file-max = 8388608
kernel.sem = 500 256000 250 8192
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
kernel.msgmax = 8192
kernel.msgmni = 2878
kernel.msgmnb = 65535
net.core.rmem_default = 4194304
net.core.rmem_max = 16777216
net.core.wmem_default = 4194304
net.core.wmem_max = 16777216
net.ipv4.tcp_rmem = 4096 87380 16777216
net.ipv4.tcp_wmem = 4096 65536 16777216
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 4194304
net.ipv4.ip_local_port_range = 9000 65500
net.ipv4.conf.all.accept_redirects = 0
net.ipv6.conf.all.disable_ipv6 = 1
net.ipv6.conf.default.disable_ipv6 = 1
net.ipv4.tcp_max_syn_backlog = 8192
net.ipv4.tcp_keepalive_intvl = 30
net.ipv4.tcp_fin_timeout = 30
net.ipv4.tcp_retries2 = 5
net.ipv4.tcp_keepalive_probes = 3
net.ipv4.tcp_syncookies = 1
net.ipv4.tcp_tw_reuse = 1
#net.ipv4.tcp_tw_recycle = 1
net.core.netdev_max_backlog = 8192
net.core.somaxconn = 4096
net.ipv4.tcp_keepalive_time = 1800
vm.min_free_kbytes = 524288
vm.dirty_ratio = 20
vm.dirty_background_ratio = 3
vm.dirty_writeback_centisecs = 100
vm.dirty_expire_centisecs = 500
net.ipv4.ipfrag_time = 120
net.ipv4.ipfrag_low_thresh = 4194304
net.ipv4.ipfrag_high_thresh = 40894464
net.ipv4.ipfrag_max_dist = 1024
vm.nr_hugepages = 30976 #60G
vm.hugetlb_shm_group = 54321
vm.swappiness = 5

#---------------------------------------------20230804 xuwanxin
# Oracle DB 19c Cconfiguration Parameter
net.ipv4.conf.all.accept_redirects=0
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.shmmni = 4096
kernel.sem = 250 32000 100 200
fs.file-max=8388608
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_max=4194304
net.core.rmem_default=4194304
fs.aio-max-nr=4194304
net.core.wmem_max=4194304
net.core.wmem_default=262144
net.ipv4.tcp_max_syn_backlog=8196
net.core.netdev_max_backlog=8096
net.ipv4.tcp_keepalive_intvl=30
net.ipv4.tcp_fin_timeout=30
net.ipv4.tcp_retries2=5
net.ipv4.tcp_keepalive_probes=3
net.ipv4.tcp_tw_reuse=1
net.core.somaxconn=4096
net.ipv4.tcp_keepalive_time=1800
vm.min_free_kbytes = 524288
vm.dirty_ratio=20
vm.dirty_background_ratio=3
vm.dirty_writeback_centisecs=100
vm.dirty_expire_centisecs=500
net.ipv4.ipfrag_time = 120
net.ipv4.ipfrag_low_thresh = 4194304
net.ipv4.ipfrag_high_thresh = 40894464
net.ipv4.ipfrag_max_dist = 1024
kernel.panic_on_oops=1 
net.ipv4.conf.all.rp_filter=0
vm.nr_hugepages = 107776
vm.hugetlb_shm_group = 54321
vm.swappiness = 0

---------------------------------------------20230712 xuwanxin
# Oracle DB 19c Cconfiguration Parameter
net.ipv4.conf.all.accept_redirects=0
kernel.shmall = 52428800 #需改成 kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.shmmni = 4096
kernel.sem = 250 32000 100 200
fs.file-max=8388608
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_max=4194304
net.core.rmem_default=4194304
fs.aio-max-nr=4194304
net.core.wmem_max=4194304
net.core.wmem_default=262144
net.ipv4.tcp_max_syn_backlog=8196
net.core.netdev_max_backlog=8096
net.ipv4.tcp_keepalive_intvl=30
net.ipv4.tcp_fin_timeout=30
net.ipv4.tcp_retries2=5
net.ipv4.tcp_keepalive_probes=3
net.ipv4.tcp_tw_reuse=1
net.core.somaxconn=4096
net.ipv4.tcp_keepalive_time=1800
vm.min_free_kbytes = 524288
vm.dirty_ratio=20
vm.dirty_background_ratio=3
vm.dirty_writeback_centisecs=100
vm.dirty_expire_centisecs=500
net.ipv4.ipfrag_time = 120
net.ipv4.ipfrag_low_thresh = 4194304
net.ipv4.ipfrag_high_thresh = 40894464
net.ipv4.ipfrag_max_dist = 1024
kernel.panic_on_oops=1 
net.ipv4.conf.all.rp_filter=0
vm.nr_hugepages = 3328
vm.hugetlb_shm_group = 54321

kernel.pid_max = 524288
fs.file-max = 6815744
fs.aio-max-nr = 1048576
kernel.sem = 500 256000 250 8192
net.ipv4.ip_local_port_range = 9000 65000
net.ipv4.tcp_syncookies = 1
net.ipv4.tcp_tw_reuse = 1
#net.ipv4.tcp_tw_recycle = 1
net.ipv4.tcp_fin_timeout = 30
net.ipv4.tcp_keepalive_time = 1800
net.ipv4.tcp_retries2 = 5
net.core.rmem_default = 262144
net.core.rmem_max = 16777216
net.core.wmem_default = 262144
net.core.wmem_max = 16777216
net.ipv4.tcp_rmem = 4096 87380 16777216
net.ipv4.tcp_wmem = 4096 65536 16777216
net.ipv4.tcp_max_syn_backlog = 8192
net.core.somaxconn = 4096
net.core.netdev_max_backlog = 3000
vm.swappiness = 0