Oracle

A generic jdbc tester (part II)

A generic utility to test JDBC connections to any RDBMS or no SQL data source whose JDBC drivers are provided. Oracle OCI, MariaDB and SQLite.

VirtualBox on Mac Host: High CPU utilization for idle VM

Many people in the IT industry do use VirtualBox as a Type-2 Hypervisor to test software in virtual machines. I’m using it with Vagrant on my Macbook Pro 2019 (Intel with Ventura 13.2. when writing this Blog) to setup testcases(…)

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.

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

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

ChatGPT vs Oracle DBA

Is ChatGPT (AI chatbot) useful for an Oracle DBA?(…)

Patching ODA HA from 19.10 to 19.17

By Mouhamadou Diaw In this blog I am describing an ODA HA (serveroda1 and serveroda2) patch from 19.10 to 19.17. The process is the same that patching a non-HA ODA. Few tasks may need to be done on both(…)