Re: hpux error 23 running oracle 8.0.4

Hi,

Your Problem :-

HP-UX Error: 23: File table overflow or File table overflow error 23

is caused by a kernel file table overflowing,

therefore the simplest solution would be to

Increase MAXUSERS in your kernel build file, (normally a file called "/stand/system") on HPUX 10.20

This in turn, increases the nfile and ninode parameters.

Note :- by increasing MAXUSERS, you will also increase many other parameters,

             or
             your could just increase 'nfile' parameter

            Its Your call ??,  your decide what to do !!!

then, after increasing whatever parameter you have decided . in your kernel build file

1. copy and save your current kernel,
2. create a new kernel with either SAM or mk_kernel command
3. move the new kernel into place, its best to reboot after moving the new kernel into place.

hope this helps

regards

-
Chris Richings
HP Unix / Openview / Oracle Support
Alcatel Australia
Sydney
Australia

email :- chris.richings_at_alcatel.com.au

NORMAL DISCLAIMERS ETC ETC
> I'm running Oracle 8.0.4 on HP-UX 10.20, when I create a
> new database I'm getting the following error:
>
> HP-UX Error: 23: File table overflow
> Additional information: 3
>
> Does anyone know where I can find the meaning of this error?
>
> Any solutions?
>
> I has checked the kernel tunable parameters and all are
> according the Oracle Documentation reccomendations.
>
> Many thanks in advance
> --
> Ing. Juan Manuel Calvo (jmc_at_cema.edu.ar)
> Director del Centro de Computos
> Universidad Del CEMA
> Cordoba 374 (1054) Capital Federal, Argentina
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

- Received on Tue Feb 09 1999 - 00:15:23 CST