Oracle

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

Fusion Middleware WebLogic domain creation fails with OPSS error

Working with YaK core, we created a YaK component to deploy WebLogic Domains, Fusion Middleware Forms & Reports and Fusion Middleware ADF infrastructure. The idea is to be able to deploy such kind of infrastructure in different Clouds or on-Premise(…)

Patching ODA HA from 19.14 to 19.16

By Mouhamadou Diaw Patching an ODA is always exciting. Preparing a patch of an ODA HA may seem more complicated that an single ODA. But it’s the same processus. All patching operations should be run on one node. In(…)