All articles

Getting started with Exasol – Sessions and auditing

This is the fourth post in the series about Exasol and this time it is about sessions and auditing. If you are interested in the previous posts you can find them here: Getting started with Exasol(…)

Getting started with Exasol – Some words about indexes and transactions

If you followed Getting started with Exasol – Setting up an environment and Getting started with Exasol – Loading data from PostgreSQL you should have an Exasol test system up and running(…)

Oracle ADB from a Jupyter Notebook

By Franck Pachot . My first attempt to connect to an Oracle database from a Jupyter Notebook on Google Colab was about one year ago: https://medium.com/@FranckPachot/a-jupyter-notebook-on-google-collab-to-connect-to-the-oracle-cloud-atp-5e88b12282b0 I’m currently preparing a notebook as a handout(…)

Getting started with Exasol – Loading data from PostgreSQL

In the first post of this series we brought up an Exasol test system to have something to play with. Because playing without data is a bit boring this post is about loading data from PostgreSQL(…)

Getting started with Exasol – Setting up an environment

Exasol is an in memory database with parallel processing, or shorter MPP(Massively Parallel Processing) database. I got in touch with some people from Exasol at the DOAG 2019(…)

Oracle MAA reference architecture and HA, DR, RTO, RPO

By Franck Pachot . I may have mentioned in some previous blog post that, in my opinion, the names of Oracle Database features make sense on the vendor product management context more than in a user context. I’m not(…)

ODA appliance creation error and cleanup.pl with option force

I had recently faced an interesting issue deploying ODA X8-2-HA. I would like to share my experience here hoping it could help some of you.

How to migrate High Availability databases on an ODA?

Through this blog, I would like to show, with a real customer case, how I have been migrating databases in High Availability environment on an ODA. High Availability using Data Guard for Oracle Enterprise Edition or dbvisit for Oracle Standard(…)

How to synchronize the appliance registry metadata on an ODA?

Databases administration on a Bare Metal ODA will be done as root user by running odacli commands : odacli create-database to create a database odacli upgrade-database to upgrade a database between major releases odacli move-database to move databases from one(…)

Azure Database for PostgreSQL

This Blog is about some findings on Microsoft’s Azure service for PostgreSQL which I think needed to be noted. Findings about the infrastructure The Microsoft Azure Service for PostgreSQL is using Windows as OS Infrastructure, there are several points where(…)