Oracle

ODA version 19.17 is available: how to patch?

How to patch your ODA to 19.17(…)

Oracle HTTP Server (OHS) 12c : Configure Full SSL

This blog describes how to configure an Oracle HTTP Server (OHS) 12c fronting a Fusion Middleware Forms and Reports in full SSL mode. This means, the HTTP Server listen in SSL and the mod_wl_ohs plugin is configured to connect to(…)

Warning: ODA HA disk enclosure is not smart!

Introduction Apart from the number of servers (1 vs 2), the main difference between Oracle Database Appliance lite (S/L) and High-Availability (HA) is the data disks location. They are inside the server on lite ODAs, and in a dedicated disk(…)

Ansible deployment code for Oracle Fusion Middleware Infrastructure

During the YaK weblogic_domain component development phase, I added the Oracle fusion middleware forms & Reports and the Oracle fusion middleware infrastructure for Application development Framework (ADF) deployments to the weblogic_domain component. I encountered an(…)

Latency test from Client to Oracle DB: Minimum number of rows fetched in sqlplus and sqlcl

Some time ago I wrote a Blog on how to calculate the network latency fetching a row to a Client from an Oracle database. The tool I used was sqlcl, because it just requires Java and hence no Oracle(…)

ODA X9-2 and CPU speed

Introduction It’s been several months now that Oracle released new Oracle Database Appliance X9-2 series. And my first project with 4 of these servers is coming to an end as moving to production is planned for the next weeks. What(…)

Access OCI cloud using session token

by Alexandre Nestor In the previous article A step by step guide to install and configure OCI client the oci client configuration. OCI provides also token access. ~ > oci session authenticate --profile-name MY_SESS_PROF --region eu-zurich-1 --tenancy-name(…)

ODA – HDD manual firmware patching

I recently patched ODAs X7-2-HA and X8-2-HA from version 19.8 to version 19.12 and then 19.16 at one of our customer environment. I faced some HDD firmware that was not patched during storage patching, and I had to manually patched(…)

ODA : Do You Know The MOVE Table In MySQL DB Repository

By Mouhamadou Diaw During a consulting on a customer, we faced the following issue when trying to delete a dbhome Message:  DCS-10001:Internal error encountered: PRGO-2470 : Working copy “OraDB19000_home1” is involved in an incomplete move or upgrade operation The(…)

How to Setup Dataguard on PDB Level (DGPDB)

Introduction One of the long requested features in case of Multitenant was the possibility to create and manage a data guard configuration on pdb level. Now with the Release Update 21.6 this was finaly implemented and the name of(…)