HPE Community
Operating System - HP-UX
1833832 Members
2201 Online
110063 Solutions
New Discussion

Getting the following error in Oracle alert log

 
SOLVED
Go to solution
John Goetz
Advisor

‎07-07-2004 08:15 AM

‎07-07-2004 08:15 AM

Getting the following error in Oracle alert log

Oracle instance running on a system with low open file descriptor limit. Tune your system to increase this limit to avoid severe performance degradation.
0 Kudos
Reply
2 REPLIES 2
RAC_1
Honored Contributor

‎07-07-2004 08:21 AM

‎07-07-2004 08:21 AM

Solution

Re: Getting the following error in Oracle alert log

When you are getting this message, check

sar -v 5 10
Check file nfile.
glance -t

Check what is the value of maximum nfile that is used. Seems that you are hitting the kernel setting for nfile (system wide open files) You will have to increase it and check. A reboot will be required as this is a ststic parameter.
There is no substitute to HARDWORK
Reply
Jeff Schussele
Honored Contributor

‎07-07-2004 08:24 AM

‎07-07-2004 08:24 AM

Re: Getting the following error in Oracle alert log

Hi John,

Could also possibly be either maxfiles or maxfiles_lim which are the file limits per process.
But it's more likely NFILE

Rgds,
Jeff
PERSEVERANCE -- Remember, whatever does not kill you only makes you stronger!
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.