topic File table overflow in Operating System - HP-UX

File table overflow

Amit Manna_6 — Tue, 03 May 2005 03:35:07 GMT

Hi
During a batch process we got the following error:

40602 PR_CALC_SINSC 1
ORA-12801: error signaled in parallel query server P007
ORA-01116: error in opening database file 24
ORA-01110: data file 24: '/data/NTTPR1/u01/medium_t_02.dbf'
ORA-27041: unable to open file
HP-UX Error: 23: File table overflow
Additional information: 3

Anybody please suggest any corrective methods.

Thanks in advance.

Re: File table overflow

Naveej.K.A — Tue, 03 May 2005 03:42:22 GMT

Hi Amit,

you have reached the maximum limit for the number of files that can be opened at a time, which is controlled by the kernel parameter, NFILE.

You have to increase this parameter to avoid getting this error in the future.

You can use SAM to modify this parameter and you require a reboot after the parameter is modified.

With best wishes
Naveej

Re: File table overflow

Amit Manna_6 — Tue, 03 May 2005 03:46:48 GMT

Thanks for sending the reply Naveej.
Is there any guidelines to calculate the modifed nfile value.

Re: File table overflow

Joseph Loo — Tue, 03 May 2005 03:48:04 GMT

hi,

which Oracle DB version and HP-UX version r u using?

regards.

Re: File table overflow

Naveej.K.A — Tue, 03 May 2005 03:53:14 GMT

Amit,

The foolproof document is the man page!!!

Please have a look at this.

http://docs.hp.com/en/B2355-60103/nfile.5.html

Regards,
Naveej

Re: File table overflow

Gerardo Mora — Wed, 04 May 2005 11:01:21 GMT

This is caused by nfile kernel parameter hittingg the set limit.
You can check the current parameter usage using:

sar -v