ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database
When I am adding datafile to my 19C database facing the below error.
SQL> alter tablespace DATA add datafile '/u01/data/data15.dbf' size 20G;
alter tablespace DATA add datafile '/u01/data/data15.dbf' size 20G
*
ERROR at line 1:
ORA-00059: maximum number of DB_FILES exceeded
SOLUTION :
Check for DB_FILES value :
SQL> sho parameter db_files;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_files integer 500
Check Value for Total number of datafiles in Database :
SQL> select count(*) from dba_data_files;
COUNT(*)
----------
496
Set the db_files parameter to a new high-value :
SQL> alter system set db_files = 1000 scope = spfile;
System altered.
Restart your database :
SQL>shutdown immediate;
SQL>startup
SQL> sho parameter db_files;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_files integer 1000
SQL> alter tablespace DATA add datafile '/u01/data/data15.dbf' size 20G;
Issue resolved !!
Comments
Tags: #dba_immam, #dbaimmam, #immam_dba, #immamDba, #woesofdba, dba immam, Immam Dba, Maximum Number Of DB_FILES Exceeded in 19C database, Maximum Number Of DB_FILES Exceeded in database, ORA-00059, ORA-00059 Maximum Number Of DB_FILES Exceeded, ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database, woes of dba