Solved

ORA-00059

Posted on 2006-11-20
4
886 Views
Last Modified: 2013-12-11
Database is in no mount state and am running into
ORA-00059: maximum number of DB_FILES exceeded
I cannot perform alter database backup controlfile to trace to determine MAXDATAFILES.
Need Help to bring up the database.

Thank You
0
Comment
Question by:praveen_katta
  • 2
4 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 17980309
>ORA-00059: maximum number of DB_FILES exceeded
you have to recreate the database, with a higher number set during create.
see here the full description of the steps:
http://www.jlcomp.demon.co.uk/faq/incr_db_files.html
0
 

Author Comment

by:praveen_katta
ID: 17980389
As I have mentioned, the database is in nomount state
and cannot perform alter database backup controlfile to trace. The instructions
mentions to perform this step. Need an alternative please.
0
 

Author Comment

by:praveen_katta
ID: 17981756
This problem is resolved. After removing the spfile from $ORACLE\database directory.
It took the change from init.ora file and I was able to open the database with no issues.

0
 
LVL 18

Accepted Solution

by:
rbrooker earned 500 total points
ID: 17999746
Hi,

just out of interest, had you issued :

alter system set db_files = 1000 scope=spfile;

even from nomount state, and restarted the database, you would have been ok.
i ran into this when i restored out data warehouse and this is how i got around it.

just for future reference....

:)
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question