当前位置: 首页 > ORA, OS > 正文

Warning: Oracle Instance Running on a System with Low Open File Descriptor Limit

数据库启动的时候报下面的错误

Sat Aug  9 00:46:05 2014
WARNING:Oracle instance running on a system with low open file descriptor
        limit. Tune your system to increase this limit to avoid
        severe performance degradation.

从报错日志中可以看到文件文件描述符太少,增加文件描述符,问题就可以解决,需要主机工程师,修改主机参数来解决,下面常见系统的文件描述符参数说明

ORACLE数据库系统,文件描述符的计算

The correct formula for calculating the maximum open file limit (at least for Solaris, but most likely for all Unix platforms) is:

2 * db_files + max_open_controlfiles (8) + max_open_logfiles (10) + files_reserved_by_generic_code (32) + files_reserved_by_port_specific_code (32)

so the simplified formula is:

2 * db_files + 82

1hp_unix平台

Tunable             maxfiles

Description         Initial (soft) maximum number of file descriptors per process

Module              fs

Current Value       16384

Value at Next Boot  16384

Value at Last Boot  16384

Default Value       2048 (automatic)

Constraints         maxfiles >= 32

                    maxfiles <= 1048576

                    maxfiles <= maxfiles_lim

Can Change          At Next Boot Only

 

Tunable             maxfiles_lim

Description         Hard maximum number of file descriptors per process

Module              fs

Current Value       16384

Value at Next Boot  16384

Value at Last Boot  16384

Default Value       4096

Constraints         maxfiles_lim >= 32

                    maxfiles_lim <= 1048576

                    maxfiles_lim >= maxfiles

Can Change          Immediately or at Next Boot

2linux平台

/etc/security/limits.conf file:

oracle soft nofile 1024

oracle hard nofile 65536

3AIX平台

* nofiles    – soft file descriptor limit

* nofiles_hard – hard file descriptor limit

通过

chuser nofiles= 

chuser hard_nofiles= 

也可以通过smit chuser来更改

4solaris系统

solaris使用了project来管理

process.max-file-descriptor

id -p oracle

projmod -a -K "process.max-file-descriptor=(basic,65537,deny)"  projectname

projmod -a -K "process.max-file-descriptor=(priv,65538,deny)" projectname

这些数据都是写到/etc/project中的

本文固定链接: http://www.htz.pw/?p=635 | 认真就输

该日志由 huangtingzhong 于2014年08月11日发表在 ORA, OS 分类下, 你可以发表评论,并在保留原文地址及作者的情况下引用到你的网站或博客。
原创文章转载请注明: Warning: Oracle Instance Running on a System with Low Open File Descriptor Limit | 认真就输
关键字: