All articles

18c: No Active Data Guard required (and detected) when only CDB$ROOT and PDB$SEED are opened in read-only

By Franck Pachot . When you clone a PDB on the primary CDB, you want that the same is automatically done on the standby ones. Unfortunately, for this operation, the CDB must be opened read-only. In 12.1 even the PDB(…)

Introduction to databases for {Power.Coders} with MySQL

By Franck Pachot . This week I took some days off to do something related to my job but a bit different. I've given a course on Databases and SQL. But not for my usual customers. And not(…)

MySQL 8.0 – Roles are finally there

Roles have been existing on many RDBMS for a long time by now. Starting from version 8.0, this functionality is finally there for MySQL. The most important advantage is to define only once a role that includes a “set(…)

What’s new in EDB EFM 3.1?

Beginning of this month EnterpriseDB announced a new version of its Failover Manager. Version 2.1 introduced controlled switchover operations, version 3.0 brought support for PostgreSQL 10 and now: What's new in version 3.1? It(…)

utl_dbws causes ORA-29532 and bad_record_mac

After installing OJVM patch set update APR-2017 on a 11.2.0.4 database with PSU APR-2017 installed, first call of utl_dbws package was successful, but after a while utl_dbws calls failed always with ORA-29532 and bad_record_mac. All Java objects remained valid.

Dealing with automatic restart and SQL Docker containers

A couple of weeks ago, a customer asked me how to restart containers automatically after a reboot of the underlying host. In his context, it was not an insignificant question because some containers are concerned by SQL Server databases and(…)

Migrating from ASMLIB to ASMFD

By Mouhamadou Diaw Before Oracle 12.1 the methods used to configure ASM were • udev • asmlib Oracle 12.1 comes with a new method called Oracle ASM Filter Driver (Oracle ASMFD). In Oracle documentation we can(…)

Remote syslog from Linux and Solaris

By Franck Pachot . Auditing operations with Oracle Database is very easy. The default configuration, where SYSDBA operations go to 'audit_file_dest' (the 'adump' directory) and other operations go to the database may be sufficient to log what is done but(…)

How to fix your own SQL plan in Oracle ?

Method to build and fix your own SQL plans in Oracle and then you want to fix it for all next executions of the SQL by your application (thanks to SPM). In this post I show how fix a plan(…)

ADWC new OCI interface

By Franck Pachot . A few things have changed about the Autonomous Data Warehouse Cloud service recently. And I've found the communication not so clear, so here is a short post about what I had to do to start the(…)