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)

 

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.