ORA-00059: maximum number of DB_FILES exceeded

ORA-00059: maximum number of DB_FILES exceeded

SQL> alter tablespace  sysaux add datafile '+JBBOS_DATA' size 15G;

alter tablespace  sysaux add datafile '+JBBOS_DATA' size 15G

*

ERROR at line 1:

ORA-00059: maximum number of DB_FILES exceeded

SQL> show parameter db_files

NAME                                 Type   VALUE

------------------------------------ ------ ------------------------------

db_files                             integer 220

SQL> select count(*) from dba_data_files;

  COUNT(*)

----------

       220

 I have increased the DB_FILES Parameter from 220 t0 250.

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

System altered.

SQL>

Changes will be reflect after DB restart, so please plan a restart.