Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 907
  • Last Modified:

ORA-00059

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
praveen_katta
Asked:
praveen_katta
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>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
 
praveen_kattaAuthor Commented:
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
 
praveen_kattaAuthor Commented:
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
 
rbrookerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now