Re: HOW to increase DB_FILES?

Please make sure that DB_FILES is greater than or equal to MAXDATAFILES.
DB_FILES >= MAXDATAFILES If this still doesn't work, you may want to check your OS limitation on the number of files that can be open. If you reached that limit, consider regenerating the Kernel by increasing the parameter, I cannot recall the name, but you can look it up in the installation manual. Thanks,
  Kittu.

DLEUNG (Dleung_at_cris.com) 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 Wed Oct 01 1997 - 00:00:00 CDT