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

在一次巡检中，在alert日志中出现了如下报错：
ORA-12012: error on auto execute of job "SYS"."ORA$AT_SQ_SQL_SW_19038"
ORA-13629: The task or object SYS_AUTO_SQL_TUNING_TASK is being used by another operation.
ORA-06512: at "SYS.PRVT_ADVISOR", line 2735
ORA-06512: at "SYS.DBMS_ADVISOR", line 241
ORA-06512: at "SYS.DBMS_SQLTUNE", line 821
ORA-06512: at line 4

在mos有篇文章对该错误进行了解释(文档 ID 1472096.1)
CAUSE
This is expected behavior due to cancellation of one of the Auto Tuning jobs.  
A second job is spawned for the same task and ORA-13629 exception can be encountered by the database.
There may be 2 jobs running for the same Auto Tuning tasks "SYS"."ORA$AT_SQ_SQL_SW_408".
The auto sql tuning task may be interrupted or canceled for some underlying reason, 
and hence the exception of ORA-13629 was raised. The underlying reason of interruption is not known, but most likely it is outside the database.

==>大致意思是说，oracle发起了2份相同的 "SYS"."ORA$AT_SQ_SQL_SW_408"的调度任务，终止第二份任务，触发了该报错。

SOLUTION
The error can be safely ignored and is harmless. This is considered normal behavior due to cancellation of one of the Auto Tuning jobs.
Check the property of the advisor to see whether it has been execute multiple times. 
If it is the case, create a new execution or resume the last task execution, but only if the task is not  currently being executed.

==》此错误可以被忽略，不引起关注。

end!

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25923810/viewspace-2121181/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25923810/viewspace-2121181/