Oracle

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

Oracle DML (DELETE) and the Index Clustering Factor

As a consultant working for customers, I’m often in the situation that I have an answer to a problem, but the recommended solution cannot be implemented due to some restrictions. E.g. the recommendation would be to adjust the code, but(…)

Duplicate Database on ODA X4

By Mouhamadou Diaw The ODA X4 is still in use for some customers. The last time I was asked to validate the backups . Let me explain the context. Actually the backups are done via RMAN on local in a(…)

What is Object Storage?

By Franck Pachot . I’ve always been working with databases. Before the cloud era, the most abstract term was “data”. A variable in memory is data. A file is data. A block of disk contains data.

Oracle 20c Data Guard : Standardization of Client-Side Broker Files

By Mouhamadou Diaw In an Oracle 20c Data Guard environment with a broker configured we can have following files called client-side broker files -The observer configuration file : observer.ora -The observer log file -The observer runtime datafile:(…)

Troubleshooting performance on Autonomous Database

By Franck Pachot . On my Oracle Cloud Free Tier Autonomous Transaction Processing service, a database that can be used for free with no time limit, I have seen this strange activity. As I’m running nothing(…)

Reimaging an ODA to 19.8 Part II

By Mouhamadou Diaw In my previous blog, I described the steps to deploy an ODA 19.8 by reimaging. The ODA was reimaged with the latest available version 19.8 but some components were not up-to-dated. 1(…)

Reimaging an ODA to 19.8 Part I

By Mouhamadou Diaw Recently I was deploying some ODA X8-2M. To install the 19.8 software, I decide to reimage the server with the 19.8 image. In this blog I describe the main steps I did. First, we will need to(…)

Boost your CPU speed with Standard Edition 2 on ODA

Introduction There is no need to decrease the number of cores on your ODA when using Standard Edition 2, because your license is based on the number of physical CPU. So why would you do that? Obviously, the more cores(…)