All articles

Oracle 19C : Exporting and Importing Broker Configuration

By Mouhamadou Diaw Up to Oracle 19c, there was no automatic way to backup the configuration of the broker. One solution was to manually copy all executed instructions in a file. With Oracle 19c, there is now the possibility(…)

Oracle 19C : Dynamic Change of Fast-Start Failover Target

By Mouhamadou Diaw Oracle 19C is now available on premise. There are lot of new features. One for the Data Guard Broker is that now we can dynamically change the fast-start failover target to a specified member in the list(…)

How to migrate from on-premise to an Azure SQL Database

As a SQL Server DBA we have the habit to migrate databases from an instance to another one or to a new environment. But migrate a database from on-premise to the Azure Cloud is an operation that we don’t(…)

Unable to add physical standby database

Recently I tried to setup some new physical standby databases and got the following strange message: DGMGRL> ADD DATABASE "XXXX" as connect identifier is "XXXX" maintained as physical; Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be(…)

Two node patroni does not failover when one node crashes

A few days ago I had the interesting mission to build a two Node Patroni Postgres 9.6 Cluster using etcd in our openDB Appliance environment. Sounds easy, one leader, one secondary, both running etcd, that's it. But that's only the(…)

How to create an Azure SQL Database

Azure SQL Database is a relational database-as-a-service (DBaaS) which gives us the possibility to create application with a performant database without to take care of the relying infrastructure. Azure SQL Database is based on the latest stable version of Microsoft(…)

Oracle 18c Grid Infrastructure on Windows Server

By Mouhamadou Diaw Oracle Grid Infrastucture can be installed on Windows platform. The steps are the same that on other platforms. In this blog we are going to install Oracle GI 18c on Windows 2016.I have two disks on my(…)

Creating PostgreSQL users with a PL/pgSQL function

Sometimes you might want to create users in PostgreSQL using a function. One use case for this is, that you want to give other users the possibility to create users without granting them the right to do so. How is(…)

Direct NFS, ODM 4.0 in 12.2: archiver stuck situation after a shutdown abort and restart

A customer had an interesting case recently. Since Oracle 12.2. he got archiver stuck situations after a shutdown abort and restart. I reproduced the issue and it is caused by direct NFS since running ODM 4.0 (i.e. since 12.2.). The(…)

Bringing up an OpenShift playground in AWS

Before we begin: This is in no way production ready, as the title states. In a production setup you would put the internal registry on a persistent storage, you would probably have more than one master node and you would(…)