Author Archives: Markus Flechtner

Oracle 18c Express Edition: How to create a Non-Container-Database

Oracle 18c Express Edition (XE) comes with a container database as default database. Up to 3 pluggable databases are free so XE is a good start for getting familiar with the Multitenant architecture. However, you can still run a Non-Container-Database … Continue reading

Posted in Common, Multitenant, Oracle 18c | Comments Off on Oracle 18c Express Edition: How to create a Non-Container-Database

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 … Continue reading

Posted in Multitenant, Oracle 18c | Comments Off on Observations when upgrading to Oracle Database 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 … Continue reading

Posted in Oracle 18c | Comments Off on Oracle Database 18c, Standard Edition 2 & ORA-38153

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 … Continue reading

Posted in Common | Tagged , , | Comments Off on Oracle Critical Patch Updates – some statistics

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?

Posted in Multitenant, Oracle 12c | Comments Off on Oracle Multitenant – SYS*-privileges on PDB level