Oracle

Secure your SQL scripts with an Oracle wallet

How to secure your SQL script and remove password using Oracle wallets(…)

Applying RU on Enterprise Manager 13c R5

By Mouhamadou Diaw We often apply Oracle Database RU. Like database Release Update can also be passed on Enterprise Manager. On this blog I am describing how we can update an OEM 13cR5 Update 10 to OEM 13cR5 Update(…)

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