Oracle Database as our consultants live it every day: installation and patching, upgrades, RMAN backup and recovery, Data Guard, RAC, performance tuning, multitenant, licensing, and engineered systems such as ODA and Exadata.
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 applications on the same physical server. But what is the High Availability solution I have for virtualization on the ODA?…
How to secure your SQL script and remove password using Oracle wallets
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 11. For this I used the following patches Patch 34601305: Oracle Enterprise Manager 13c Release 5 Update 11 (13.5.0.11) for Oracle…
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 WebLogic Servers configured in SSL. As I did this configuration exercise for the YaK weblogic_domain component, the configuration has been…
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 enclosure on HA ODAs. Obviously, this is because when 2 nodes want to use the same disks, these disks have…
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 issue that the WebLogic domain was created but it was missing the Metadata Service repository (MDS) connection and thus deploying ADF applications was failing. Even…
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 Client needs to be installed. Some people executed the script provided in the blog with sqlplus (also because current versions of…
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 is the real speed of the Xeon CPUs inside these new servers? Let’s find out. Intel Xeon and CPU speed…
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. Note: The tenancy name can be found on the page “Tenancy details“ Let’s try out the OCI output suggestion: The $HOME/.config file was updated with the token and the session parameters are in…
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 them. Through this blog I wanted to share how I performed this, hoping that it might help you. All the…
