How to Disable Automatic Job Causing ORA-12012 Error in Oracle Database
Error: I am getting the following error in my alert log file:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_SQ_SQL_SW_38"
ORA-38153: Software edition is incompatible with SQL plan management.
ORA-06512: at "SYS.DBMS_SPM_INTERNAL", line 6420
ORA-06512: at "SYS.DBMS_SPM", line 2840
ORA-06512: at line 34
Cause: SQL plan management is not supported in the Standard Edition 2 of the Oracle database.
Solution: Solution is to disable the automatic job if you want to run it then run manually.
For disable the job:
BEGIN
DBMS_AUTO_TASK_ADMIN.DISABLE (
client_name => 'sql tuning advisor'
, operation => NULL
, window_name => NULL
);
END;
/