Category: Oracle 18c

Oracle Database 18c, Standard Edition 2 & ORA-38153

When creating a new Oracle 18c database (Standard Edition 2) with dbca (custom database), I noticed lots of messages in the alert.log file: Errors in file /u00/app/oracle/diag/rdbms/sn18/SN18/trace/SN18_j002_20332.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:…

By Markus Flechtner 2018-08-04 Off