Oracle, Security Secure your SQL scripts with an Oracle wallet 16.12.2022 by Jérôme Dubar How to secure your SQL script and remove password using Oracle wallets(…)
Database Administration & Monitoring, Database management, Oracle Applying RU on Enterprise Manager 13c R5 16.12.2022 by Oracle Team 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(…)
Hardware & Storage, Operating systems, Oracle ODA version 19.17 is available: how to patch? 02.12.2022 by Jérôme Dubar How to patch your ODA to 19.17(…)
Ansible, Application integration & Middleware, Oracle, YaK Oracle HTTP Server (OHS) 12c : Configure Full SSL 29.11.2022 by Middleware Team 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(…)
Hardware & Storage, Oracle Warning: ODA HA disk enclosure is not smart! 25.11.2022 by Jérôme Dubar 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, Application integration & Middleware, Oracle, YaK Ansible deployment code for Oracle Fusion Middleware Infrastructure 24.11.2022 by Middleware Team 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(…)
Oracle Latency test from Client to Oracle DB: Minimum number of rows fetched in sqlplus and sqlcl 24.11.2022 by Clemens Bleile 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(…)
Oracle ODA X9-2 and CPU speed 23.11.2022 by Jérôme Dubar 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(…)
Cloud, Oracle Access OCI cloud using session token 21.11.2022 by Oracle Team 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(…)
Oracle ODA – HDD manual firmware patching 14.11.2022 by Marc Wagner 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(…)