ORA-27077: too many files open error in Linux system

ORA-27077: too many files open error in Oracle 7 Operating system

Error:
We are getting the following error in Oracle alert log file having Oracle 7 Operating system.

ORA-15025: could not open disk "/dev/mapper/asm06"
ORA-27077: too many files open
2017-12-02T17:12:39.028419-05:00
WARNING: Write Failed. group:2 disk:4 AU:96410 offset:0 size:253952
path:Unknown disk
incarnation:0xf8875997 asynchronous result:'I/O error'
subsys:Unknown library krq:0x7fbc2804b440 bufp:0x7fbc45dd1000 osderr1:0x434c5344 osderr2:0x0
IO elapsed time: 0 usec Time waited on I/O: 0 usec

Other similar error:
ORA-27301: OS failure message: Too many open files in system

Cause
kernel parameter fs.file-max value is set too small.

Solution:
1. Check the value of parameter “fs.file-max” in file etc/sysctl.conf

2. Increase the value of this parameter “fs.file-max”.
Note: it value is calculated based on RAM size

Farmula: 4MB of RAM you need to set 256 open files value.

512 GB of RAM = 512*1024 = 524,288 MB
fs.file-max = (524288/4 ) * 256 = 8589934592
Then you need to set it to 8589934592

3. open the /etc/sysctl file and update the entry of parameter.

fs.file-max = 8589934592

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.