Category Archives: Multitenant

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 Multitenant – SYS*-privileges on PDB level

In an Oracle Container Database, SYSDBA, SYSDG, SYSBACKUP etc. privileges can be granted on PDB level. This enables PDB administrators with their local users e.g. to open and to close a PDB. How does this work and where is this … Continue reading

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

#c18lv: Presentation “Taming the PDB”

Today I had a second presentation at COLLABORATE18 on another feature of the Multitenant Databases: Resource management and lockdown profiles. Thanks to everyone who attended the session. Here you can find: the presentation: 2018_1226_flechtner_taming_the_pdb a demo on lockdown profiles: lockdowndemo a demo … Continue reading

Posted in Common, Multitenant | Comments Off on #c18lv: Presentation “Taming the PDB”

DOAG 2017: Application Containers

Today was the first day of the annual DOAG conference. I had a presentation „Application Containers – Multitenancy for Applications with Oracle Database 12c Release 2“. You can find the presentation and the demos here:

Posted in Common, Multitenant | Tagged , , | Comments Off on DOAG 2017: Application Containers

Switching a Multitenant Database to Extended Data Types

With Oracle 12c, Oracle introduced “extended data types”, which raise the limit for CHAR and VARCHAR2 datatypes from 4000 bytes to 32767 bytes. However, this is not the default setting and it takes some steps to change this setting. Especially … Continue reading

Posted in Multitenant, Oracle 12c | Comments Off on Switching a Multitenant Database to Extended Data Types