[ORA-38153] Software edition is incompatible with SQL plan management

Oracle DBMS의 Version이 Oracle DB 18c 이상이고, Standard Edition을 설치하였다면 반드시 하기 내용을 확인하시고, 반영하여 장애를 미연에 방지하시길 권장합니다.

 

 

ORA-38153  Software edition is incompatible with SQL plan management

 

 

APPLIES TO

     Oracle Database - Standard Edition - Version 18.3.0.0.0 and later  (Oracle 19c도 포함)

 

 

SYMPTOMS

 

    After creating a new Oracle 18c database (Standard Edition 2), the following error is issued in the alert.log file:
   

       ex)

           Errors in file j002_22111.trc:
           ORA-12012: error on auto execute of job "SYS"."ORA$AT_SQ_SQL_SW_36"
           ORA-38153: Software edition is incompatible with SQL plan management.
           ORA-06512: at "SYS.DBMS_SPM_INTERNAL", line 4911
           ORA-06512: at "SYS.DBMS_SPM", line 2696
           ORA-06512: at line 34

 

 

SOLUTION

 

  - SYSDBA 권한으로 하기 명령을 실행시켜주시기 바랍니다.

  BEGIN  
             DBMS_AUTO_TASK_ADMIN.DISABLE (client_name => 'sql tuning advisor',

                                                                              operation => NULL,

                                                                              window_name => NULL);
        END;

         /