Oracle

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

High Availability VMs on ODA

Virtualisation is now possible on the ODA whatever it is an ODA Lite or HA. The virtualisation is based on KVM and integrated with odacli for Bare Metal installation. Virtualisation has got the advantage to allocate resources to databases and(…)

DB Systems backup on ODA

How to backup DB Systems on Oracle Database Appliance(…)