File table overflow

[Walker_3]

Hi All,
I have rp4440 server with oracle application installed. I am facing the error: “HP-UX Error: 23: File table overflow” due to some Kernel parameters like maxusers, nproc, nfile etc. This is my opinion but I want to confirm on it. Please suggest me which Kernel parameters should be modified to which value to get rid of this error.

Regards,
Mostafa

[Joseph Loo]

hi mostafa,

looks like nfile need to be increase.

regards.

[RAC_1]

wtach what exactly is causing the problem.
glance -t
sar -v 1 3

Is nfile limit getting hit??, If yes increase it and you shold be fine.

[Mugilvannan]

File Table Overflow is due to insufficient 'nfile' kernel parameter. Check it's usage by running 'sar -v 2 20' and see the file-sz column. The ratio shouldn't be near 1. If so, then you will need to increase the 'nfile' value.

Use SAM to increase it. You can wipe out the formula and hardcode the value. Increase it by like 50% and see if it is helpful. Also it is a good idea to set nflocks value equal to nfile value.

[Arunvijai_4]

Can you check these threads,

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=665998
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=750342

-Arun

[Muthukumar_5]

It is frequent problem that you have to tune nfile limit.

Use kmtune utility / sam to do this.

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=691312

hth.

[Muthukumar_5]

HP tuning guide.

http://docs.hp.com/en/1219/tuningwp.html

# kmtune -q nfile -l

You have to tune relative, NPROC, MAXUSERS, NPTY, NSTRPTY and NSTRTEL parameters.

hth.

[Arunvijai_4]

http://docs.hp.com/en/5991-0710/ch04s01.html
[Optimizing the Operating Environment (Kernel Tuning)]

-Arun

[Walker_3]

Hi Joseph,

Could you please tell me the exact increase value of nfile?

Regards,
Mostafa

[Arunvijai_4]

What is your current nfile value ?
# kmtune -q nfile -l
Parameter: nfile
Current: 910
Planned: (16*(NPROC+16+MAXUSERS)/10+32+2*(NPTY+NSTRPTY+NSTRTEL))
Default: (16*(NPROC+16+MAXUSERS)/10+32+2*(NPTY+NSTRPTY+NSTRTEL))
Minimum: -
Module: -
Version: -
Dynamic: No


Nfile sizes the system file table. It contains entries in it for each instance of an open of a file. Therefore, it restricts the total number of concurrent "opens" on your system. We suggest that you set this at 2800. This parameter defaults to ((16 * (nproc + 16 + maxusers) / 10 ) + 32 + 2 * npty). If a process attempts to open one more (than nfile) file, the following message will appear on the console:
file: table is full

When this happens, running processes may fail because they cannot open files, and no new processes can be started.

-Arun

[Joseph Loo]

hi,

what is the present value:

# kmtune -q nfile
or
# sar -v 3 5
check the file-sz column.

the value to change to will depend on the type of application or database running. i have it on 63498 running oracle 9i.

regards.

[Devender Khatana]

Hi,

There is no hard and fast rule to define the nfile parameter. It always depends on your applications, no. of users etc.

What is the current value and how frequently it is fully utilized will help you to know the new number. For now you can go ahead by increasing it atleast by 10% of the current value or so.

HTH,
Devender

[Walker_3]

Its ok.