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.
Using a Snapshot Standby Database to test a Characterset Conversion with DMU
Converting a database to a Unicode characterset can be a time consuming work. The Oracle Database Migration Tool for Unicode (DMU) does a really good job. But I cannot predict the duration of such a conversion. And of course, the users want to know the duration of the downtime for the conversion. In this case,…