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.
Introduction ODA X8-2 series was sold for 3 years, and I would have expected X9-2 series to be on the market for 2-3 years, but I was wrong. ODA X10 series has just been announced. Maybe Oracle has a different strategy for appliances now, I will explain my thought later. You will notice that Oracle removed the number 2 in…
Introduction Out of the 300 features encapsulated in the new Oracle 23c database, I’ve chosen to write during the Oracle CloudWord a brief blog post about a feature that particularly caught my attention: Automatic Transaction Rollback. Starting from version 23c, Oracle enables automatic transaction rollback with parameters to manage this functionality. Through this blog post I’ll demonstrate, with a practical…
Generative AI changes everything Larry Ellison kicked off his keynote by delving into Artificial Intelligence, particularly focusing on ChatGPT. The phrase is sure to become famous “About a year ago OpenAI demonstrated ChatGPT 3.5 and much to the shock of the people who developed ChatGPT… the baby talks. Seriously the developers did not expect that“. Larry then revisited OpenAI’s history,…
Introduction It is true that it’s a somewhat daring title, and it’s unlikely that SQL firewall has changed anything about the attack that several casinos in Las Vegas suffered last week. However, the opportunity was too good to pass up on this topic. As I write this blog, Las Vegas casinos are experiencing a series of cyberattacks. It turns out…
Introduction Oracle CloudWorld 2023 will start next week in Las Vegas, and I’m happy to participate in this worldwide event. As a Swiss citizen, when I think of Las Vegas, the first image that comes to my mind is that of dazzling lights, opulent casinos, and dancing fountains. A city that never sleeps, where excess seems to be the norm.…
By end of June 2023 Oracle announced the availability of Oracle 19c for the Arm-architecture (aarch64). Consultants and DBAs, who do use a Mac Laptop with Apple Silicon (M1 or M2), have waited quite a long time to run an Oracle database in a Sandbox environment on their Apple machine. The database software Oracle 19c is not certified on MacOS.…
Introduction It’s been several weeks that patch 19.19 is available on ODA. And I finally had the possibility to test it. What’s new? This version brings latest PSUs to database and grid homes, with their bug fixes as usual. It also brings latest 21c and 19c DB Systems. You already know that 21c is an innovation release. 23c will be…
As part of a very exciting project around Oracle Exadata Cloud @ Customer (aka. ExaCC) technology, we wanted to rollout in an automated manner the database software aka. ORACLE_HOME on ExaCC database clusters (aka. VM cluster). However, we rapidly identified a small lack of command-line parameters to “mimic” the console behavior. This post describes briefly how to get rid of…
Procedure to check a one-to-one migration between different database types autogenerated and generically with OMrun.
Since Apple released their Apple Silicon Laptops based on the ARM processor architecture, it became difficult for Consultants with such a device to run their Oracle Sandbox environment, because the main Oracle products are running on the Intel architecture. Hence a virtual machine on an Apple Silicon MacBook cannot be used for e.g. an Oracle Database Sandbox environment. You may…
Introduction Patching an Oracle Database Appliance is divided in 4 main steps with 4 odacli commands in this order: It’s always recommended to update all the components, but it’s possible to stop after storage update if you want to keep older versions of the DB homes. Normally, the update-server wouldn’t need looking into DB homes, but it requires your DB…
Oracle provides an OVA (Open Virtual Appliance) file to install the 23c Free Developer Release on Virtualbox. An OVA file contains metadata and file elements in the Open Virtual Format (OVF) to package and distribute one or more virtual machines. The OVA-file provided by Oracle can also be used to import the Oracle 23c Free VM to Proxmox. Here are…
