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 with Oracle 18c XE. You can simply use the Database Configuration Assistant (dbca) to create…
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 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?