ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error.

SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf' size 20G;
alter tablespace DATA add datafile '/u01/data/data15.dbf' size 20G
*
ERROR at line 1:
ORA-00059: maximum number of DB_FILES exceeded

 

 SOLUTION-

 Check for DB_FILES value

SQL> sho parameter db_files;

 NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------
db_files                             integer    500

Check Value for Total number of datafiles in Database

 SQL> select count(*) from dba_data_files;

COUNT(*)
----------
        496

Set the db_files parameter to a new high-value

SQL> alter system set db_files = 1000 scope = spfile;

 System altered.

Restart your database
SQL>shutdown immediate;
SQL>startup

SQL> sho parameter db_files;

 NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------
db_files                             integer            1000


SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf' size 20G;

issue resolved.



ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf&#...