Database

AutoUpgrade Patching – From Zero to Hero – Part 4: Download Examples

Let me take off into the 4th part of this blog post series: AutoUpgrade Patching – From Zero to Hero – Part 4: Download Examples. I’d like to show you some of the most common examples and use cases we came across. And of course, I will add some additional (and hopefully useful) information on top.

AutoUpgrade Patching – From Zero to Hero – Part 4: Download Examples

The patch parameter

At first, in my previous blog post I used patch1.patch=RECOMMENDED (by the way, upper/lowercase does not matter). But I didn’t explain the whole extent and possibilities of the patch parameter to you.

Here’s a list of the most important parameter …

AutoUpgrade Patching – From Zero to Hero – Part 2: MOS Credentials

Posted on July 7, 2026 by Mike.Dietrich AutoUpgrade Patch Recommendation 11

In this blog post series AutoUpgrade Patching – From Zero to Hero – Part 2: MOS Credentials will be our topic for today. If you are tired of going through MOS notes over and over again to identify the most important fixes and fetch them, you need to automate it. But in order to automate the download, you need to infuse your MOS credentials into the AutoUpgrade keystore. Let’s do this together now.

AutoUpgrade Patching - From Zero to Hero - Part 2: MOS Credentials

Create directories

Before we really start, you should define a few directories at first. In my case, I copied the newest version of AutoUpgrade into /Users/mdietric/TEMP/AU. …

AutoUpgrade Patching – From Zero to Hero – Part 1: Download AutoUpgrade

Posted on July 6, 2026 by Mike.Dietrich AutoUpgrade Patch Recommendation 9

I was traveling the past two weeks, and I met a lot of customers who still “enjoy” navigating through MOS and searching for the right patches to download. This blog post series will give you ultimate relief, and it will ease your life as DBAs and sysadmins. You must patch more frequently – and this is the key solution for everyone. Let’s get us started with AutoUpgrade Patching – From Zero to Hero – Part 1: Download AutoUpgrade today.

AutoUpgrade Patching - From Zero to Hero - Part 1

Download the newest version of AutoUpgrade

Our first task is simple. You will find autoupgrade.jar in your ?/rdbms/admin directory since Oracle …

Patch your databases against AI-enabled cybersecurity threats

Posted on May 4, 2026 by Mike.Dietrich Oracle AI Database 26ai Oracle Database 19c Patch Recommendation Security 35

I guess you all read the announcements and predictions over the past weeks. New AI models and improvements to existing models may allow to find security issues in existing software much quicker. While this sounds alarming on one side (yes, it does), it also enables software vendors to secure their software. But in order to benefit from it, you must patch your databases against AI-enabled cybersecurity threats.

Patch your databases against AI-enabled cybersecurity threats

Photo by Scott Webb on Unsplash

Read the official announcements

At first, please read the official announcements released here:

Accelerating Vulnerability Detection and Response at Oracle (3 min read – April 29,

April 2026 Release Updates (RUs) 19.31 and 23.26.2 are delayed

Posted on April 23, 2026 by Mike.Dietrich Patch Recommendation 69

Yesterday, I delivered a full-day workshop for ora2know in Düsseldorf. And we discussed the most recent RUs as well, especially since “Database Patching” consumed a significant part of the day content-wise. I learned that the RUs have now a target date of April 28 for Linux, and May 12 for other ports. Which means that the April 2026 Release Updates (RUs) 19.31 and 23.26.2 are delayed.

April 2026 Release Updates (RUs) 19.31 and 23.26.2 are delayed

Photo by Suganth on Unsplash

Why are the April 2026 Release Updates (RUs) 19.31 and 23.26.2 delayed?

I don’t know the reason, and there is (as far as I can see) no official …

The February 2026 release of AutoUpgrade (26.2) is available

Posted on February 11, 2026 by Mike.Dietrich AutoUpgrade 15

This is a ground-breaking new release of AutoUpgrade, and the team worked hard to release it last weekend. This means for you that you should renew your AutoUpgrade tools as The February 2026 release of AutoUpgrade (26.2) is available now for download.

The February 2026 release of AutoUpgrade (26.2) is available

Photo by Anders Jildén on Unsplash

1..2..3..4..5..0 …

In case you wonder about this cryptic headline, no worries. a customer highlighted this well-chosen and easy-to-remember number to me the other day. And I was not aware, but it is true: KB123450 is the MOS note allowing you to download AutoUpgrade from MOS. Awesome … I already programmed this …

It’s there – Oracle AI Database 26ai is available for download

Posted on January 27, 2026 by Mike.Dietrich Oracle AI Database 26ai 33

This was a long wait – and finally, it’s there – Oracle AI Database 26ai is available for download on-prem. And as you may remember our announcement from Oracle AI World, Oracle AI Database 26ai replaced Oracle Database 23ai.

Photo by John Tuesday on Unsplash

What is available?

You can download now the Linux version of Oracle AI Database 26ai Enterprise Edition, 23.26.1.0.0, from the usual sources as a Gold Image include the RU or as a separate RU.

Besides the 23.26.1 database release, you …

ora2know Hands-On Workshop: Upgrade to Oracle 19c and 23ai

Posted on June 24, 2025 by Mike.Dietrich Oracle Database 23ai Workshop 2

Let’s kick it off. When the ora2know group started at DOAG conference in Nuernberg in November 2024, we committed ourselves to support them. And this is exactly the reason why I am going to invite you to this unique event in Munich on July 10, 2025. I will run an ora2know Hands-On Workshop: Upgrade to Oracle 19c and 23ai. And you are going to type 🙂 You need to sign up early since we have only a limited number of seats available.

Hands-On-What?

Yes, hands-on. Try it out. Learn from each other. Step left or right, do mistakes, play …

Small Pages not allowed for SGA from 19.27 and newer on Exadata

Posted on April 17, 2025 by Mike.Dietrich Behavior Change Exadata / ODA Flaws and Pitfalls 12

Having good friends in Oracle is key. And honestly one of the best things in my role. Philippe Fierens, product manager for Oracle’s Fleet Patching and Provisioning mailed me yesterday night sharing that there is an interesting change coming with Database Release Update 19.27: Small Pages not allowed for SGA from 19.27 and newer on Exadata.

Small Pages not allowed for SGA from 19.27 and newer on Exadata

Photo by George Bonev on Unsplash

What does this mean?

As you can read in MOS Note: 3081878.1 – Starting DBRU 19.27 Small Pages Are Not Allowed for RDBMS SGA In Exadata, from Release Update 19.27 onward (this is the April 2025 …

How do find new features in Oracle Release Updates (RUs)?

Posted on March 24, 2025 by Mike.Dietrich Behavior Change Oracle Database 19c Oracle Database 21c Oracle Database 23ai 4

I know, not everybody is a huge fan of new features in RUs. But how do find new features in Oracle Release Updates (RUs)? Are the listed anywhere? They are, no worries. At least since Oracle Database 19c.

Photo by Jake Weirick on Unsplash

New Features in RUs?

I can already sense that some of you will be tempted to comment and tell me that you don’t like any new features in Oracle Database Release Updates, in short: RUs. But on the other hand there is also something good with it. Rather than waiting for the next full database release …

Important Update to Oracle Database 19c Support Timelines

Posted on November 20, 2024 by Mike.Dietrich Release Schedule 22

Long silence doesn’t mean that I am hiding. It just means that it’s very busy right now. And hopefully with less travel I will have more time to blog and reply also to your comments. Still, let me tell you about a very Important Update to Oracle Database 19c Support Timelines.

Important Update to Oracle Database 19c Support Timelines

Photo by Lukasz Szmigiel on Unsplash

What has been updated?

As of November 19, 2024, the Support timelines for Oracle Database 19c have been adjusted. When you look at MOS Note: 742060.1 – Release Schedule of Current Database Releases you will see the new dates:

Premier Support until

Upcoming in-person Oracle 23ai workshops in Berlin, Zürich and Oslo

Posted on October 1, 2024 by Mike.Dietrich Workshop 6

It’s fall (or autumn) already, and for us the time for user groups and full-day workshops starts. Please please please … be aware, those workshops are in-person only. No streaming, and no recording will be available. We try to offer them as often as possible, and we have already an impressive list of dates for 2025 between January and May. But we are still in 2024 – and it is your chance to sign up now to ourUpcoming in-person Oracle 23ai workshops in Berlin, Zürich and Oslo in October.

Upcoming in-person workshops in Berlin, Zürich and Oslo

Photo by Soroush Karimi on Unsplash

Sign-up quickly

In …

Different handling of UNLIMITED QUOTA when you revoke the DBA role between 11.2.0.4 and future releases

Posted on July 10, 2024 by Mike.Dietrich Behavior Change Oracle Database 11g Oracle Database 19c 5

“Oh heck” you may think. “Why is he blogging about 11.2.0.4?”. But as a matter of fact, I work right now with a customer in Germany where we try to lift a fairly large database into Autonomous Database Serverless (ADB-S). And as I love to learn new things every day but (as most of us) have just limited brain capacity, I prefer to put things on the blog. Only challenge as Klaus from our team demonstrated to me yesterday: I need to remember that I wrote something about it. Anyhow, since we still have a number of customers on Oracle …

Why isn’t the newest JDK in this Oracle Release Update?

Posted on June 20, 2024 by Mike.Dietrich Best Practice 7

Quick blog post only since I received this question 3x this week in various ways from customers. Why isn’t the newest JDK in this Oracle Release Update? Let me try to answer and explain it.

Photo by Jan Kronies on Unsplash

JDK in the Oracle Home

Actually, when you look at your Oracle Home, you will find a subdirectory:

/u01/app/oracle/product/19/jdk
$ tree -L 1
.
├── bin
├── COPYRIGHT
├── include
├── javafx-src.zip
├── jmc.txt
├── jre
├── jvisualvm.txt
├── legal
├── lib
├── LICENSE
├── README.html
├── release
├── THIRDPARTYLICENSEREADME-JAVAFX.txt
└── THIRDPARTYLICENSEREADME.txt

And in the bin directory, there is …

Virtual Classroom Seminar 18: Cross Platform Migration to the Extreme

Posted on February 19, 2024 by Mike.Dietrich Transportable Workshop 0

This week on Thursday, February 22, 2024 at 16:00h CET we’d like to invite you to our next Virtual Classroom Seminar 18: Cross Platform Migration to the Extreme. Take the chance to learn about the newest developments in cross-platform transportable tablespace migrations – and there is a lot to talk about.

Virtual Classroom Seminar 18: Cross Platform Migration to the Extreme

Photo by Venti Views on Unsplash

What will be the topics?

We’ll not only discuss but also demonstrate the newest developments and improvements in cross-platform migrations, especially for large and active databases. Learn about the new M5 migration scripts, see them in action – and get an idea …

How to relink Oracle for Enterprise or Standard Edition?

Posted on February 2, 2024 by Mike.Dietrich Installation 14

What a weird blog post. But let me explain briefly the motivation for my Friday article. As you know, the blog serves also as my brain dump. And whenever I try something out I know I may need later again, I dump it here. Certainly, some LLM will pick up the information and spill it out later when you ask the interface about How to relink Oracle for Enterprise or Standard Edition?

How to relink Oracle for Enterprise or Standard Edition?

Photo by Roberta Doyle on Unsplash

From Enterprise to Standard Edition?

Of course, you can. But I had no idea how to when Philippe Fierens, the PM …

Your Upgrade / Migration / Patching Guide for OCW23

Posted on September 18, 2023 by Mike.Dietrich OOW 8

Thanks for using this blog post. It will be your Upgrade / Migration / Patching Guide for OCW23. You will find the slide decks to download, the coming talks, the HOL as well as the survey links and other important sources. We wil update it every day throughout the conference. If you have questions, please use the “Comment” option below the blog post. And we won’t post content BEFORE the session but instead AFTER the sessions.

Your Upgrade / Migration / Patching Guide for OCW23

All you need, day by day

Please find – grouped day by day – each of our talks with the survey links and …

Going to India: Oracle Community Yatra (OCYatra) 2023

Posted on July 17, 2023 by Mike.Dietrich Workshop 2

One year ago I’ve had the pleasure to visit India for the YATRA 2022 tour. I couldn’t do all 6 tour stops and had to skip Delhi and Hyderabad. But this year I will be there for all 6 cities. So I am going to India: Oracle Community Yatra (OCYatra) 2023. And I hope to see YOU there, will I?

Going to India: Oracle Community Yatra (OCYatra) 2023

Why you need to get your ticket NOW?

I guess, most of you in the area have tickets already. Just in case if you didn’t purchase one yet, it’s time to do so. It is not expensive but be …

Oracle Database 19c on Arm platform is available

Posted on July 5, 2023 by Mike.Dietrich Oracle Database 19c Release Schedule 18

I knew it would come – but we couldn’t tell you. And there were some rumors for a longer time. Anyhow, last week at the end of June 2023 Oracle Database 19c on Arm platform is available for download and in the Oracle Cloud. In case you wonder why I write “Arm” – I learned last week that the writing has been changed a while ago from ARM to Arm.

Oracle Database 19c on Arm platform is available

Where can you download it?

It is available for download already.

Oracle Database 19c(19.19) for Linux Arm (aarch64)
- https://www.oracle.com/database/technologies/oracle-database-software-downloads.html#19c
19c Client(19.19) and Instant Client 19c(19.19) for Linux on Arm (aarch64)

Oracle Database World in London – THE event in April 2023

Posted on April 5, 2023 by Mike.Dietrich Conference Workshop 7

You may have heard or seen – or even registered already – for the regional Oracle Cloud World in London on April 19, 2023 already. But were you aware that the “event to be at” happens just the next day on April 20? It will be Oracle Database World in London – THE event in April 2023.

When and where will it happen?

April 20, 2023, a Thursday will be the day to mark in your calendar. We’ll meet you at Oracle Database World, the regional database event to be at in London this year at the …

A patch (RU, OJVM, 32-bit) is not available yet – where will I find information?

Posted on March 7, 2023 by Mike.Dietrich Patch Recommendation Release Schedule 2

A longer while ago I wrote a blog post about the topic that a patch (RU, OJVM, 32-bit) is not available yet – where will I find information? But I wrote it too specific. And it is even hard for me to find my older blog post. Since several of you mailed me the past weeks with a variety of questions regarding patch availability I decided to write down my thoughts – but this time in a more generic way. And I hope it is helpful.

Photo by Vasily Koloda on Unsplash

Why are patches missing?

At first, I …

Oracle Optimizer Statistics Advisor in Oracle 19c

Posted on February 28, 2023 by Mike.Dietrich Flaws and Pitfalls Optimizer Patch Recommendation 22

Christian Pfundtner pointed me to the fact that my old blog post about the Statistics Advisor from 2017 may not be up to date anymore. And he further pointed out that some of his clients still suffer from issues with the tool. Hence, let me refresh the topic with Oracle Optimizer Statistics Advisor in Oracle 19c. And thanks to Christian for the pointers.

Oracle Optimizer Statistics Advisor in Oracle 19c

Photo by Tobias Keller on Unsplash

Overview

At first, I won’t rewrite the entire blog post but instead focus on recent findings. Therefore, you may please want to read my previous blog post about the …

ORA-13516 “CATPROC not valid” during datapatch or autoupgrade to 19.18.0

Posted on February 24, 2023 by Mike.Dietrich Flaws and Pitfalls Patch Recommendation 18

I thought I could relax this week using my leftover vacation days from 2022. But this issue is triggering me since some of you mailed me already. Maybe this blog post can prevent others from being trapped by this issue: ORA-13516 “CATPROC not valid” during datapatch or autoupgrade to 19.18.0. And as a prolog, you will NOT see the below issue when you started your database in NORMAL mode for the execution of datapatch.

ORA-13516 "CATPROC not valid" during datapatch or autoupgrade to 19.18.0

Photo by Greg Rosenke on Unsplash

What is the symptom?

Regardless of whether you patch to Oracle Database RU 19.18.0 manually or with …

Hide and Seek with RU 19.18.0

Posted on February 2, 2023 by Mike.Dietrich Flaws and Pitfalls Patch Recommendation 46

One and a half weeks ago we released the Database and Grid Infrastructure Release Updates (RU) 19.18.0. You could read on the blog how to apply it, and you could read also about an alert. So far, all was more or less transparent but apparently sort of an Hide and Seek with RU 19.18.0 has happened. So let me shed some light.

Photo by Braydon Anderson on Unsplash

Heads Up!

I am just the messenger trying to bring some light into the topic. Neither is our team responsible nor do we have any sort of control on this process. I …

RUs contain now all available DST patches

Posted on January 19, 2023 by Mike.Dietrich Patch Recommendation Time Zone - DST 14

At first, Happy New Year everybody. There was silence on the blog for some weeks but I took an extended longer time off. Well, and once you return, there are some emails in your inbox which need some work. You’ll see several new blog posts getting published in the coming days. Back to normal, yesterday night RU 19.18.0 among other patch bundles has been released. And there’s a huge fantastic surprise in it: RUs contain now all available DST patches.

RUs contain now all available DST patches

Photo by Lukas Blazek on Unsplash

What’s the story?

There are some good news. We discussed this internally …

Database

The patch parameter

Create directories

Download the newest version of AutoUpgrade

Read the official announcements

Why are the April 2026 Release Updates (RUs) 19.31 and 23.26.2 delayed?

1..2..3..4..5..0 …

What is available?

Hands-On-What?

What does this mean?

New Features in RUs?

What has been updated?

Sign-up quickly

JDK in the Oracle Home

What will be the topics?

From Enterprise to Standard Edition?

All you need, day by day

Why you need to get your ticket NOW?

Where can you download it?

When and where will it happen?

Why are patches missing?

Overview

What is the symptom?

Heads Up!

What’s the story?

Archives

Categories

Upgrade @YouTube

Subscribe via Email

Recent Posts