Problem with parameters the kernel for Oracle 8i

[Rene Mendez]

HI My system is HPUX 11i i have one problem, the message in syslog is table is full and the message in oracle is:

ORA-01115: IO error reading block from file 1 (block # 28007)
ORA-01110: data file 1: '/ora2/oracle/oradata/AXISCLI/system_01.dbf'
ORA-27041: unable to open file
HP-UX Error: 23: File table overflow

what parameters the kernel need configure?

[Paul Sperry]

The number of open files allowed by the kernel's 'nfile' parameter has been exceeded. You will need to increase this (via SAM (Kernel COnfiguration)) and reboot.

[James R. Ferguson]

Hi Rene:

Your question is answered in your other thread:

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xba195fe8b250d71190080090279cd0f9,00.html

The kernel parameter requiring increase is 'nfile'. HP-UX error-23 specifically denotes this.

Regards!

...JRF...

[Martin Johnson]

nfile is the parameter that needs to be increased. The value may be based on a formula. The formula on my system is based on nproc. Increasing nproc will automatically nfile. Use SAM to check on nfile.

HTH
Marty

[Rene Mendez]

Respect to the sar -v command, the file-sv show how mach i need increment the nfile or not. What show this.

[Steven E. Protter]

Attached is a working set of kernel parameters.

Same version of Oracle. Same OS.

SEP