ORA-00059: maximum number of DB_FILES exceeded

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Article Type: General
Product: Aleph
Product Version: 16.02

Description:
When we try to add another data file for our TS4D table space, we get this error:
ORA-00059: maximum number of DB_FILES exceeded

Why is this happening?

Resolution:
DB_FILES is the maximum number of database files allowed (This is for the whole Oracle, not just a particular tablespace....).
DB_FILES is usually not present in oracle config file.

To find out the current value, you have to run sqlplus:
>> sqlplus /nolog
connect ... as sysdba
show parameters db_files

You can increase the value by adding the db_files parameter to ./oracle/admin/aleph1/pfile/initaleph1.ora and restarting Oracle.
To prevent this possible problem, you can check with UTIL-O-13-1 to see how many database files you have.

Article last edited: 10/8/2013