该问题出现在以前某次ORACLE表空间扩容时出现,于本日进行记录;
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.
处理方案:
- 确认当前数据文件数量
- 确认数据库当前支持的数据文件数量
- 调整数据文件支持数量并需要重启后生效
select count(*) from dba_data_files; select name,value from v$parameter where name like 'db_files'; alter system set db_files = 1000 scope = spfile; shutdown immediate startup select name,value from v$parameter where name like 'db_files';
涉及系统参数
ulimit -a
open files (-n) 1024
工作问题日志记录ORA-00059
最新推荐文章于 2022-12-01 07:34:14 发布