From: "Uldis" Subject: Re: max db_files on 7.2.3 Date: 1997/05/05 Message-ID: <01bc594c$88382a20$4d2a949f@pavuls.konts.lv>#1/1 References: <01bc4ec8$4c0a4b20$0349030a@Singnet.singnet.com.sg> <19970504171300.NAA17898@ladder01.news.aol.com> Organization: Konts Newsgroups: comp.databases.oracle.server MarkP28665 wrote in article <19970504171300.NAA17898@ladder01.news.aol.com>... > Baan Canada wrote in article > <01bc405e$8b58fe20$e9edb6ce@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@konts.lv