Clemens Bleile

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(…)

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(…)

Oracle Database Appliance (ODA): Some listeners do not start anymore when booting

A colleague of mine had the issue some time ago and I recently experienced the same behaviour at a customer’s ODA: A couple of Listeners did not start when booting. Starting them as user grid with srvctl start listener -listener(…)

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(…)

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(…)

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.

Patching ODA to 19.18.: Error in sshd_config

I recently patched an Oracle Database Appliance (ODA) from 19.16. to 19.18. Detailed steps on how to patch to 19.18. are available here. During the update-server step I got the following error: # odacli describe-job -i "859c6b58-19e5-453e-96a9-f29bcc70894a" Job details(…)

Oracle: Is it possible to setup a system that a client (specific IP address) can only connect to a specific DB-User?

Problem description In a recent consulting assignment I got the following task: A server with a specific IP address (Application server or Oracle Client) should be able to connect to a specific DB-user only. E.g. a single application server(…)

Considerations when backing up from the Oracle Standby Database (Data Guard) with rman to shared storage (NFS)

To reduce load on the Primary DB in a Data Guard configuration you may decide to do your rman backups from the Standby site. A very common approach today is to use NFS as the backup location, especially when using(…)

VirtualBox on Mac Host: High CPU utilization for idle VM

Many people in the IT industry do use VirtualBox as a Type-2 Hypervisor to test software in virtual machines. I’m using it with Vagrant on my Macbook Pro 2019 (Intel with Ventura 13.2. when writing this Blog) to setup testcases(…)