Skip to content

Oracle Team

Posts published under the Oracle Team account are collective contributions by the dbi services Oracle consultants. The practice covers the full Oracle Database lifecycle: architecture, migration and upgrade, high availability with RAC and Data Guard, backup and recovery, performance tuning, and engineered systems such as Oracle Database Appliance and Exadata. The team holds Oracle certifications up to Certified Master level and operates customer platforms under service level agreements.

1,009 posts since December 2010

When to secure erase storage devices? How to do it on Oracle Database Appliances?

TL;DR If hardware stays inside your data center, it’s ok to secure erase storage devices. If it leaves your data center (decommission, move to another location), it’s best to physically destroy (shredder) it. Storage devices are not only hard drives, solid state drives, but also the ones holding data temporarily like memory modules (RAM) and CPUs (containing caches, register, …).… 

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 instance and lightweight schema: At the time I’m writing this, I see it only in the “old” console (“original interface”) not… 

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 Dramatical Effect of LSE Instructions for PostgreSQL on Graviton2 Instances). I have installed GCC 11 in the previous post, on a Oracle Linux… 

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 use them daily. And it goes to another level on May 25th with the announce of the ARM Ampere Altra 80 cores processor running… 

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) to automate the Oracle Database operations in a standard, open and portable way. If you ever attempted to run Oracle Database… 

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 following common scenario is not managed by the Delphix engine: You clone from production, say Oracle 12c You upgrade the clone,… 

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 is an X8-HA with following nodes -server-aa -server-ab Before starting the patches, be sure that you have enough space on /… 

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 the most misunderstood recovery error. It can happen in different case but I have here a simple example to reproduce it, with some… 

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 DB? There may be several reasons: due to changed company rules, you need to rename all your DBs After a restore you… 

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 evaluate a Pure Storage array in terms of feasibility and speed of database cloning by using storage-based snapshot technology. First, I want… 

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, but here is the first time I see something where random or hash values seems to bring some meaning. There are… 

Oracle Data Integrator Cloud

Data and applications integration is always a technical challenge for most of the companies. All data integration tool ensures that information is timely, accurate, and consistent across complex systems. Oracle Data Integrator (ODI) is different than traditional data integration tools in the sense it integrates data in a different orders. ODI is known as en E-LT because it Extracts data…