System Administration
cancel
Showing results for 
Search instead for 
Did you mean: 

HPUX-ia64 Error: 24: Too many open files

SOLVED
Go to solution

HPUX-ia64 Error: 24: Too many open files

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
11 REPLIES
Vivek Bhatia
Trusted Contributor

Re: HPUX-ia64 Error: 24: Too many open files

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
Trusted Contributor
Solution

Re: HPUX-ia64 Error: 24: Too many open files

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

Re: HPUX-ia64 Error: 24: Too many open files

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!!
" Let Villagers Be Happy!! "

Re: HPUX-ia64 Error: 24: Too many open files

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

Re: HPUX-ia64 Error: 24: Too many open files

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
Problems are common to all, but attitude makes the difference

Re: HPUX-ia64 Error: 24: Too many open files

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

Re: HPUX-ia64 Error: 24: Too many open files

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.
Problems are common to all, but attitude makes the difference
Johnson Punniyalingam
Honored Contributor

Re: HPUX-ia64 Error: 24: Too many open files

>>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
Problems are common to all, but attitude makes the difference

Re: HPUX-ia64 Error: 24: Too many open files

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

Re: HPUX-ia64 Error: 24: Too many open files

got the solution
todearvamshi
Occasional Visitor

Re: HPUX-ia64 Error: 24: Too many open files

I'm also facing smae issue . Please share the fix for the same.