Migrating Oracle Enterprise Edition database To Standard Edition using Transportable Tablespaces

Johan Buijser August 5, 2022 Databases, AMIS, DBA Oracle, Technology No Comments

Introduction Oracle database Standard Edition (SE) has the main features of a RDBMS database and cost significantly less than Oracle Enterprise Edition (EE). Migrating a database from Oracle Enterprise …

[Continue Reading...]

Delay in establishing RAC Database connections after upgrading from Oracle 11g.

Johan Buijser July 22, 2022 Technology, Database, Databases 4 Comments

After upgrading to Oracle 12c, 19c, database connections take a long time (10 sec or more), before the connections are established. The connection time was less than 0.5 sec …

[Continue Reading...]

Enterprise Manager Convert to Cluster Database (RAC) fails without showing errors at Pre Configuration phase

Johan Buijser February 14, 2019 Database, Databases, DBA Oracle, Oracle 12 No Comments

Oracle Enterprise Manager Cloud Control 13c provides a wizard to convert a single-instance database to an Oracle RAC database. This requires the Oracle Database Lifecycle Management Pack for Enterprise …

[Continue Reading...]

Enterprise Manager DataGuard Add Standby Database fails without showing errors at Destination Preparation phase

Johan Buijser February 14, 2019 AMIS, Database, Databases, Dataguard, Enterprise Manager, Oracle 12 No Comments

Oracle Enterprise Manager Cloud Control 13c provides the Add Standby Database wizard to create a broker configuration that includes a primary database and one or more standby database. This …

[Continue Reading...]

Upgrade of Oracle Restart/SIHA from 11.2 to 12.2 fails with CRS-2415

Johan Buijser March 29, 2018 AMIS, Database, Databases, Oracle 12 2 Comments

We are in the process of upgrading our Oracle Clusters and SIHA/Restart systems to Oracle 12.2.0.1 The upgrade of the Grid-Infra home on a Oracle SIHA/Restart system from 11.2.0.4 …

[Continue Reading...]

Author: Johan Buijser