<div>
&gt;ORA-00059: maximum number of DB_FILES exceeded<br />
you have to recreate the database, with a higher number set during create.<br />
see here the full description of the steps:<br />
<a href="http://www.jlcomp.demon.co.uk/faq/incr_db_files.html" rel="ugc">http://www.jlcomp.demon.co.uk/faq/incr_db_files.html</a><br />

</div>


>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 [http://www.jlcomp.demon.co.uk/faq/incr_db_files.html]


<div>
As I have mentioned, the database is in nomount state<br />
and cannot perform alter database backup controlfile to trace. The instructions<br />
mentions to perform this step. Need an alternative please.
</div>


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.

<div>
This problem is resolved. After removing the spfile from $ORACLE\database directory.<br />
It took the change from init.ora file and I was able to open the database with no issues.<br />
<br />

</div>


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.



<div>
<div class="content wysiwyg-content">
Database is in no mount state and am running into <br />
ORA-00059: maximum number of DB_FILES exceeded<br />
I cannot perform alter database backup controlfile to trace to determine MAXDATAFILES.<br />
Need Help to bring up the database.<br />
<br />
Thank You
</div>
</div>


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

ORA-00059

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.