File table overflow

[Amit Manna_6]

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.

[Naveej.K.A]

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

[Amit Manna_6]

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

[Joseph Loo]

hi,

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

regards.

[Naveej.K.A]

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

[Gerardo Mora]

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

sar -v