General
cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with parameters the kernel for Oracle 8i

Rene Mendez
Occasional Contributor

Problem with parameters the kernel for Oracle 8i

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?
5 REPLIES
Paul Sperry
Honored Contributor

Re: Problem with parameters the kernel for Oracle 8i

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
Acclaimed Contributor

Re: Problem with parameters the kernel for Oracle 8i

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
Honored Contributor

Re: Problem with parameters the kernel for Oracle 8i

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
Occasional Contributor

Re: Problem with parameters the kernel for Oracle 8i

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
Exalted Contributor

Re: Problem with parameters the kernel for Oracle 8i

Attached is a working set of kernel parameters.

Same version of Oracle. Same OS.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com