topic Re: vmunix: file: table is full message in Operating System - HP-UX

vmunix: file: table is full message

Kevin Flood — Fri, 20 Jul 2001 09:46:53 GMT

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

Re: vmunix: file: table is full message

Alexander M. Ermes — Fri, 20 Jul 2001 09:51:52 GMT

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

Re: vmunix: file: table is full message

Stefan Farrelly — Fri, 20 Jul 2001 09:55:13 GMT

increase kernel value; nfile

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

Re: vmunix: file: table is full message

Shahul — Fri, 20 Jul 2001 10:00:34 GMT

Hi

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

Best of luck

Shahul

Re: vmunix: file: table is full message

Shahul — Fri, 20 Jul 2001 10:05:58 GMT

Hi

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

Best of luck

Shahul

Re: vmunix: file: table is full message

Vincenzo Restuccia — Fri, 20 Jul 2001 10:06:57 GMT

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)

Re: vmunix: file: table is full message

James R. Ferguson — Fri, 20 Jul 2001 10:08:04 GMT

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...