- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: maxfiles setting for HPUX 11.00 with Oracle 8
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2002 07:05 AM
тАО03-18-2002 07:05 AM
do_accept : To many open files
I've read earlier entries here in the forum about similar problems before. I
strongly doubt it have anything to do with nfile in this case. I believe it
is the maxfiles setting that needs to be increased. The server is running
HP-UX 11.00 with Oracle 8.1.7, do you know if there is a recommended setting
for the maxfiles with these two softwares working together?
My sysdef look like this:
NAME VALUE
acctresume 4
acctsuspend 2
allocate_fs_swapmap 0
bufpages 94468
create_fastlinks 0
dbc_max_pct 50
dbc_min_pct 5
default_disk_ir 0
dskless_node 0
eisa_io_estimate 768
eqmemsize 19
file_pad 10
fs_async 0
hpux_aes_override 0
maxdsiz 62500
maxdsiz_64bit 262144
maxfiles 60
maxfiles_lim 1024
maxssiz 2048
maxssiz_64bit 2048
maxswapchunks 1024
maxtsiz 16384
maxtsiz_64bit 262144
maxuprc 75
maxvgs 10
msgmap 2555904
nbuf 48496
ncallout 292
ncdnode 150
ndilbuffers 30
netisr_priorit -1
netmemmax 0
nfile 2810
nflocks 200
ninode 476
no_lvm_disks 0
nproc 276
npty 60
nstrpty 60
nswapdev 10
nswapfs 10
public_shlibs 1
remote_nfs_swa 0
rtsched_numpri 32
sema 0
semmap 4521984
shmem 0
shmmni 200
streampipes 0
swapmem_on 1
swchunk 2048
timeslice 10
unlockable_mem 8192
Thank You In Advance / Karl-Johan
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2002 07:09 AM
тАО03-18-2002 07:09 AM
Re: maxfiles setting for HPUX 11.00 with Oracle 8
Sandip
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2002 07:10 AM
тАО03-18-2002 07:10 AM
Re: maxfiles setting for HPUX 11.00 with Oracle 8
The lernel parameter nflocks determines the maximum number of file locks available on the system the recommended setting is
200 + sum of the values of init.ora parameter db_files for all instances of the oracle machine.
checkout the oracle installation guide operating system requirements.
hope this helpss
john.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2002 07:13 AM
тАО03-18-2002 07:13 AM
Re: maxfiles setting for HPUX 11.00 with Oracle 8
16:15:48 text-sz ov proc-sz ov inod-sz ov file-sz ov
16:15:50 N/A N/A 107/276 0 476/476 0 1006/2810 0
16:15:52 N/A N/A 107/276 0 476/476 0 1006/2810 0
16:15:54 N/A N/A 107/276 0 476/476 0 1006/2810 0
16:15:56 N/A N/A 111/276 0 476/476 0 1022/2810 0
16:15:58 N/A N/A 113/276 0 476/476 0 1027/2810 0
16:16:00 N/A N/A 113/276 0 476/476 0 1027/2810 0
16:16:02 N/A N/A 108/276 0 476/476 0 1016/2810 0
16:16:04 N/A N/A 108/276 0 476/476 0 1016/2810 0
16:16:06 N/A N/A 107/276 0 476/476 0 1007/2810 0
16:16:08 N/A N/A 107/276 0 476/476 0 1007/2810 0
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2002 07:16 AM
тАО03-18-2002 07:16 AM
Re: maxfiles setting for HPUX 11.00 with Oracle 8
Each process attacing database opens ( can open) all datafiles, so if you arte using shadows process, all it are opened by oracle owner, and then is easy to reach 60, as you have configured maxfiles.
In the other hand, i think you need tunning your kernel ( dbc_max_pct 50 is too high), and posibly more parameters.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2002 07:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2002 07:26 AM
тАО03-18-2002 07:26 AM
Re: maxfiles setting for HPUX 11.00 with Oracle 8
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2002 09:36 AM
тАО03-18-2002 09:36 AM
Re: maxfiles setting for HPUX 11.00 with Oracle 8
your kernel desperately needs some tuning :-)
You won't get very far with only up to 276 processes maximum, for instance...
Parameters I would change - but to what degree depends on your database, your application(read: database client), your amount of RAM, and so on:
create_fastlinks
maxdsiz_64bit
maxfiles
maxssiz
maxssiz_64bit
maxtsiz
maxtsiz_64bit
maxuprc
ncallout
nfile
nflocks
ninode
nproc
npty
nstrpty
nstrtel
It seems you have actually shrunk down some values, since they are smaller than even used in the install-kernel! In case you go for one of the "kernel templates" in SAM, make absolutely certain you change the value of "timeslice" back to "10", the value of "1" is suicide for any system :-(
Sorry for being that unspecific with actual values, but to recommend some, I would need more information.
Regards,
Wodisch
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2002 09:51 AM
тАО03-18-2002 09:51 AM
Re: maxfiles setting for HPUX 11.00 with Oracle 8
Maxfiles should be increased. Preferable to around 2000. There are other kernel parms too which you should definitely modify, based on the list you gave!! The values seems way too out of the norms. (less or high depends).
Attached is the output of kmtune of one of my busy database servers, for your reference.
HTH
raj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2002 10:19 AM
тАО03-18-2002 10:19 AM
Re: maxfiles setting for HPUX 11.00 with Oracle 8
/usr/bin/ulimit -Sn 1000
and this session now has maxfile set to 1000 while leaving all others at a more normal limit. maxfiles is a security/reliability parameter, thus you should adjust it just for the programs that need it. The /usr/bin/ulimit command works from any shell because it explicitly runs the POSIX shell in the script.
Bill Hassell, sysadmin