ORA-00059: 数据文件达到DB_FILES最大值
SYS@orcl1> alter tablespace TS_IDS add datafile +DATA size 200M autoextend on next 200M maxsize unlimited; alter tablespace TS_IDS add datafile +DATA size 200M autoextend on next 200M maxsize unlimited * ERROR at line 1: ORA-00059: ³¬³_FILES µŗֵ
查看日志
Mon Jul 10 09:48:15 2023 alter tablespace TS_IDS add datafile +DATA size 200M autoextend on next 100M maxsize unlimited ORA-59 signalled during: alter tablespace TS_IDS add datafile +DATA size 200M autoextend on next 100M maxsize unlimited...
查询发现DB_FILES到了最大值
SYS@orcl1> show parameter DB_FILES
NAME TYPE VALUE --------------- ---------------------- ------------------------------ db_files integer 200
平时维护的都是相对小的环境，处理办法修改DB_FILES，重启后生效
SYS@orcl1> alter system set db_files=20000 scope=spfile;
环境若为rac环境，则需要按修改参数后对两节点同时重启。 建议在新建时对此参数进行调整。
