The Context In the context of Oracle Database Aplliances, you might need to remove an old Oracle Database Home (For instance 12c), while the ODA is already on a recent patch level. For instance in my case : In an ODA patching operation, the appliance was already running 19.26 patchlevel On Oracle Linux 8.10, while an unused Oracle Database 12.2…
Introduction Oracle Database True Cache is an in-memory, read-only cache designed to reduce latency and offload read activity from the primary database. It’s comparable to an Active Data Guard standby instance, but it runs mostly in memory. This feature debuted in Oracle Database 23ai, which has since been rebranded as Oracle AI Database 26ai. There are several free ways to…
The Concept Starting with Oracle Enterprise Manager (OEM) 13.5 RU24 (October 2024), Oracle introduced the Holistic Patch for OEM — a unified patching model that consolidates several separate updates into a single coordinated package. Previously, administrators had to patch: * The OMS and Agents with the quarterly Release Update (RU). * OEM Application via the System Patch Bundle (SPB). *…
The database Capture/Replay feature of the Real Application Testing (RAT) suite enables you to capture the workload from a production database and replay it on a test or development environment. This allows for realistic testing of database changes, such as upgrades, patches, or hardware migrations. In this blog, we’ll explore how to accomplish this when both your production and test…
In the Oracle Database 23ai Enterprise Edition, it is now possible to automatically rollback some transactions, and a set of new parameters have been added to control this behavior. Of course implementing this feature requires deep understanding of your application, data model and source code. The general idea : * We don’t want critical transactions to be delayed for too…
Introduction In Oracle Database 19c, if you have a Dataguard Configuration of a multitenant database, and you want to clone a pluggable database from a remote server to your primary, then you have to mind that the dataguard mechanism is about applying redo, not copying datafiles : After you execute the clone, the new cloned pluggable will be useless on…
