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;