Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Urgent:Cannot increase maxusers value on HP-UX
In comp.sys.hp.hpux Juha Laiho <Juha.Laiho_at_iki.fi> wrote:
> violin.hsiao_at_mail.pouchen.com.tw (Violin) said:
>>We're running Oracle 8.1.7 on HP-UX 11.0.
>>ORA-27041: unable to open file >>HP-UX Error: 23: File table overflow >> >>We got HP-UX Error:23:File table overflow before,and tried to resolve >>this by increase maxusers value.
Not a good method.
> ... but increasing maxusers any further resulted in value of msgseg
> exceeding the maximum of 32767.
Too many parameters have a formula rather than a fixed value. The formula is supposed to represent all systems but in reality, many parameter are WAY TOO LARGE when maxusers is increased.
> Do something that just increases the "nfile" value -- f.ex. add
> a multiplier to the nfile formula. With that kind of initial value,
> just doubling it will be fine. You might consider doubling ninode
> at the same time; I recall the two might be related.
Don't use the formula values for nfile, nproc or ninode. maxusers assumes that 'real' users are logging on and starting shells and editing files, which is very different than 500 clients connecting to Oracle through network sockets.
Use sar -v 1 in order to see the nfile and nproc value. Double it when the occupied value approaches 80%. ninode only applies to HFS filesystem (/stand is the only standard HFS filesystem) and should be about 1000 or so.
-- Bill 'shortsig' Hassell, HP Remote Engineering ServicesReceived on Tue May 07 2002 - 20:37:17 CDT