Oracle

Why do we still have HEIGHT BALANCED Histograms and how to get rid of them?

A customer, who is on 19c with his Oracle databases asked me recently why he still has Height Balanced Histograms in his database? E.g. SQL> select histogram, count(*) from dba_tab_columns where histogram <> 'NONE' group by histogram order by 2;(…)

ODA: How to use Data Preserving Reprovisioning?

Introduction Oracle Database Appliance has a global patch available each quarter, so all the components can be patched together on a regular basis. Most of the time, applying the patch on your ODA will be OK, but sometimes you will(…)

db-crawler, a database search utility for Documentum

Working with Documentum is often a frustrating experience, and one of the main causes is the lack of meaningful error messages. Be it an encouragment to the administrator or developer to refer to the official knowledge base or a gap(…)

Will ExaC@C change or kill your DBA job?

Introduction Exadata Cloud@Customer (ExaC@C) from Oracle is an hybrid solution for customer willing a Cloud-like platform without actually being in the public Cloud. Behind cloud’s concept is a high-level management of complex stuff, like provisioning homes and databases, patching, aso.

CIFS mounts no more compatible with ODA

Introduction Some of us are using CIFS mountpoints on the ODA. This is mostly for sharing files with Windows application servers. On ODA, as on other Linux setup, it works like a charm. But it ends working starting from patch(…)

Migrating CentOS 8 to Oracle linux OL8

As you might be aware, CentOS 8 is end of life since the 31st of December 2021. If you are still using and running CentOS 8, you might want to migrate to some alternative distributions in order to keep a(…)

Patch 19.15 is available for your ODA

Introduction Patch 19.15 is now available on Oracle Database Appliance. It’s time to test it. What’s new? This version brings April’s PSU to database and grid homes with their bug fixes, as usual. It also brings latest database 21.6 but(…)

ODA X9-2: it’s finally here!

Updated the 10th of June, 2022: add PMEM option on X9-2L. Introduction It’s been nearly 3 years that Oracle Database Appliance X8-2 reached the market, and in 2022 it’s still a great performer. But now it’s time for a refresh:(…)

Installing MySQL InnoDB Cluster in OKE using a MySQL Operator

During previous months, I've had some time to satisfy my curiosity about databases in containers and I started to test a little bit MySQL in Kubernetes. This is how it all began...

Configure Data Guard between 2 DB Systems with Oracle 21c

By Mouhamadou Diaw In this previous blog, I have configured 2 DB systems with Oracle 21c in an ODA 19.14. Now let’s continue and show how we can configure a Data Guard between these 2 servers.