RE: ORA-00059: maximum number of DB

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Tue, 27 Feb 2001 21:25:07 -0800
Message-ID: <F001.002BF235.20010227211049@fatcity.com>

Hi Charlie,

Just increase the 'db_files' parameter.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/

-----Original Message-----
Sent: Wednesday, 28 February 2001 13:50
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: Steve Adams
INET: steve.adams_at_ixora.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

RE: ORA-00059: maximum number of DB_FILES exceeded