ORA00059：maximum number of DB_FILES exceeded

处理办法：调大db_files（需重启实例生效）

SQL> select value from v$parameter where name = 'db_files'; VALUE -------------------------------------------------------------------------------- 200 SQL> select records_total from v$controlfile_record_section where type = 'DATAFILE'; RECORDS_TOTAL ------------- 1024 SQL> alter system set db_files=5000 scope=spfile sid='*'; System altered. --重启数据库集群实例 SQL> select value from v$parameter where name = 'db_files'; VALUE -------------------------------------------------------------------------------- 5000 SQL> select records_total from v$controlfile_record_section where type = 'DATAFILE'; RECORDS_TOTAL ------------- 1024 --这个不变化，如果文件个数超过1024了，自动扩，无需关心 SQL> show parameter db_files; NAME TYPE ------------------------------------ ---------------------- VALUE ------------------------------ db_files integer 5000 SQL>