RE: ORA-00059: maximum number of DB_FILES exceeded

Hi Charlie... the parameter DB_FILES is set in the init file... you have to bounce the instance after you increase it.

The parameter you are thinking of is MAXDATAFILES which is in the control file. And you are correct; you would need to ALTER DATABASE BACKUP CONTROLFILE TO TRACE, edit that MAXDATAFILES parameter, and recreate the controlfile if it were exceeded. Sounds like you just need to change DB_FILES though considering your error. DB_FILES and MAXDATAFILES can be different; might generate the trace file anyway just to check that the MAXDATAFILES setting is ok. I don't know of any other way to check it; somebody else may have a better method.

BTW... is San Diego still as sunny as ever? I'm still hooking and jabbing here in DC... send me some more pictures of the Pacific.

:-)

John Dailey, MCSE/MCP+I
Consultant
Concept Solutions, LLC
*Your Business Intelligence Partner*
www.concept-solutions.com

-----Original Message-----
Mengler
Sent: Tuesday, February 27, 2001 10:50 PM To: Multiple recipients of list ORACLE-L

I just got the following ->

  SYS: DBW.WORLD>ALTER TABLESPACE DAILY_SALES_TBL     2 ADD DATAFILE '/db19/oracle/DBW/daily_sales_tbl.dbf' SIZE 1802272768

    3 /
  ALTER TABLESPACE DAILY_SALES_TBL
  *
  ERROR at line 1:
  ORA-00059: maximum number of DB_FILES exceeded

I fixed a similar problem about 4-5 years ago & I have a vague recollection of what to do.

I need to do ->
ALTER DATABASE BACKUP CONTROLFILE TO TRACE; I then find the trace file & edit it.
Besides increasing the line where the number of datafiles is specified; what else do I need to do?

The exactly how do I use this file to start the instance? If anyone can point me at some softcopy or hardcopy documentation on this whole process, I'd appreciate it.

TIA!

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Charlie Mengler
  INET: charliem_at_mwh.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Dailey
  INET: John.Dailey_at_concept-solutions.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).