Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

ORA-00059

Posted on 2006-11-20
4
Medium Priority
?
899 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 1500 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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
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.
This video shows how to recover a database from a user managed backup
Suggested Courses

876 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