ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_346"

Error:
Errors in file /oracle/app/oracle/diag/rdbms/crrmprd/crrmprd/trace/crrmprd_j000_8759.trc:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_346"
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: at "SYS.DBMS_STATS", line 47214
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 47204
2019-05-09 00:41:46.984000 +05:30

cause:

•  Seed database was most likely not created right by package dbms_stats.init_package not being ran. 
• Dbms_stats.init_package creates statistics advisor. This procedure is executed during database creation.
• If something went wrong during database creation,(for example, init_package is not called for some reason), 
• this kind of errors may be seen in alert log when auto job tries to execute. 

solution:

• Run dbms_stats.init_package()  in the container database to create the tasks correctly: 

$ sqlplus / as sysdba

 EXEC dbms_stats.init_package();


column name format A35
set linesize 120
select name, ctime, how_created
  from sys.wri$_adv_tasks
 where owner_name = 'SYS'
   and name in ('AUTO_STATS_ADVISOR_TASK','INDIVIDUAL_STATS_ADVISOR_TASK');

Output of the query will look like this:

NAME                                 CTIME      HOW_CREATED
----------------------------------- ---------- ------------------------------
AUTO_STATS_ADVISOR_TASK              14-APR-16 CMD
INDIVIDUAL_STATS_ADVISOR_TASK        14-APR-16 CMD


If the query based on "where owner_name = 'SYS'" condition does not show any rows but the error continues, please change the query as shown below to

see if a non-SYS user like SYSTEM owns those tasks for some reason:

$ sqlplus / as sysdba

select name, ctime, how_created,OWNER_NAME from sys.wri$_adv_tasks
where name in ('AUTO_STATS_ADVISOR_TASK','INDIVIDUAL_STATS_ADVISOR_TASK');



If the OWNER is a non-SYS user, you have to drop the tasks as that user first and then try to solution mention in the Note again.

Thank you,