ORA-13913: The threshold cannot be set when SYSAUX is offline. ORACLE 报错 故障修复 远程处理
文档解释
ORA-13913: The threshold cannot be set when SYSAUX is offline.
Cause: SET_THRESHOLD procedure was called when SYSAUX tablespace was offline.
Action: Call SET_THRESHOLD procedure when SYSAUX is online.
ORA-13913: The threshold cannot be set when SYSAUX is offline错误是在当SYSAUX tablespace处于offline状态时,更改或者设置Object Usage Thresholds时发生的错误。
官方解释
ORA-13913: 当SYSAUX Tablespace处于离线状态时,无法设置阈值
常见案例
当用户尝试设置Object Usage Threshold时,但是SYSAUX tablespace不可用,此时会收到ORA-13913的错误。
正常处理方法及步骤
1. 首先,重启SYSAUX tablespace
SQL> alter tablespace sysaux online;
2. 然后,运行以下语句以设置Object Usage Threshold:
SQL> exec dbms_stats.set_global_prefs (‘cpu_threshold’,1);
3. 最后,禁用SYSAUX tablespace
SQL> alter tablespace sysaux offline;