
目前,生产有一套环境,版本:12C,类型:RAC。双节点各自有13000的会话数,并发会话数各在50左右,考虑单节点支撑问题,经过二线专家协助,已做部分参数修改,但是单节点还是无法实现支撑30000的话,达到17000就夯住了,请各位专家再指导一下,还需要考虑哪方面。
1)数据库参数设置
sga_target=380G
processes=36000
sessions=54032
2)系统资源限制
[oracle@ssss scripts]$ ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 4126859
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 65536
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 65536
cpu time (seconds, -t) unlimited
max user processes (-u) 65536
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
3)内核参数设置
cat /etc/sysctl.conf
#ORACLE SETTING
kernel.shmall = 4294967296
kernel.shmmax = 769658139444
kernel.shmmni = 4096
kernel.sem = 40000 40960000 40000 1024
fs.file-max = 6815744
fs.aio-max-nr = 3145728
net.ipv4.ip_local_port_range = 9000 65500
net.ipv4.ipfrag_high_thresh = 41943040
net.ipv4.ipfrag_low_thresh = 40894464
net.ipv4.ipfrag_time = 120
net.ipv4.ipfrag_secret_interval = 600
net.ipv4.ipfrag_max_dist = 1024
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
vm.min_free_kbytes= 1048576
vm.nr_hugepages = 256614
net.ipv4.tcp_synack_retries = 1
net.ipv4.tcp_tw_reuse = 1
net.ipv4.tcp_syncookies = 0
net.ipv4.tcp_max_syn_backlog = 8192
net.core.somaxconn = 65535
net.core.netdev_max_backlog = 8192
2节点stop后,一节点后台报错:
主机系统:
alert日志报错:
监听报错如下: