sitemap

RSS地图

收藏本站

设为首页

Oracle研究中心

当前位置:Oracle研究中心 > 故障案例 >

【案例】Oracle报错Warning: Oracle Instance Running on a System

时间:2016-10-29 17:17   来源:Oracle研究中心   作者:HTZ   点击:

天萃荷净 Oracle研究中心案例分析:运维DBA遇到Warning: Oracle Instance Running on a System with Low Open File Descriptor Limit报错,总结linux solaris aix等系统的解决办法。
数据库启动的时候报下面的错误
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

1,hp_unix平台

Tunable maxfiles
Description Initial (soft) maximum number of file descriptors per process
Module fs
Current Value 16384
Value http://www.oracleplus.netat 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

2,linux平台

/etc/security/limits.conf file:
oracle soft nofile 1024
oracle hard nofile 65536

3,AIX平台

* nofiles – soft file descriptor limit
* nofiles_hard – hard file descriptor limit
通过
chuser nofiles=
chuser hard_nofiles=
也可以通过smit chuser来更改

4,solaris系统

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/2014/08/11/warning-oracle-instance-running-on-a-system-with-low-open-file-descriptor-limit.html | 认真就输

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之【案例】Oracle报错Warning: Oracle Instance Running on a System

本文由大师惜分飞原创分享,网址:http://www.oracleplus.net/arch/1104.html

Oracle研究中心

关键词:

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