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:…
Oracle Critical Patch Updates – some statistics
In January I started some posts on the Oracle Critical Patch Updates (CPU) on my German blog (www.markusdba.de). Here’s the translated version of my July post: In January 2018 I started publishing some statistics and graphics about Oracle’s Critical Patch Updates in my blog. Yesterday Oracle released the July patches and so it’s time for…
Oracle Multitenant – SYS*-privileges on PDB level
In an Oracle Container Database, SYSDBA, SYSDG, SYSBACKUP etc. privileges canbe granted on PDB level. This enables PDB administrators with their localusers e.g. to open and to close a PDB. How does this work and where isthis privilege information stored?