Return code = 24 Too many files open

[andysys]

Hi

I am using oracle on HP-UX 11.11
While opening new files I am getting following error.-

Return code = 24 Too many files open.

Output of ulimit ---

# ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 1048576
stack(kbytes) 131072
memory(kbytes) unlimited
coredump(blocks) 4194303
nofiles(descriptors) 2048

Output of /stand/system ---

# cat /stand/system
* Drivers and Subsystems

DlkmDrv
GSCtoPCI
PCItoPCI
arp
asio0
asp
autofsc
bs_osm
btlan
c720
cachefsc
cb
cdfs
cifs
clone
core
cxperf
dev_config
dev_olar
devkrs
diag0
diag1
diag2
dlkm
dlpi
dmem
echo
fcT1
fcT1_cntl
fcT1_fcp
fcms
fcp
fcp_cdio
fcparray
fcpdev
fcpmux
fddi4
ffs
gelan
hpstreams
i2o_cdio
inet
iomem
iop_drv
ip
kepd
klog
krs
lasi
lba
ldterm
lv
lvm
maclan
netdiag1
netqa
nfs_client
nfs_core
nfs_server
nfsm
nms
nuls
olar_psm
olar_psm_if
pa_generic_psm
pa_psm
pat_psm
pci
pckt
pipedev
pipemod
ptem
ptm
pts
rawip
rpcmod
sad
sapic
sba
sc
sctl
sdisk
stape
stcpmap
strlog
strpty_included
strtelnet_included
tcp
td
telm
tels
timod
tirdwr
tlclts
tlcots
tlcotsod
token_arp
tun
udp
ufs
uipc
vxfs
vxportal
wsio


* Kernel Device info

dump lvol


* Tunable parameters

STRMSGSZ 65535
dnlc_hash_locks 512
ksi_alloc_max 32768
max_thread_proc 256
maxdsiz 1073741824
maxdsiz_64bit 2147483648
maxfiles 120
maxssiz 134217728
maxssiz_64bit 1073741824
maxswapchunks 16384
maxtsiz 0X4000000
maxtsiz_64bit 0X40000000
maxusers 256
ncallout 7200
ncsize 9640
nfile 7380
ninode 4520
nkthread 7184
nproc 4096
nstrpty 60
semmap 1026
semmni 1024
semmns 16384
semmnu 2048
semume 256
shmmax 1073741824
shmmni 1024
vps_ceiling 64
maxuprc 200
#


Can anyone help me on the same.

Thanks

Andy

 

[pete91z]

Could be some kernel tuning required. Have a look at the man page for kmtune, and check maxfiles, maxfiles_lim and maxusers

 

[bi]

Check the Oracle CDs for a list of kernel parms that need to be changed to support Oracle on HP-UX. Your ninodes, maxfiles, some of the semaphore settings, and maxuproc values look a little low. also, Oracle's website metalink.oracle.com has a list of what the values should be, but the list can be difficult to find.

 

[bi]

comparing your kernel to what Oracle recommends/requires, you probably should make changes to these parameters. These are minimums. If you have a heavy duty application (like SAP) that the database is serving, the parms may even have to be higher, so you will want to check the application doc too.

maxuproc change to 3687
ncsize 35840
nfile 63488
ninode 34816
semmap 4098
semmni 4096
semmnu 4092

I also would recommend changing maxusers to something like 512.

It appears that some of the parameters on your system have been changed to meet Oracle's requirements, but not all of them.

 

[pete91z]

Some of these parameters are calculated from others, such as nfile, ninode and ncsize so bear this in mind when making changes.

 

[bi]

Yes. If you do this through sam, you'll get a warning if you change a parm that is calculated from another parm you haven't changed yet. I recommend you change that other parm before the one that gives you a warning.

I wrote some doc that gives the change order of the parms, but some overzealous person deleted it from the network.

 

[PatrickStarr]

I got this same message when trying to run something on an HP-UX 11.00 system.
My nfile limit was already high and after increasing it I still got the same message.

Strangely enough, it turned out that I did not have permissions to write to a file that the program was trying to write to! Once I changed permissions on the file, everything was fine.
It took me a long time to figure out -- no thanks to the confusing error message.