DB Ver: 12.2 BETA and higher version.
Getting Below alert in Alert.log while creating a database through DBCA in AIX Env.
ORA-12012: error on auto execute of job “SYS”.”ORA$AT_OS_OPT_SY_7252″
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
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.
For more detail about this bug and resolution follow below the links
Bug 25710407 and Bug 24433132 : Click Here MOS (Doc ID 2127675.1)