重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: 容器数据库重复报 ORA-12012, ORA-20001, ORA-06512 [打印本页]

---

作者: 刘泽宇    时间: 2026-1-25 13:30
标题: 容器数据库重复报 ORA-12012, ORA-20001, ORA-06512
概要
容器数据库下，在alert log中看到如下报错:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_7165"
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: at "SYS.DBMS_STATS", line 47207
ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: at "SYS.DBMS_STATS", line 47197

原因
这个问题是由于一个非公开bug触发：
Bug 22879263 - BETA 12.2 - ORA-12012 , ORA-20001 AND ORA-06512 FROM ORA$AT_OS_OPT_SY_88 JOB

解决方案
Bug 已经在 12.2.0.1.0 版本中修复.
可以使用如下workaround来规避:
execute "EXEC dbms_stats.init_package();"

---

欢迎光临 重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)

Powered by Discuz! X3.2