All articles

Oracle Database Appliance: Install a DB Release Update manually

By Clemens Bleile Recently I upgraded an ODA X7-M from 19.12. to 19.13. After the dcs-, server- and storage-upgrade several databases on the machine had to be patched from 19.9. to 19.13. The [root@<node> ~]# odacli create-prepatchreport --dbhome --dbhomeid(…)

Managing Refreshable Clone Pluggable Databases with Oracle 21c

By Mouhamadou Diaw A refreshable clone PDB is a way to refresh a single PDB instead of refreshing all PDBs in a container as in a Data Guard environment. It consists to make a clone of a source PDB and(…)

SQL Server: Last duration for all SQL Server jobs in TIME format from HHmmss to HH:mm:ss

For a customer, I want to see all last duration for a job and have a good format for it. The query to do it is very simple (at the beginning…) but when I try to have a better(…)

Character Sets and Oracle 21c PDBs : How It Works

By Mouhamadou Diaw When creating a database in a multitenant environment we must understand how character set works for CDB and PDBS. In Oracle documentation we can find following lines -When the character set of(…)

Migrating from CentOS 8 to AlmaLinux 8

In our blogs we already talked about Migrating a CentOS 7 EC2 instance to Rocky Linux 8 and CentOS 8 machine to Red Hat 8 , but how does it look(…)

Creating KVM Database System on separate VLAN network on ODA

Oracle appliance is proposing various possibilities for creating databases either on the Bare Metal or using KVM DB System. Each DB System will host a single database in a separate VM. What about having each DB system running a separate(…)

Import tnsnames.ora in LDAP directory

This post gives a short intro to directory naming, shows how to import from tnsnames.ora to an LDAP directory. Finally, as an alternative, you get an example how a TNS connection string looks like in ldif file format. LDIF can(…)

How to configure Linux Server to run Oracle Database 19c on Persistent Memory

Introduction to Persistent Memory In the last few years, storage media have become more and more advanced and faster. Today, SSD disks are almost standard as storage and if an Oracle database really has an I/O critical workload, nvme storage(…)

How to install a specific version of MariaDB

Recently, we had to upgrade a MariaDB server from version 10.5.4 to 10.5.13. Before to do the upgrade on a production server, I wanted to test it on a personal VM. But first, I had to find how to install(…)

PostgreSQL 15: New option for NULL handling in unique constraints

Another nice feature was just committed for PostgreSQL 15: Add UNIQUE null treatment option (discussion here, commit details here). What is it about? The answer is quite easy if we do a little example(…)