Clemens Bleile

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

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: Launch DbSystem failed. Reason : DCS-10001:Internal error encountered: Failed to download the fast clone.DcsException{errorHttpCode=InternalError,(…)

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” : # odacli describe-job -i 2ff3fd5d-f611-4ae6-aae0-63df7c08ec71 Job details ---------------------------------------------------------------- ID: 2ff3fd5d-f611-4ae6-aae0-63df7c08ec71(…)

Oracle: A possible method to address a slow query if there is time pressure

Sometimes there is no time for a long analysis of a slow query and a fix (workaround) has to be provided asap. In such cases it often helps to check if a query did run faster with a previous(…)

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: [root@oak0 ~]# odacli create-appliance -r /u01/patch/my_new_oda.json ... [root@mynewoda ~]# odacli describe-job -i 88e4b5e3-3a73-4c18-9d9f-960151abc45e Job details ---------------------------------------------------------------- ID: 88e4b5e3-3a73-4c18-9d9f-960151abc45e Description: Provisioning service(…)

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

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

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

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