oracle-ORA-12012: error on auto execute of job "SYS"."ORA$AT_SA_SPC_SY_%

最新推荐文章于 2023-05-24 16:42:04 发布

若行若冲

最新推荐文章于 2023-05-24 16:42:04 发布

阅读量4.5k

点赞数 1

分类专栏：实施运维

实施运维专栏收录该内容

47 篇文章

订阅专栏

本文记录了在Oracle11.2.0.3版本中遇到的空间顾问自动执行任务时出现的数值溢出错误ORA-01426，并提供了详细的错误日志。分析指出这是由于bug16621589导致，在计算未压缩块的未压缩字节数时发生了溢出。文中给出了三种解决方案：升级数据库到12.1.0.2或以上版本；应用补丁16621589；禁用自动空间顾问。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

今天查看alert日志的时候发下如下错误信息：

Sat Nov 11 06:29:37 2017
Errors in file /u01/app/oracle/diag/rdbms/xxxxj002_38682.trc:
ORA-12012: error on auto execute of job “SYS”.”ORA$AT_SA_SPC_SY_6070”
ORA-01426: numeric overflow
ORA-06512: at “SYS.DBMS_ADVISOR”, line 201
ORA-06512: at “SYS.DBMS_SPACE”, line 2480
ORA-06512: at “SYS.DBMS_SPACE”, line 2560
Sat Nov 11 14:41:18 2017

查询和分析解决如下：

CHANGES
TRecently upgraded to 11.2.0.3. It used to work in 11.1.0.7 or earlier releases.

CAUSE
This is due to the bug 16621589. As per this bug, when the space advisor is running, calculation of uncompressed bytes from uncompressed blocks generated overflow. This is because the uncompresses bytes are stored in PLS_INTEGER storage data type and after internal multiplication and calculation, this datatype was not able to withhold the resultant value and is throwing the overflow error. The fix is to make data types of uncmp_bytes and cmp_bytes to use INTEGER instead of PLS_INTEGER.

SOLUTION
To resolve this issue:
- Upgrade the database to version 12.1.0.2 (and above) or 12.2 (future version) where this bug is fixed.
OR 下面
- Apply Patch 16621589.

As a workaround: Disable autospace advisor, if you are not using it, by executing the following steps:
BEGIN
DBMS_AUTO_TASK_ADMIN.DISABLE(
client_name => ‘auto space advisor’,
operation => NULL,
window_name => NULL);
END;
/