need to run more oracle processes...

[T G Manikandan]

Hello,
You have to increase the parameter 'nfile'
for which in turn you should increase your maxusers which inturn will increase nproc.

This should solve your problem

Thanks
G Manikandan

[T G Manikandan · Accepted solution]

vmunix: file: table is full

check these links
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x7517cb60e503d6118ff40090279cd0f9,00.html
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x22388ffa98a2d5118ff10090279cd0f9,00.html

[Bill Hassell]

nproc = 1044 is VERY smal for so much Oracle activity. It should be 2000 minimum, perhaps 5000. And at the same time, nfile must also be doubled or tripled. You can verify how close to the limits you are with:

sar -v 1

The proc and file columns are the important ones, the first number is current and the second is max. If either parameter is within 80% of max, time to double the value(s).

You can check is maxuprc is large enough with:

ps -u oracle | wc -l

This is the total number of processes currently owned by oracle (and the value that maxuprc will limit).

[Jesper Andersson_1]

Tanks all of you !!! It looks to work fine now when I have changed the kernel parameters nproc and nfile .

TANKS!!!!