Re: max db_files on 7.2.3

MarkP28665 <markp28665_at_aol.com> wrote in article <19970504171300.NAA17898_at_ladder01.news.aol.com>...
> 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
>

I've tried two ways, seems successfull...

The first one : when creating database via Oracle installer (best meth., i believe), you must check "$ORACLE_HOME/rdbms/install/initx.orc" (7.2 may be another extension) and change before creation. It's the template.(But i shouldn't advice to change other values than maxdatafiles, especialy shared_pool_size - i've had problems with at installatiom, change them later).

The second - you must create new controlfiles. I suppose, there are limits very there. Create script to recreate dtabase ( ALTER DATABASE BACKUP CONTROLFILES TO TRACE ), edit it to suit your needs and make new controlfile. (For details see manuals.)
As usualy, don't forget 3 top rules, of course : backup before, backup before and backup once more.

However i believe that there may be OS limits, too, but I haven't met. I guess, there are memory structures in controlfiles which determine such things as maxdatafiles. If i'm not right i'd be gratefull for hint.

Wbw,
Yours s.
 Uldis Pavuls

pavuls_at_konts.lv Received on Mon May 05 1997 - 00:00:00 CDT