Database Administration (MOSC)

MOSC Banner

ORA-38153: Software edition is incompatible with SQL plan management.

edited Mar 6, 2020 6:31PM in Database Administration (MOSC) 6 commentsAnswered

Hello,

Just got above error after patching Oracle 18 SE with Security Updates Jan2020.

ADR Home = /opt/app/oracle/diag/rdbms/orcl/orcl:

*************************************************************************

2020-03-02 23:00:02.847000 +01:00

Errors in file /opt/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_j002_588.trc:

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

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

Found following doco: 'ORA-38153 Software edition is incompatible with SQL plan management' in 18.3 Standard Edition (Doc ID 2448865.1)

Should I disable SQL Tuning task as was suggested in the doco?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center