Oracle Team

Amazon RDS Oracle in Multitenant

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

PostgreSQL on Oracle free tier ARM

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

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

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

El Carro: The Oracle Operator for Kubernetes

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

Delphix and upgrading the clones (Oracle)

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

Patching ODA HA from 19.8 to 19.10

In this blog I am describing the steps to patch an ODA HA from the version 19.8 to version 19.10. The patching was done with a customer. Thanks to Pierre. The name of the servers were changed The ODA(…)

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

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

Rename your DB clone completely

Introduction Have you ever renamed your database? When you cloned a DB, you probably started it with a new name and cloning (duplicating) with RMAN provided a new DBID, right? So why should we need to rename a(…)

Clone a Terabyte Database in Seconds

Introduction Have you ever cloned a database using RMAN? Have you ever gotten the advice not to clone during daytime to avoid performance downgrade on the entire storage or network? For a proof of concept, we wanted to(…)

Some Artificial Intuition in Oracle SQL_ID?

By Franck Pachot . This post is something I discovered by chance when writing about tagging SQL statement with recognizable comments. We know that Oracle is introducing more and more artificial intelligence and machine learning in the database engine,(…)