topic Re: Problem with parameters the kernel for Oracle 8i in Operating System - HP-UX

Problem with parameters the kernel for Oracle 8i

Rene Mendez — Wed, 12 Mar 2003 21:28:42 GMT

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?

Re: Problem with parameters the kernel for Oracle 8i

Paul Sperry — Wed, 12 Mar 2003 21:31:07 GMT

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.

Re: Problem with parameters the kernel for Oracle 8i

James R. Ferguson — Wed, 12 Mar 2003 21:32:58 GMT

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...

Re: Problem with parameters the kernel for Oracle 8i

Martin Johnson — Wed, 12 Mar 2003 21:34:17 GMT

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

Re: Problem with parameters the kernel for Oracle 8i

Rene Mendez — Wed, 12 Mar 2003 21:41:06 GMT

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

Re: Problem with parameters the kernel for Oracle 8i

Steven E. Protter — Thu, 13 Mar 2003 18:51:01 GMT

Attached is a working set of kernel parameters.

Same version of Oracle. Same OS.

SEP