All articles

Configuring Oracle DB data source in JBoss EAP 7.1

Introduction This blog explains how to install and use an Oracle database JDBC driver in JBoss EAP 7.1 standalone instance and in a domain deployment. Oracle JDBC driver installation The first step is to install the JDBC driver in(…)

APEX Connect 2019 – Day 3

For the last conference day, after the Keynote about “JavaScript, Why Should I Care?” by Dan McGhan , I decided to attend some JavaScript learning sessions to improve myself and presentations on following topics: – How to hack your(…)

APEX Connect 2019 – Day 2

The day first started with a 5K fun run. After the Keynote about “APEX: Where we have come from and where we’re heading: Personal insights on Application Express from the Development Team” by John Snyders, Anthony Rayner and Carsten Czarski(…)

APEX Connect 2019 – Day 1

This year again the APEX connect conference spans over three days with mixed topics around APEX, like JavaScript, PL/SQL and much more. After the welcome speech and the very funny and interesting Keynote about “PL/SQL: A Career Built On(…)

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