Locking & unlocking common users in a Multitenant database
Common users in a multitenant database are defined in CDB$ROOT and are then available in all PDBs. Privileges can be granted locally (for a single container) or for the whole container database (CONTAINER=ALL). But what about locking and unlocking these users on the different level.
Monitoring Oracle Database 18c XE with OEM Cloud Control?
Some time ago, a customer asked me, if it possible to monitor Oracle Database 18c Express Edition (XE) with OEM Cloud Control. And – in short – it’s possible and as easy as with the other database editions.
Oracle Multitenant: From OMF-PDB to Non-OMF-PDB
Personally, I prefer running Oracle Container Databases with Oracle Managed Files (OMF), because OMF simplify the handling of the filenames, especially when cloning pluggable databases. But if you are running a “mixed environment” with some databases using OMF and others not, it may occur that you have to plugin an “OMF-PDB” as a “Non-OMF-PDB”. Let’s…