ORA-12012: error on auto execute of job “SYS”.”ORA$AT_SQ_SQL_SW_38″

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;
/

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply