HPUX-ia64 Error: 24: Too many open files

[Phani kumar V]

We are the following problem with Oracle:


Errors in file /oracle/db/tech_st/10.2.0/admin/GAMYA_gamyadb/udump/gamya_ora_26041.trc:
ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], []
Sat Jun 6 11:18:11 2009
Errors in file /oracle/db/tech_st/10.2.0/admin/GAMYA_gamyadb/udump/gamya_ora_26041.trc:
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/oracle/db/apps_st/data/cntrl01.dbf'
ORA-27041: unable to open file
HPUX-ia64 Error: 24: Too many open files

[Vivek Bhatia]

Hi Phani,

I think you need to tune 'maxfiles' and 'maxfiles_lim'. Check out the manpage.

check the open files info with the command sar -v 1 1

Thanks
Vivek Bhatia

[Basheer_2 · Accepted solution]

Kumar,

If you are getting this for a specific user, also check

ulimit for that user.

these are usually set in the users profile

for system wide settings
kctune |grep -i files

check
maxfiles
maxfiles_limit
nfiles
ninode

[Nido]

Hello Phani,

Check the field file-sz in the output of sar -v ; This shows the current no. of files openned by the system against the max files which can be openned by the system.

Kernel parameter nfile on 11.23 can be dynamically changed.

maxfiles and maxfiles_lim parameters are responsible for the max files openned by a processes.


For details : Check the man pages for these tunnable parameters which is available in 11.23.

Tune the Parameters since its Dynamic on 11.23.

Good Luck!!

[Phani kumar V]

kctune |grep -i files
maxfiles 4096 4096
maxfiles_lim 4096 Default Immed

using
smh
maxfiles Static 4096 4096 2048 - fs
maxfiles_lim Dynamic 4096 4096 4096 100% fs

When ever "maxfiles_lim" usage in 100% we are receving the error "HPUX-ia64 Error: 24: Too many open files" as mentioned above.

[Johnson Punniyalingam]

Hi Kumar V,

>>>When ever "maxfiles_lim" usage in 100% we are receving the error "HPUX-ia64 Error: 24: Too many open files" as mentioned above. <<<<

any particular reason why "Oracle" is openinig too many open files..? what there any reason changes.? for the database.?

You try increasing maxfile & maxfile_lim
kernal paremeter.

Thanks,
Johnson

[Phani kumar V]

Hi Johnson,

Oracle Database server is installed on the system and it depends on the number of connections and database usage.

Please suggest me the hard and soft limit value is there any soft limit and hard limit calculations let me know and that would be great.

Thanks,
Phani

[Johnson Punniyalingam]

Please see below Thread. which was posted by my self.

http://forums13.itrc.hp.com/service/forums/questionanswer.do?threadId=1342472

>>>Please suggest me the hard and soft limit value is there any soft limit and hard limit calculations let me know and that would be great. <<<

Best Advice, If you could Check with Oracle Support and documentatin or Phone Support from Oracle and tune according to ORACLE recommedation.

[Johnson Punniyalingam]

>>Oracle Database server is installed on the system and it depends on the number of connections and database usage. <<<<

connections to database.?

Check also check the syslog.? do see too many connections.?

# netstat -an |grep 1521 |wc -l

Thanks
Johnson

[Phani kumar V]

Hi,

# netstat -an | grep 1560 | wc -l
192

we are not seeing more than 250 connections to the database.

What value do u prefer?

Thanks,
Phani