容器数据库重复报 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();"