ORA-00059: maximum number of DB_FILES exceeded

[oracle@xhydra DB9ZX]$ oerr ora 00059
00059, 00000, "maximum number of DB_FILES exceeded"
// *Cause:  The value of the DB_FILES initialization parameter was exceeded.
// *Action: Increase the value of the DB_FILES parameter and warm start.
kIsH@Xhydra<>startup force;
ORACLE instance started.

Total System Global Area 1962932632 bytes
Fixed Size                  9136536 bytes
Variable Size            1325400064 bytes
Database Buffers          620756992 bytes
Redo Buffers                7639040 bytes
ORA-00059: maximum number of DB_FILES exceeded

kIsH@Xhydra<>select status from v$instance;

STATUS
------------
STARTED

Check the parameter db_files

kIsH@Xhydra<>show parameter db_files

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_files                             integer     25

kIsH@Xhydra<>show parameter db_create_file

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest                  string      /apps01/oradata

Increase the value for number of datafiles

kIsH@Xhydra<>alter system set db_files=200 scope=spfile;

System altered.

kIsH@Xhydra<>startup force;
ORACLE instance started.

Total System Global Area 1962932632 bytes
Fixed Size                  9136536 bytes
Variable Size            1325400064 bytes
Database Buffers          620756992 bytes
Redo Buffers                7639040 bytes
Database mounted.
Database opened.
kIsH@Xhydra<>select count(*) from v$datafile;

  COUNT(*)
----------
        26

kIsH@Xhydra<>exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@xhydra DB9ZX]$ tree|awk '{print $3}'|grep '.dbf'|wc -l
22

Leave a Reply