Re: Oracle V6 for HP9000: STARTUP PROBLEM

Vietnamese Culture Vhkhvn Science Association (vhkhvn_at_blkbox.com ) writes:
> When attempting to start a v6 instance on a HP9000, Oracle generated an
> error message stating it could not open a trace file for writing. It was
> followed by a HP error 24: Too many open files. The database could not be
> brought up until one of the rollback segments was taken offline. The HP
> nfiles parameter was checked and determined to be adequate. I would like to
> know if anyone else has experienced this problem and what the solution was.
> Please cc your replie(s) to 75124.3236_at_compuserve.com or
> vhkhvn_at_blkbox.com. Thanks.
> J. Baugh
>

There is no "nfiles" parameter on any of my hpux boxes; nfile is the hard limit for open files on the entire system. You are probably running up against maxfiles. Default is 60; configurable from 30-2048. Using setrlimit(2), a process can up its effective maxfiles up to maxfiles_lim (default 1024; configurable from 30-2048).

Regards,

W.C. Epperson Received on Wed Mar 01 1995 - 16:15:47 CET