Oracle Team

Using a database trigger to request a rendition

Some time ago, a colleague asked around if someone knew a way to automatically request a rendition right after a document was checked in. This looked like a trigger to me and TBOs are here for that, right ? Sure(…)

PDB lockdown with Oracle 18.3.0.0

The PDB lockdown feature offers you the possibility to restrict operations and functionality available from within a PDB, and might be very useful from a security perspective. Some new features have been added to the 18.3.0.0 Oracle version: You have(…)

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

A SQLite extension for gawk (part III)

Welcome to part III of a three-part article on extending gawk with a SQLite binding. Part I is here. Part II is(…)

SCAN listener does not know about service

When trying to connect to a database via SCAN listener in a RAC environment with sqlplus, an ORA-12514 error is thrown. Tnsping can resolve the connect string. Whereas connecting to the same database over node listener with sqlplus succeeds. One(…)

Dbvisit 8 Standby Daemon on Windows

By Mouhamadou Diaw In this previous blog, we have installed Dbvisit standby for Windows on both servers. We suppose that the database is created and that the standby is configured (see this blog). The steps are(…)

Install Dbvisit 8 on Windows

By Mouhamadou Diaw In a previous blog we described how to install dbvisit standby in a Linux box. In this article I am going to describe the installation on a Windows machine. We are using(…)

RMAN PITR recover table Oracle 12c

At one client’s site, I had to restore a table someone had partially deleted one week before. Before Oracle 12c, we had to duplicate the target database to another server, and then to export and import data to the(…)

Oracle 18c DataGuard with Nologging Mode

By Mouhamadou Diaw With Oracle 18c database nologging has been extended with two new modes: Standby Nologging for Load Performance and Standby Nologging for Data Availability. These modes provide better support for use in an Oracle Active Data Guard environment(…)

The size of Oracle Home: from 9GB to 600MB – What about SQL Server?

Holidays is over and let’s start working with a funny write-up. I was reading interesting stuff done by my colleagues Franck Pachot and Daniel Westermann about reducing the size of Oracle / PostgreSQL binaries(…)