vmunix: file: table is full message

[Amit Mehta_1]

Hello,

I'm getting the above message vmunix: file: table is full several times together in the
syslogs. We are running an Oracle 806 server
on the machine whose init.ora is configred for
250 processes. This server is connected to by
Netscape Application Server which hangs whenever this error message appears.

The kernel parameters on the database machine are as follows :
maxusers 32
nfile 910
nproc 276
maxuprc 75

Do you think I have to increase the maxusers
value ? If so what would you recommend as an
appropriate value ? Also is there any technical document on the steps for recompiling the kernel. I have never before
recompiled a kernel. Any help would be really
appreacited.

Thanks,
Amit

[harry d brown jr]

You need to push nfile Way up, especially with a resource pig like oracle. THis is what one of my machines looks like:


maxfiles 2048
maxfiles_lim 2048
nfile 57888
maxuprc 256
nproc 3000
maxusers 512

Also, check your swapinfo, and dbc_pct_min and max settings.

live free or die
harry

[Sukant Naik]

Hi Amit,

You need to increase the maxusers to around 128 users. I am just making a guess, as I dont know the class of your server and its configuration.

When you increase the maxusers all other related kernel parameters will be taken care.

-Sukant

[Sanjay_6]

Hi Amit,

Increase the value of "nfile" kernel parameter.

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

Rebuild the kertnel and reboot the system.

Hope this helps.

Regds

[Pete Randall]

Raising maxusers to 500 or 1000 will also increase most of the related parameters as they're specified by a formula based on the value of maxusers.

Good luck,
Pete

[Sanjay_6]

Hi Amit,

You can also use the tuned kernel parameter set to tune your system for a Database Server configuration. To do this go through SAM,

SAM --> Kernel Parameters --> Configurable kernel parameters --> Push TAB and Select Action --> Tuned Kernel Parameter set --> Use the General OLTP / Database Server system parameter set --> apply this set of parameters, rebuild the kernel and reboot the system.

Hope this helps.

regds

[radi_1]

Hi Amit,
to reconfigure kernel by command line which i see it as the safest way:
1.# cd /stand/build
2.# /usr/lbin/sysadm/system_prep -s system
This creates a file called system in /stand/build dir.
3. edit this file,put new kernel params under Tunable parameters section or change allready existing params values.
4.Compile the kernel;
# /usr/sbin/mk_kernel -s ./system
This creates new kernel file called vmunix_test
5.Install the new kernel
# mv /stand/system /stand/system.old
# mv /stand/vmunix /stand/vmunix.old
# mv /stand/build/system /stand
# mv /stand/build/vmunix_test /stand/vmunix
Note:
the file /stand/vmunix.old can be used to boot your system in case the newly created kernel is causing some trouble to your application or the hp-ux.
6.Tell all users to logout and shutdown applications
7. # reboot.


To reboot from the previous kernel,interrupt the autoboot and boot to ISL;
ISL>hpux /stand/vmunix.old
Regards.

[Amit Mehta_1]

Hi again,

Well I'm using HPUX B.11.00 A 9000/800 . Can I
increase the max users parameter safely to 128
without any problems. Also i believe SAM verifies the parameter values to check they are not out of bound. So is it better to use SAM ?? How does one change the parameter values
in SAM ?

Thank you so much for your help,
Amit

[MANOJ SRIVASTAVA]

Hi Amit


In any case you will ahve to reboot the machine , so please set a time when you want to do it .

SAM---->Kerrnel Paramters --->Configurable Parameters and change what you want to change.

An important thing is to monitor using sau sar -v 2 10 and check whether nfile , nporc , ninodes are getting saturated or not.

Also you may like to look at :

http://docs.hp.com/hpux/onlinedocs/os/KCparams.OverviewAll.html


Manoj Srivastava