vmunix: file: table is full message

[Kevin Flood]

Hi

I'm running an L Class on HP_UX 11:00 with Oracle 8.1.7 Enterprise.

I experienced the aabove message for the first time yesterday.

It appears to connected to Oracle, as one of the DBA's was working on table spaces.

The Oracle error was

ORA-01115 - IO error reading blovk from file 13
Cause: The device on which the file resides is probably off line

HP-UX Error: 23: File table overflow

I assume it has to do with Kernel parms ?

If so what is the best way to progress ?


Thanks in advance


Kevin Flood

[Alexander M. Ermes]

Hi there.
Check the nfile parameter in your kernel.
FOr Oracle databases you should really extend it. Try to get the lsof tool and run it, as soon as Oracle is started ( after you changed the param and created a new kernel ).
Rgds
Alexander M. Ermes

[Stefan Farrelly]

increase kernel value; nfile

On all our Oracle servers here we run it around the 4000+ number

[Shahul]

Hi

Is it something to do with ninode parameter in kernel. Please increase ninode parm and see.

Best of luck

Shahul

[Shahul · Accepted solution]

Hi

An HTML which will talk about configurable parameters is attached here. I hope this will be helpful for U.


Best of luck

Shahul

[Vincenzo Restuccia]

Stefan is right,see also http://www.dutchworks.nl/htbin/hpsysadmin?h=3&dn=48291&q=HP-UX%20Error:%2023:%20File%20table%20overflow&fh.

nfile defines the maximum number of files that can be open simultaneously, system-wide, at any given time.

Acceptable Values:
Minimum
14
Maximum
Memory limited
Default
((16*(Nproc+16+MaxUsers)/10)+32+2*(Npty+Nstrpty)

[James R. Ferguson]

Hi Kevin:

Insofar as measuring file, inode and process table sizes, 'sar -v' is quite useful as is Glance's [t]able screen. For file table metrics, 'sar' reports the current, the maximum and the number of times an overflow has occured.

...JRF...