HPUX Error: 23: File table overflow

[Brando Sumayao]

Got the ff error. Any ideas??? Thanks!!!

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora3-mtf.60mdg.travis.af
.mil)(PORT=1521)))
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
HPUX Error: 32: Broken pipe
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-01153: Failed to process string:
NL-00313: null pointer or null size
LSNRCTL> start
Starting /u01/lvol1/app/oracle/product/8.1.7/bin/tnslsnr: please wait...

TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
HPUX Error: 23: File table overflow

[Jeff Schussele]

Brando,

Believe you've run into the max # of open files the kernel will support.

You need to increase NFILE in the kernel parameters.

HTH,
Jeff

[Jeff Schussele]

Brando,

See this link:

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x09b014a24fd1d4118fef0090279cd0f9,00.html

Rgds,
Jeff

[Sanjay_6]

Hi Brando,

Increase the kernel parameter NFILE.

http://docs.hp.com//hpux/onlinedocs/os/KCparam.Nfile.html

Hope this helps.

Regds

[Patrick Wallek]

From ITRC DocID A4222348:

Problem Description

I am getting error number (errno) 23. What does it mean?

Configuration Info

Operating System - HP-UX
Version -10.01
Hardware System -K100

Solution

This is a file table overflow error. It generally means that your system has reached the configured limit for the nfile kernel parameter.

This can either imply that you need to increase this parameter due to an overall resource needs, or that there are one or more processes unnecessarily opening a large number of files.

Layered products like GlancePlus are useful for troubleshooting application and system resource problems.

[S.K. Chan · Accepted solution]

It simply means that your system has reached the configured limit for the "nfile" kernel parameter. Meaning you need to increase this parameter. You can use SAM to find out what is your current nfile value.
A system reboot is required to modify kernel parameters. By default, the kernel parameter "maxusers" is used in the calculation of several other parameters and you should increase this parameter to get the rest bumped up.

[Helen French]

Hi,

The kernel parameter 'nfile' should be increased in order to remove this error. You can do it through SAM.

Also check what is the current value, and why it is getting full ? Check other values like maxusers and nproc too.

HTH,
Shiju

[Dennis J Robinson]

Everyone here is correct.

He needs to adjust the following kernel parmeters:

nfile - set nfile so that at max utilization
you have 50% utilized.

An easy fix for now would be to double
nfile.

Dennis J Robinson

[Brando Sumayao]

Thanks all for all your help. You all were "on the money" for what was causing my problem.

Special thanks to S.K. Chan for mentioning about the fact that by default, the kernel parameter "maxusers" is used in the calculation of several other parameters and that I should increase this parameter to get the rest bumped up.

It worked and thanks again all!

Brando