DBA

Do we need DBAs in 2023?

Introduction : Over the past months, people asked me more and more questions about the DBA role and the underlying question was often: Are we witnessing the end of the DBA role in IT? My first answer, after a big(…)

ODA and KVM: Debugging of DBsystem creation failure

Debugging errors when working with ODA is not always the easiest thing do... :-P It may become a bit tricky and not a straightforward process. In this blog I wanted to show you and example we faced with the debugging(…)

Adding a dbvisit standby database on the ODA in a non-OMF environment

I have recently been working on a customer project where I had been challenged adding a dbvisit standby database on an ODA X7-2M, named ODA03. The existing customer environment was composed of Oracle Standard 12.2 version database. The primary database,(…)

Creating archived redolog-files in group dba instead of oinstall

Since Oracle 11g files created by the database belong by default to the Linux group oinstall. Changing the default group after creating the central inventory is difficult. In this Blog I want to show how locally created archived redo can(…)

Migrating Oracle database from windows to ODA

Nowadays I have been working on an interesting customer project where I had to migrate windows oracle standard databases to ODA. The ODAs are X7-2M Models, running version 18.5. This version is coming with Red Hat Enterprise Linx 6.10 (Santiago).

Moving oracle database to new home on ODA

Moving database to new ORACLE_HOME is a common dba task. Performing this task on an ODA will need an additional step knowing ODA Lite is using an internal Derby database for the metadata. ODA HA will not be a problem(…)

Useful Linux commands for an Oracle DBA

Introduction Oracle & Linux is a great duet. Very powerfull, very scriptable. Here are several commands that make my life easier. These tools seems to be widespread on most of the Linux distributions. watch with diff It’s my favorite tool(…)

Create a primary database using the backup of a standby database on 12cR2

The scope of this blog will be to show how to create a primary role database based on a backup of a standby database on 12cR2. Step1: We are assuming that an auxiliary instance has been created and started in(…)

Recover a corrupted datafile in your DataGuard environment 11G/12C.

On a DG environment, a datafile needs to be recovered on the STANDBY site, in two situations : when is deleted or corrupted. Below, I will explain  how to recover a corrupted datafile, in order to be able to(…)

Upgrade Oracle Grid Infrastructure from 12.1.0.2.0 to 12.2.0.1.0

The following blog will provide the necessary steps to upgrade the Grid Infrastructure from 12.1 to 12.2, for a Standalone Server. One of the new features of GI 12.2 is the usage of the AFD (Oracle ASMFD Filter Driver).