ORA-00059: maximum number of DB_FILES exceeded

How to increase database files in Oracle Database -

SQL> show parameter db_files;

NAME      TYPE       VALUE
------------------------------------ -------------------------------- ------------------------------
db_files      integer       200 (Default Value)


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

SQL> shu immediate;

SQL> startup

SQL> show parameter db_files;

NAME      TYPE       VALUE
------------------------------------ -------------------------------- ------------------------------
db_files      integer       300



Thanks