ORA-20001: Statistics Advisor: Invalid task name for the current user - DBCA Known Bugs

ORA-12012 , ORA-20001 AND ORA-06512 FROM ORA$AT_OS_OPT_SY_XXX

Bug 25710407

When creating a database using the DBCA from the General_Pupose.dbc or Data_Warehouse.dbc templates (or from the Seed Database) using the 12.2.0.1 Production SH in Linux and Solaris platform, the following errors in the database alert log are returned:

ORA-12012 , ORA-20001 AND ORA-06512 FROM ORA$AT_OS_OPT_SY_XXX

Platforms : Linux 12.2.0.1 Production SH

                Solaris 12.2.0.1 Production SH

The database alert log contents are:

This issue is happening because of the unavailability of the Stats Advisor Tasks from the created database:

Workaround:

Connect to the created database using the SYSDBA privilege and run the following command:

Now there are rows in these queries:

Ref:

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/readm/dbca-known-bugs.html#GUID-CC849FAD-6D19-4ED9-8866-DC9D556651EA