又出現一個錯誤:

出現錯誤的時候,DB自動shutdown 了.

ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/oradata/oradata2/efa/redo/Log2.ora'
ORA-27041: unable to open file
Linux Error: 23: Too many open files in system
Additional information: 2
error 313 detected in background process
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/oradata/oradata2/efa/redo/Log2.ora'
ORA-27041: unable to open file
Linux Error: 23: Too many open files in system
Additional information: 2


OS Version:
[root@cimfa501 bdump]# uname -a
Linux cimfa501 2.4.9-e.34smp #1 SMP Wed Jan 19 23:02:38 CST 2005 i686 unknown

Oracle Version : 8.1.7.4

那是不是要調大 max-file的值. 現在是8192 .


echo "xxxxxxx" >/proc/sys/fs/file-max

you don't have to reboot box.

[root@rhel-vm1 root]# ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) 4
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 1600
virtual memory (kbytes, -v) unlimited
[root@rhel-vm1 root]# ulimit -n 2048
[root@rhel-vm1 root]# ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) 4
max memory size (kbytes, -m) unlimited
open files (-n) 2048
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 1600
virtual memory (kbytes, -v) unlimited


检查LINUX的内核参数设置的时候正确

Linux有最大打开文件数的限制.发生这个原因是当前这台机器上打开的文件数已经达到了该限制(Unix下文件,Socket,pipe都包括在这个限制中)