HOW to increase DB_FILES?

Lando/others,

  Why can't you just up the db_files = <higher or lower value> stop and restart the datbase?

Should the database read the parameter and readjust the configuration automatically?

please email thomasl_at_earthlink.net

Thanks

Thomas

In article <3433F3CC.9C3ACA95_at_quebim.com>, Lando <MarkL_at_quebim.com> writes:

>You have reached the MAXDATAFILES limit that was imposed when you
>created the
>database (I believe the default is 32). To increase this limit you will
>have to recreate your
>controlfiles and up the parameter value for maxdatafiles. Briefly, To do
>this:
>0) make sure you have a good backup
>
>1) alter database backup controlfile to trace;
>2) edit the .trc file just created in step 1, increase maxdatafiles
>value;
> edit initsid.ora increase db_files to equal new maxdatafile parm.
>3) shutdown
>4) startup nomount
>5) run the file edited in step 2.
>
>This documented should be in the manuals somewhere.
>
>
>DLEUNG wrote:
>
>> HI ,
>>
>> I am trying to increase the Max.number for DB_FILES in
>> oracle 7.32. (solaris platform),
>> because I would like to add more files to a tablespace.
>>
>> BUt I got the following error:
>> alter tablespace data05 add datafile '/u9/oradata/CNC01/data05_u9.dbf'
>> size 150M
>> *
>> ERROR at line 1:
>> ORA-00059: maximum number of DB_FILES exceeded
>>
>> -----
>> I go to init_instance_name.ora
>> and change the db_files from 20 to 40 ,
>> and then shutdown oracle and bring up by
>> startup.
>> BUt it still say the same error.
>>
>> I call Oracle support,
>> they told me instruction of recreate control_files
>> to increase MAXDATFILES,
>> I can successfully increase the MAXDATAFILES to 60, but it does not
>> help me ,
>> I try to add one additional (new ) file to a tablespace data05
>> , I havethe exact error again.
>>
>> I really appreciate if anyone can give me some help/hint,
>> because ORacle Support is very unhelpful.
>> They told me , it should work.
>> I am wondering whether MAXDATAFILES has anything to do with DB_FILES?
>>
>> Please email me directly, because I dont read this news group that
>> often
>>
>> Thank you in advance,
>>
>> Dominica Leung
>>
>> dleung_at_cncx.com
>>
>> or dleung_at_concentric.net
>
>
>
  Received on Tue Oct 07 1997 - 00:00:00 CDT