> less /etc/sysctl.conf
# Kernel sysctl configuration file for Red Hat Linux
#
# For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and
# sysctl.conf(5) for more details.
# Controls IP packet forwarding
net.ipv4.ip_forward = 0
# Controls source route verification
net.ipv4.conf.default.rp_filter = 1
# Do not accept source routing
net.ipv4.conf.default.accept_source_route = 0
# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 0
# Controls whether core dumps will append the PID to the core filename
# Useful for debugging multi-threaded applications
kernel.core_uses_pid = 1
# Controls the use of TCP syncookies
net.ipv4.tcp_syncookies = 1
# Controls the maximum size of a message, in bytes
kernel.msgmnb = 65536
# Controls the default maxmimum size of a mesage queue
kernel.msgmax = 65536
# Controls the maximum shared segment size, in bytes
kernel.shmmax = 68719476736
# Controls the maximum number of shared memory segments, in pages
kernel.shmall = 4294967296
### DBA REQUEST FOR ORACLE11 ###
kernel.shmmni = 4096
kernel.sem = 256 32000 100 500
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_max = 4194394
net.core.wmem_max = 1048576
net.core.rmem_default = 262144
net.core.wmem_default = 262144
fs.aio-max-nr = 3145728
但是查看当前的进程数,也才不到10000,离32000还远呢。
查看了一下其他的库的process情况,终于明白了。
原有的5台,有4台process都是5000,一台是3000,一共就是23000
新加的4台,process都是3000,一共就是12000
加起来还真是超了。也难怪新加的第3个数据库实例没有问题,23000+9000=32000,刚好占完了,一点都没剩下。
和部门协调了一下,原有的5台process平时测试用不了那么多,3000多process已经足够了。
就调整了一下,再次重启就没有问题了。
> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Wed Apr 16 15:05:37 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 1.1742E+10 bytes
Fixed Size 2251264 bytes
Variable Size 5234492928 bytes
Database Buffers 6492782592 bytes
Redo Buffers 12193792 bytes