Observations when upgrading to Oracle Database 18c
I recently upgraded the repository database of my Enterprise Manager Cloud Control 13.3 playground from release 12.2 to release 18.3. When checking the alert.log of my repository database – which is a Non-CDB – I found some interesting entries in the alert.log file.
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:…