ORA-00059: maximum number of DB_FILES exceeded solution

Problem:

Output ORA-00059: maximum number of DB_FILES exceeded error when add datafile.

SQL> alter tablespace data add datafile '/oracle/oradata/orcl/data186.dbf' size 32767M;
alter tablespace data add datafile '/oracle/oradata/orcl/data186.dbf' size 32767M
*
ERROR at line 1:
ORA-00059: maximum number of DB_FILES exceeded

Check system parameter db_files & files

SQL> show parameter db_files;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_files                             integer     200

SQL> select count(*) from dba_data_files;

  COUNT(*)
----------
       200

Solution:

Increase parameter db_files values

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

System altered.

restart Database

SQL> shutdown immediate;
SQL> startup;