Re: max db_files on 7.2.3

MarkP28665 wrote:
>
> Baan Canada <Rob_Van_Brandenburg_at_baan.com> wrote in article
> <01bc405e$8b58fe20$e9edb6ce_at_robvb.BAANAM>...
> > Running Oracle 7.2.3.
> > Can't create more than 30 datafiles !
> > db_files = 100
> >
> > Suggestions ?
> >
> > Rob.
> >
> Reply was >> Check maxdatafiles
>
> If this in on a Unix system check the OS Oracle user resource limits,
> i.e., ulimit.
>
>
> Mark Powell -- The only advise that counts is the advise that you follow
> so follow your own advise

On HP unix platforms, there is a kernal parameter that limits the number of open files a process can have. Ran into this problem some time ago, so cannot remember the param. Ended up creating ~60 data files and when the instance tried to flip the log file, the database crashed.

Greg... Received on Wed May 07 1997 - 00:00:00 CDT