Infrastructure at your Service

All Posts By

Franck Pachot

Franck Pachot

Reduce the complexity: be sharing and open source

By | Cloud, DevOps | No Comments

By Franck Pachot . I thought that my last post on this blog was the previous one but I blog when it comes to my mind – nothing planned. And two things got me to write this. First, last week we got our 20th dbi xChange where we meet with colleagues. And I love discussing with colleagues about what we see, and foresee, in our jobs. The second one is: https://twitter.com/FranckPachot/status/1409084362637942786?s=20 The web.archive.org is full…

Read More
Franck Pachot

See you on Polywork (an new LinkedIn?)

By | AWS, Database Administration & Monitoring, Kubernetes, NoSQL, Oracle, Postgres | No Comments

By Franck Pachot . I have published 105 additional blog posts here since the 500th one https://blog.dbi-services.com/rollback-to-savepoint/ that I have written on my come back to dbi-services. On Oracle Database, of course, other databases as well, on clouds (OCI and AWS mainly, with a look at GCP and Azure). But also with some thoughts on the rise of the “scale-out” obsession of NoSQL. And, because I’m convinced that consistency, referential integrity, and SQL is a…

Read More
Franck Pachot

Cloud CLI

By | Cloud | No Comments

By Franck Pachot . Here is how to quickly install the CLI (Command Line Interface) for the following public clouds: Amazon, Google, Microsoft and Oracle. On Linux, I’m using wget but you can use curl. I’ll install all cloud command line interfaces into a $HOME/cloud directory and add an alias into $HOME/.bashrc if not already existing Amazon – AWS AWS – install ( mkdir -p ~/cloud/aws-cli ; cd /var/tmp && wget -qc https://awscli.amazonaws.com/awscli-exe-linux-x86_64.zip && unzip…

Read More
Franck Pachot

Amazon RDS Oracle in Multitenant

By | AWS, Oracle | 2 Comments

By Franck Pachot . AWS has just added the possibility to create your oracle Database as as CDB (Container Database), the “new” architecture of Oracle where an instance can manage multiple databases, adding a new level between the heavy instance and lightweight schema: At the time I’m writing this, I see it only in the “old” console (“original interface”) not in “new database creation flow”. It is displayed as a different Edition, however it is…

Read More
Franck Pachot

PostgreSQL on Oracle free tier ARM

By | Oracle, Postgres | 4 Comments

By Franck Pachot . This follows the previous post about the Oracle Cloud ARM compute shape just announced on May 25th. The processor is ARM v8.2 with LSE (atomic instructions) and PostgreSQL can benefit from it (see Dramatical Effect of LSE Instructions for PostgreSQL on Graviton2 Instances). I have installed GCC 11 in the previous post, on a Oracle Linux 7.9 image with comes with GCC 7. If you installed the Ubuntu 20.4 image, you…

Read More
Franck Pachot

An always free 4 vCPU 3.0 GHz 24 GB RAM on OCI

By | Cloud | 3 Comments

By Franck Pachot . Oracle Cloud free tier is already outstanding since OOW19 with two VMs and two databases that you can leave always running without any risk of being billed or seeing them stopped. I use them daily. And it goes to another level on May 25th with the announce of the ARM Ampere Altra 80 cores processor running at 3.0 GHz. Because on your free tier, one of those two VMs can be…

Read More
Franck Pachot

PostgreSQL on AWS Graviton2: CFLAGS

By | AWS, Postgres | No Comments

By Franck Pachot . In a previous post I’ve compiled PostgreSQL with GCC 7 and GCC 11 with the default options and checked that the ARM v8.2 features were used. However it may not be so simple: PostgreSQL ./configure defines gcc flags to produce a binary that is compatible with older versions of ARM. This means that it may not use the LSE feature introduced in ARM v8.1 With this, the default compilation (-march=armv8-a) doesn’t…

Read More
Franck Pachot

El Carro: The Oracle Operator for Kubernetes

By | Kubernetes, Oracle | One Comment

By Franck Pachot . Google Cloud, Open Source and Oracle Databases… what seems to be a paradox is possible, thanks to cloud providers who contribute to open infrastructure. The idea is to use Operators (custom resource controllers on Kubernetes) to automate the Oracle Database operations in a standard, open and portable way. If you ever attempted to run Oracle Database on containers, trying to keep up with the DevOps approach, you know that it requires…

Read More
Franck Pachot

Delphix and upgrading the clones (Oracle)

By | Postgres | No Comments

By Franck Pachot . Delphix is a tool for easy cloning of databases. The idea is that all is automated: the user can create a clone, rewind or refresh it with one click. However, I was suprised that the following common scenario is not managed by the Delphix engine: You clone from production, say Oracle 12c You upgrade the clone, say Oracle 19c You test there You refresh the clone from production, obviously being back…

Read More
Franck Pachot

An example of ORA-01152: file … was not restored from a sufficiently old backup

By | Oracle | One Comment

By Franck Pachot . Oracle Error: ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file … was not restored from a sufficiently old backup ORA-01110: data file … This error is one of the most misunderstood recovery error. It can happen in different case but I have here a simple example to reproduce it, with some comments and queries to see the state. I run an example to avoid long theory…

Read More