Oracle

Oracle 12.2 : Windows Virtual Account

By Mouhamadou Diaw With Oracle 12.2 we can use a Virtual Account during the Oracle installation on Windows. Virtual Accounts allow you to install an Oracle Database and, create and manage Database services without passwords. A Virtual Account can be(…)

Configure AFD with Grid Infrastructure software (SIHA & CRS) from very beginning.

Introduction : Oracle ASM Filter Driver (Oracle ASMFD) simplifies the configuration and management of disk devices by eliminating the need to rebind disk devices used with Oracle ASM each time the system is restarted. Oracle ASM Filter Driver (Oracle(…)

Oracle 18c: Cluster With Oracle ASM Filter Driver

By Mouhamadou Diaw During the installation of Oracle Grid Infrastructure, you can optionally enable automated installation and configuration of Oracle ASM Filter Driver for your system with the Configure ASM Filter Driver check box on the Create ASM Disk Group(…)

RMAN catalog upgrade, why, when and how

One of our customer has been initially creating a RMAN catalog on an Oracle database release 12.1.0.2.0 and was now intending to register new Oracle 12.2.0.1.0 databases. Registering the databases will be failing with errors : PL/SQL package RCAT.DBMS_RCVCAT version 12.01.00.02(…)

Restoring a database without having any controlfile backup

It should never happen but sometimes it happens. You just lost your datafiles as well as your fast recovery area (probably because most of the time these areas are on the same disks despite the recommendations). Normal restore operations with(…)

A tribute to Natural Join

By Franck Pachot . I know that lot of people are against the ANSI join syntax in Oracle. And this goes beyond the limits when talking about NATURAL JOIN. But I like them and use them quite often. Why(…)

Running PLSQL as SYSDBA through DEFINER-rights?

Recently I got an interesting request: The customer wanted to allow the application installation routine to create a guaranteed restore point without giving it all required privileges to do so. So the idea was to encapsulate creating and dropping a(…)

The size of Oracle Home: from 9GB to 600MB

By Franck Pachot . This is research only and totally unsupported. When building docker images to run Oracle Database in a container, we try to get the smallest image possible. One way is to remove some subdirectories that we know(…)

Easily manage dual backup destination with RMAN

Backup on disk with RMAN is great. It’s fast, you can set as many channels as your platform can handle for faster backups. And you can restore as fast as you can read and write files on disk with these(…)

ODA database been stuck in deleting status

Facing an internal inconsistency in the ODA derby database is very painful (see https://www.dbi-services.com/blog/oda-lite-what-is-this-odacli-repository/ for more info about the derby database). I have recently faced a case where the database deletion was failing and the database remained then in "Deleting"(…)