Re: Urgent:Cannot increase maxusers value on HP-UX

violin.hsiao_at_mail.pouchen.com.tw (Violin) said:
>We're running Oracle 8.1.7 on HP-UX 11.0.
>Today there are too many connections,so the database instance crushed.
>After checked database alert file, the related error messages are:
...
>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.

... but increasing maxusers any further resulted in value of msgseg exceeding the maximum of 32767.

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.

-- 
Wolf  a.k.a.  Juha Laiho     Espoo, Finland
(GC 3.0) GIT d- s+: a C++ ULSH++++$ P++@ L+++ E- W+$@ N++ !K w !O !M V
         PS(+) PE Y+ PGP(+) t- 5 !X R !tv b+ !DI D G e+ h---- r+++ y++++
"...cancel my subscription to the resurrection!" (Jim Morrison)