topic Re: Too many open files in Operating System - HP-UX

Too many open files

Wilfred Chau_1 — Fri, 18 Mar 2005 14:21:48 GMT

Hi all
We have a situation where the oracle alert log said "HP-UX: 24: Too many open files".

But nfile is only 15% utilized and maxfiles is set to 2048.

Do you know of any reason this may happen?

thanks

Re: Too many open files

harry d brown jr — Fri, 18 Mar 2005 14:33:18 GMT

"Too many open files" = maxfiles and maxfiles_lim, not nfile

live free or die
harry d brown jr

Re: Too many open files

rick jones — Sat, 19 Mar 2005 14:45:30 GMT

if you want to see how many files a given process has open there are a number of ways:

1) install and run glance from software.hp.com - it has a show process open files screen
2) install and run lsof pinting it at the process
3) use tusc to trace system calls and look at those taking/giving file descriptors

Re: Too many open files

Tony Scully_2 — Sat, 19 Mar 2005 14:52:07 GMT

Wilfred,

A side issue, but with Oracle it's often worth increasing the number of file locks, nflocks, as well.

As noted above, this is likely to be the number of open files for the oracle user itself.

T

Re: Too many open files

Indira Aramandla — Sun, 20 Mar 2005 20:05:43 GMT

Hi Wilfred,

The error that your are experiencing â HP-UX: 24: Too many open files".

On HP-UX, increase the Unix kernel parameter maxfiles, then regenerate the Unix kernel. This parameter should be set to approximately 60 per instance. It may be set to the default 64. Increasing this parameter allows your shell to open the number of files it needs in order to complete the operation. 64 is not a large enough number to accomplish some tasks with Oracle, and increasing it will not pose an undue burden on the system.

And also increase the UNIX kernel parameters nfile, maxfiles, and nofiles (number of open files) by 50 or 100, then regenerate the UNIX kernel and reboot the machine using the new kernel.

Re: Too many open files

Isralyn Manalac_1 — Sun, 20 Mar 2005 22:04:30 GMT

Hi Wilfred,

You should be looking at maxfiles and maxfiles_lim. Since the alert log was triggered by Oracle, you may want to ask Oracle for their list of recommended kernel parameter values specially for maxfiles and maxfiles_lim.

Good luck!

Regards,

Isralyn