数据库启动的时候报下面的错误
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 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 |
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中的 |
Warning: Oracle Instance Running on a System with Low Open File Descriptor Limit：等您坐沙发呢！