ORA-00059: maximum no. of DB_FILES exceeded

ORA-00059:
maximum number of DB_FILES exceeded

 

While adding a new datafile to tablespace, I got the ” ORA-00059: maximum no. of DB_FILES exceeded ” error, then I checked db_files parameter

SQL> Select value from v$parameter where name = 'db_files' ;

Elapsed: 00:00:00.02

I increased the db_files parameter

00:07:12 SQL> alter system set db_files=1000  scope=spfile;
System altered.
Elapsed: 00:00:00.01

Then shutdown database and startup ,

00:16:06 SQL> shutdown abort;

ORACLE instance shut down.

00:16:41 SQL>  startup;

ORACLE instance started.

Total System Global Area|8.1068E+10|bytes

Fixed Size              |   7653432|bytes

Variable Size           |1.7163E+10|bytes

Database Buffers        |6.3888E+10|bytes

Redo Buffers            |   8753152|bytes

Database mounted.

Database opened.

Then I checked db_files parameter

SQL> Select value from v$parameter where name = 'db_files';