Skip to content

Clemens Bleile

Clemens Bleile has more than 30 years of IT experience, including 13 years in Oracle Support and 15 years in Oracle Consulting. He specializes in Oracle Database performance tuning and highly available, cost-efficient database architecture design. He holds Oracle Certified Professional (11g, 12c) and Oracle Certified Expert for Performance Management and Tuning credentials. Prior to dbi services, he managed the EMEA Database Performance team at Oracle Global Customer Support Services. Clemens holds a Master's degree in Business Information Systems from the Fachhochschule Furtwangen, Germany.

68 posts since February 2016

Oracle: Standard Edition 2 available with 23.26.3.?

When downloading Release Update 23.26.3., I could see this: As you can see in the Product info it also has “Oracle Server – Standard Edition”. However, I haven’t found anything official yet. I tried it and could install 23.26.3. as a Standard Edition ORACLE_HOME: After running the root-scripts I created a Database and verified that it is really a Standard… 

Oracle: Failed to create Cloud Base DB Service DB-System with RU 19.32.

Issue I recently had to create a 19c Oracle Database on the Base Database Service on Oracle@Azure. Creating the DB-System failed with the following error: We didn’t see that issue before Database Release Update 19.32. A first test on native Oracle Cloud Infrastructure (OCI) to create a Base DB Service DB-system was successful. However further tests showed that shape “VM.StandardDB.x86”… 

Temporary tablespace and ODA 19.31.

I recently patched Oracle Database Appliances (ODAs) to 19.31. For DBs with more than 1 tempfile in the temporary tablespace I got an error during the “odacli update-dbhome” : The issue is that Oracle tries to “set autoextend on” on the temporary files in 19.31., but runs a syntactically wrong command. E.g. in the alert.log I could see I.e. Oracle… 

odacli create-appliance failed on an ODA HA

I recently had to install an Oracle Database Appliance X11 HA and it failed when creating the appliance: It happened randomly in the past that we got this error “host key verification failed” and we just had to rerun our “odacli create-appliance” command again. However, this time restarting was not possible: Following MOS Note “ODA Provisioning Fails to Create Appliance… 

Migrating an Oracle database to another server

There are several situations when you have to migrate your Oracle databases to a new server. This could be due to hardware lifecycle reasons for on-prem systems or you need to upgrade your Operating System (OS) from Enterprise Linux 8 to Enterprise Linux 9. In this blog I wanted to talk about my recommended methods for such migrations considering ease… 

Oracle Database on Apple Silicon with Virtualbox 7.1

I blogged in the past about running an Oracle database for testing purposes on Apple Silicon. Initially with emulated Intel code here and then (when Oracle released its 19c database software for ARM) with UTM as a wrapper for the QEMU hypervisor here. In the meantime another possibility came up since Oracle released its type II hypervisor Virtualbox for ARM… 

What is the fastest method to connect to an Oracle database?

There are still applications around, which do connect to the database, do some stuff and then disconnect again. I.e. for each and every operation a logon to the database is necessary. This produces unnecessary overhead and is expressed in a high percentage of DB time taken by “connection management call elapsed time” in the Oracle time model. In case the… 

Running an Oracle Database 19c on Apple Silicon (Apple Macbook Air M1)

By end of June 2023 Oracle announced the availability of Oracle 19c for the Arm-architecture (aarch64). Consultants and DBAs, who do use a Mac Laptop with Apple Silicon (M1 or M2), have waited quite a long time to run an Oracle database in a Sandbox environment on their Apple machine. The database software Oracle 19c is not certified on MacOS.… 

Building a transportable Oracle Sandbox environment for an Apple Silicon Laptop (MacBook with M1- or M2-processor)

Since Apple released their Apple Silicon Laptops based on the ARM processor architecture, it became difficult for Consultants with such a device to run their Oracle Sandbox environment, because the main Oracle products are running on the Intel architecture. Hence a virtual machine on an Apple Silicon MacBook cannot be used for e.g. an Oracle Database Sandbox environment. You may… 

Installing Oracle 23c Free developer release on Proxmox

Oracle provides an OVA (Open Virtual Appliance) file to install the 23c Free Developer Release on Virtualbox. An OVA file contains metadata and file elements in the Open Virtual Format (OVF) to package and distribute one or more virtual machines. The OVA-file provided by Oracle can also be used to import the Oracle 23c Free VM to Proxmox. Here are…