oracle unable to open file,ORA-27041:unable to open file

ORA-01116: error in opening database file 4

ORA-01110: data file 4: '/applis/oracle/prd/data_top/system04.dbf'

ORA-27041:unable to open file

Linux Error:24, Too many open files

2009-08-06日美高系统出错

APP-FND-01564:SUBMIT:others 中出现 oracle 错误 -1116

原因:由于ORA-01116:error in opening database file 398

ORA-01110:data file 398:'/d05/proddata/arch/a_archive01.dbf'

ORA-27041:unable to open file

Linux Error:24:Too many open files

Additional information:3,SUBMIT:others 失败.

出货错误时执行的 SQL语名为:&SQLSTMP(是从文件&ERRFILE执行该语句的).

1.更改系统 /etc/security/limits.conf 设置

* hard nofile 65535

* soft nofile 4096 把此文件数加大

2.然后重启系统生效

3.查看 ulimit -a or -n

4.可以用此命令立即生效 sysctl -p /etc/sysctl.conf

老大说以后改系统设置最好在数据库停了后再改，以免造成大的问题!!!!!!!!!!!!!![@more@]