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

During the 12c database creation process , you can see ORA-20001 error in the alert log file when the “SYS.ORA $ AT_OS_OPT_SY_ <NN>” auto job runs. To fix the error, it is necessary to drop the job and recreate it. Errors will be as follows.

First of all, it is necessary to ensure that the tasks are created correctly with the following command.

Afterwards, it is necessary to identify the owner of the job with the following query.
If you see an output like the one below, you should connect with SYS. If the job owner is a different user, you should connect with that user.
In this case, you should connect with sys via sqlplus and drop and recreate the tasks correctly.

Drop operations can be done as follows.

It should then be re-created as follows.

Then there will be no errors in the alert.log file.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *