遭遇HP-UX Error: 23: File table overflow

今天经分数据库出现以下错误：

Fri Feb 25 15:00:03 2011
Errors in file /array_dssora/oracle/app/oracle/product/9.2.0.1/admin/jxdss/bdump/jxdss_j003_7452.trc:
ORA-12012: 自动执行作业 142 出错
ORA-00210: 无法打开指定的控制文件
ORA-00202: 控制文件: '/dev/dssvg01/rdss01_control2'
ORA-27041: 无法打开文件
HP-UX Error: 23: File table overflow
Additional information: 3
ORA-06512: 在"PERFSTAT.STATSPACK", line 2731
ORA-06512: 在line 1
Fri Feb 25 15:00:03 2011
Errors in file /array_dssora/oracle/app/oracle/product/9.2.0.1/admin/jxdss/bdump/jxdss_j003_7452.trc:
ORA-00604: 递归 SQL 层 1 出现错误
ORA-01116: 打开数据库文件1时出错
ORA-01110: 数据文件 1: '/dev/dssvg01/rdss01_system'
ORA-27041: 无法打开文件
HP-UX Error: 23: File table overflow
Additional information: 3
ORA-12012: 自动执行作业 142 出错
ORA-00210: 无法打开指定的控制文件
ORA-00202: 控制文件: '/dev/dssvg01/rdss01_control2'
ORA-27041: 无法打开文件
HP-UX Error: 23: File table overflow
Additional information: 3
ORA-06512: 在"PERFSTAT.STATSPACK", line 2731
ORA-06512: 在line 1
Fri Feb 25 15:05:01 2011
Thread 1 advanced to log sequence 226415
  Current log# 7 seq# 226415 mem# 0: /dev/dssvg13/rdss13_d4_index187
  Current log# 7 seq# 226415 mem# 1: /dev/dssvg13/rdss13_d4_index188
Fri Feb 25 16:00:00 2011
Errors in file /array_dssora/oracle/app/oracle/product/9.2.0.1/admin/jxdss/udump/jxdss_ora_8941.trc:
ORA-00603: ORACLE 服务器会话因致命错误而终止
ORA-01116: 打开数据库文件826时出错
ORA-01110: 数据文件 826: '/dev/dssvg13/rdss13_d4_index021'
ORA-27041: 无法打开文件
HP-UX Error: 23: File table overflow
Additional information: 3
ORA-01116: 打开数据库文件826时出错
ORA-01110: 数据文件 826: '/dev/dssvg13/rdss13_d4_index021'
ORA-27041: 无法打开文件
HP-UX Error: 23: File table overflow

 

 

在网上查询

HP-UX Error: 23: File table overflow 是操作系统打开文件受限制

HP-UX Error: 23: File table overflow

解决办法就是加大操作系统的参数
Additional information: 3
解决这个问题的方法是增大相关的核心参数：（建议以下的配置）
nproc 4096 Max Number of Processes
nfile 63488 Max Number of Open Files
nflocks 4096 Max Number of File Locks