All articles

Some ideas about Oracle Database on Docker

By Franck Pachot . This is not a 'best practice' but just some ideas about building Docker images to provide an Oracle Database. I started with the images provided by Oracle: https://github.com/oracle/docker-images/tree/master/OracleDatabase/SingleInstance and this is great(…)

idql and its column output

idql and its column output A few days ago, I was reading an interesting blog from distinguished colleague Clemens Bleile with the title “sqlplus and its column output” (link here https://www.dbi-services.com/blog/sqlplus-and-its-column-output/) and I(…)

ADWC – the hidden gem: Zepplin Notebook

By Franck Pachot . In the previous blog posts I explained how to create, and stop/start the Autonomous Data Warehouse Cloud service. And I didn't show yet how to connect to it. It is(…)

SQL Server Security: Are your databases ready for the GDPR?

The GDRP (General Data Protection Regulation), voted in 2016, will be applied in the European Union soon (May 25, 2018). We heard a lot of this new directive. The goal is to improve the protection and confidentiality of personally(…)

ADWC – a Docker container to start/stop Oracle Cloud services

By Franck Pachot . In the previous post, I've explained how to start and stop the Autonomous Data Warehouse Cloud service from PSM (PaaS Service Manager). There's a setup phase, and a run phase starting with(…)

Load Balancing with Docker Swarm mode and SQL Server containers

Docker swarm mode provides an easy way to publish ports for services. Indeed, in this mode all nodes participate in an ingress routing mesh and accept connections to any service port published. Thus, all incoming requests are routed to available(…)

How uid mapping works in Docker containers?

It can be interesting to see how uids between the docker host and docker containers are mapped. For example, for security concerns. As a reminder, docker containers are based on two linux kernel features:(…)

Deploy a Cloudera cluster with Terraform and Ansible in Azure – part 2

In this part of the blog posts series, we will show how ansible helps us to configure our cluster and install all pre-requisite needed for Cloudera Manager. Ansible is one of the most important automation tools currently. Ansible will help(…)

ADWC: start/stop with PSM Command Line Interface

By Franck Pachot . In the previous post, I explained how to create an Autonomous Data Warehouse with PSM (PaaS Service Manager Command Line Interface). The most common operation you want to do with it is(…)

ADWC: Creation of Autonomous Data Warehouse Cloud service

By Franck Pachot . You want to try the Autonomous Data Warehouse Cloud Service? That’s easy. Here is a Step-by-Step. Cloud Credits First, you need Cloud Credits. You may have bought them (any recent negotiation with(…)