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;


数据运维技术 » ORA-13913: The threshold cannot be set when SYSAUX is offline. ORACLE 报错 故障修复 远程处理