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…
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…
Oracle 18c/19c: Running a “read-only-Oracle-home” on a read-only-filesystem
In Oracle 18c Oracle introduced a new feature, called “read-only-Oracle-Home”. By configuring an Oracle-Home-directory of your RDBMS-installation as “read-only”, Oracle will place all the configuration files like spfile etc. outside the directory tree of your $ORACLE_HOME and will basically move them to “$ORACLE_BASE/dbs” and “$ORACLE_BASE/homes”. But if the software is “read-only”, can we place the…