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…
Refreshable PDBs and the Archivelog Deletion Policy
Refreshable PDBs are a cool thing within the Oracle Multitenant Architecture. You can create a copy of your large production database once and later you can „refresh“ it by applying the transactions (redologs) from the source database. But keep in mind that your archivelog deletion policy may kick in and can destroy your refresh mechanism.
Standard Edition High Availability – First Impressions
Last year Oracle caused a great outcry among the fans of the Standard Edition 2 (SE2) of the Oracle Database when they announced that Real Application Cluster (RAC)is not available for SE2 in the release 19c anymore. The “announcement” was a little bit hidden in the licensing information and the information came at very short…