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…
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,…
ORA-32002 and ORA-32001 when upgrading a database with DBUA
Some days ago I upgraded some Oracle 18c databases to Oracle 19c with the Database Upgrade Assistant (DBUA). Usually, I prefer command line tools, but for some reason I chose DBUA this time. Basically, everything went fine, except an error message in the middle of the upgrade: „ORA-32002: cannot create SPFILE already being used by…