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';

About baranyildiz

I am Computer Engineer. Oracle & SQL Server Database,Goldengate,Guardium,Tableau , Exadata Machine administrator 6 years.I took part in many different projects in energy sector and customer information systems. I worked on sql server, oracle consolidation,migration, upgrade projectsMail : [email protected]

Leave a Reply

Your email address will not be published. Required fields are marked *