All articles

A generic jdbc tester (part I)

A generic utility to test JDBC connections to any RDBMS or no SQL data source whose JDBC drivers are provided. Listing, PostgreSQL, Oracle Thin.

OCI : How to change VCN Name?

Starting my first experience with Oracle Cloud Infrastructure, I played with my lab and wanted to change my VCN name. I thought it might be more than easily with the Web Console, but could realise this was not possible. I(…)

SEHA on ODA?

SEHA means Standard Edition High Availability. SEHA is fully integrated with Oracle Grid Infrastructure starting with Oracle Grid Infrastructure 19c, and more specifically since RU 19.7. SEHA provides then cluster-based failover for single-instance Standard Edition Oracle Databases using Oracle Clustware.

Patching WebLogic with Stack Patch Bundle (SPB)

Oracle delivers patches for WebLogic every 3 months. These Critical Patch Updates (CPU) are often composed of multiple patches which makes even more steps to have them installed on server: Download Copy on server Installation via opatch Since April 2021,(…)

Deploying 11.2.0.4 on a recent ODA

How to deploy 11gR2 database on a modern ODA(…)

Upgrade OEM 13c from R4 to R5

By Mouhamadou Diaw Upgrading Enterprise Manger Cloud Control can be tricky. In this blog I am describing an upgrade I did for a client. The source version is OEM13c R4 And the target version will be EM13c R5 Before(…)

How to submit a talk for a conference

I already did some talks at conferences and I had already the honor to select talks for a conference. During this talk selection I found some excellent examples on how to do to a proposal, but unfortunately also some examples(…)

Configuring a SMTP relay on Oracle Linux Server v8

For some internal DMK (https://www.dbi-services.com/fr/produits/dmk-management-kit/) development I had to configure a SMTP relay on my VM. Purpose of the SMTP relay is to send the email locally from DMK without any authentication. This Email will be(…)

SQL Server: Heap page deallocation and IndexOptimize

Introduction HEAP tables are a type of data structure that, unlike a clustered index table, does not have a specific ordering of its rows, making them faster to insert and delete data. They are often used for temporary “staging” tables.

PostgreSQL 16: reserved_connections

The maximum number of connections that PostgreSQL will allow, is controlled by the max_connections parameter. By default this allows a maximum of one hundred connections: postgres=# show max_connections; max_connections ----------------- 100 (1 row) In reality not one hundred connections(…)