19c

Why is the fix for bug nnn not included in any RU?

Christian asked this question today. Specifically, in his case for Bug 26749785 – PERF_DIAG: NEED TO HAVE MORE CONTROL IN DICTIONARY FOR AUTO_STATS_ADVISOR_TASK. Several of his customers suffer from this issue, and they repeatedly need to ask for backports or merge patches. I have seen this several times as well. Anyway, he is not only one who asked: Why is the fix for bug nnn not included in any RU?

Why is the fix for bug nnn not included in any RU?

Photo by Priscilla Du Preez 🇨🇦 on Unsplash

Inclusion criteria

In order to be able to include a bug fix into an MRP, CSPU or RU, it has to be …

GI 19.31 and 19.32: trace file flooding in mgmtca.trc can happen

Posted on September 4, 2026 by Mike.Dietrich ASM / RAC / GI Flaws and Pitfalls Oracle Database 19c 0

Thanks to Peter Lehmann who always alerts me about findings and encounters he had in his test and production RAC cluster environments. Peter dropped me an email the other day, and I share his suspicion that this may effect many in the coming weeks operating RAC environments. If you don’t have a RAC, you may not see this happening with GI 19.31 and 19.32: trace file flooding in mgmtca.trc can happen.

GI 19.31 and 19.32: trace file flooding in mgmtca.trc can happen

Photo by Giovanna Gomes on Unsplash

What happens?

It took me a bit of searching, and Peter collected a lot of information already.

Two months after patching GI …

Can I apply an RU to a home with an MRP?

Posted on September 2, 2026 by Mike.Dietrich Patch Recommendation 0

This question came up by a customer, and it was referring to the FAQ MOS note for MRPs. In brief, it was stated that you could apply a higher RU into a home where an MRP up to MRP3 had been installed in the previous home. So the question raised to me was: Can I apply an RU to a home with an MRP as it was mentioned in the FAQ document?

Can I apply an RU to a home with an MRP?

Photo by Liana S on Unsplash

Which note, and what’s the statement?

The FAQ2283 – Introducing Monthly Recommended Patches (MRPs) and FAQ stated the following under Q18:

Q18:

How to rollback an MRP

Posted on September 1, 2026 by Mike.Dietrich Oracle AI Database 26ai Oracle Database 19c Patch Recommendation 0

You know, I am not a fan of in-place patching. Actually, I think everyone should always patch out-of-place. But I know that for instance EBS with a 19c database requires in-place patching, and out-of-place will be supported only with 26ai for EBS. Therefore, in relation to an exercise I did over the weekend, let me share how to rollback an MRP.

Photo by Darío Bonzi on Unsplash

What is an MRP?

Very briefly, it stands for Monthly Recommended Patch – thus MRP. And it co-exists with CSPUs. I described the difference here. Read more if you are interested.

CPU, CSPU,

LAOUC 2026: Paraguay, Brazil and Uruguay

Posted on August 18, 2026 by Mike.Dietrich User Groups Workshop 0

In a week from now I should arrive in Asuncion, Paraguay, if all goes well. It it time for the Latin America Oracle User Group tour 2026 – and it has been started already going from north to south. I will participate in three stops at LAOUC 2026: Paraguay, Brazil and Uruguay. And I am looking forward to see you soon.

Paraguay

🇵🇾 August 26 | Paraguay | Oracle Users Group Paraguay (OUGPY)

Yeah, you beat us Germans at the world cup, and luckily, I did not watch it since I was traveling abroad. Congratulations 🙂 In reverse, I …

CDB upgrades – explaining catctl_options

Posted on July 13, 2026 by Mike.Dietrich AutoUpgrade catctl.pl Oracle AI Database 26ai Oracle Database 19c Performance Tuning 0

When you upgrade your entire CDB with AutoUpgrade, there is a parameter which allows you some tuning or tweaking. And I often see some misunderstanding here. Therefore, for CDB upgrades – explaining catctl_options is my focus today.

CDB upgrades - explaining catctl_options

Photo by Arthur Mazi on Unsplash

catctl_options – what it is meant for

This AutoUpgrade config file parameter allows you to set specific settings, mostly for tuning, but also to override some defaults. In the documentation you will find the whole list of options. You can set it in your AutoUpgrade config file, e.g.:

upg1.catctl_options=-T

catctl_options in CDB upgrades

Here, …

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

Posted on July 9, 2026 by Mike.Dietrich AutoUpgrade Oracle AI Database 26ai Oracle Database 19c Patch Recommendation 7

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 3: Download Patches

Posted on July 8, 2026 by Mike.Dietrich AutoUpgrade Oracle AI Database 26ai Oracle Database 19c Patch Recommendation 38

You completed Part 1 and Part 2 of this blog post series already? Then you are ready for AutoUpgrade Patching – From Zero to Hero – Part 3: Download Patches. Let us start simple, and then increase the scope to fetch the patches for various operating system platforms in your local patching folder.

AutoUpgrade Patching - From Zero to Hero - Part 3: Download Patches

Which download?

Strange headline – but you’ll see what I mean. At first, we need to clarify the various download options for patches.

Download patches directly from MOS/ARU by yourself
This usually means that you go to the various MOS notes, such as KB106822 /

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 …

How to deal with statistics when you migrate?

Posted on June 11, 2026 by Mike.Dietrich Oracle AI Database 26ai Oracle Database 19c SPA - SQL Performance Analyzer Statistics Workshop 0

Have you done migration projects in the past, or do you have some upcoming projects, and you wonder how you should treat all sorts of statistics in your database? What is the better option? Keep and migrate the existing ones? Regather them right away? A partial-move approach? How to deal with statistics when you migrate? Then this is for you. Sign up to our next Virtual Classroom Seminar on Thursday, June 18 at 14:00h CEST: Statistics and Migrations – Well-Kept Secrets Revealed

How to deal with statistics when you migrate?

Photo by Mika Baumeister on Unsplash

What’s the topic?

Statistics and Migrations – Well-kept Secrets Revealed…

CPU, CSPU, MRP, RU – some clarifications

Posted on June 9, 2026 by Mike.Dietrich Oracle AI Database 26ai Oracle Database 19c Patch Recommendation 24

I just returned from a 2 week vacation in Asia this weekend. And I was following from a distance. On May 28, the first CSPUs got released, some MOS notes got published. There are a lot of patching options now. CPU, CSPU, MRP, RU – some clarifications may be needed.

CPU, CSPU, MRP, RU - some clarifications

Photo by Daniel Salcius on Unsplash

The Prelude

On May 4, 2026, I published this blog post Patch your database against AI cybersecurity threads following these two announcements:

DBMS_OPTIM_BUNDLE – what it shows, and what oradiff lists

Posted on May 26, 2026 by Mike.Dietrich Optimizer Oracle AI Database 26ai Oracle Database 19c ORAdiff Parameters 2

I blogged multiple times about DBMS_OPTIM_BUNDLE, the package to work with the Fix Control Persistence (FCP) framework in the database. And we also gave recommendations over the years that you need to test carefully when you are going to enable the fixes while patching. But it is a good practice do enable them when you do upgrade testing, and also when you start creating new databases in a new environment. Just make sure you keep the settings equal across your environments. The other day I received a question from Dennis asking about DBMS_OPTIM_BUNDLE – what it shows, and what oradiff …

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,

Upcoming in-person workshops in Düsseldorf, London, Vienna, Utrecht and Brussels

Posted on March 26, 2026 by Mike.Dietrich Workshop 0

I am ready to take off for some vacation soon. But I’d like to share with you a list of the upcoming workshops we are offering. All those events are in-person events – except the Virtual Classroom Seminar I will list below. Therefore, you need to show up at the day of the event. Zero marketing, no duplication of content either. See you soon in one of the upcoming in-person workshops in Düsseldorf, London, Vienna, Utrecht and Brussels.

Upcoming in-person workshops in Düsseldorf, London, Vienna, Utrecht and Brussels

Workshops and Events in April / May 2026

It is very important to say that we aren’t duplicating content. This …

OCW 19.28 contains a tiny behavior change with DB_UNIQUE_NAME

Posted on March 18, 2026 by Mike.Dietrich Behavior Change OCW 0

A colleague brought this to my attention the other week. And since the blog serves also as my partial memory, I wanted to put this out quickly. It is not a big deal, and most of you will never see this or be affected by it. Still, some may need to be aware that OCW 19.28 contains a tiny behavior change with DB_UNIQUE_NAME.

OCW 19.28 contains a tiny behavior change with DB_UNIQUE_NAME

Photo by Anton Ryazanov on Unsplash

What has happened?

In the Oracle Clusterware (OCW) Release Update (RU) 19.28 and onward you will find a fix for Bug 34966087 – AH: CRS: FAIL START ACTION IF DB …

Does AutoUpgrade support the MOVE option?

Posted on March 17, 2026 by Mike.Dietrich AutoUpgrade Single-/Multitenant 4

Sometimes you have different plans for the day. Or, in my case, the day just needs a few extra hours. Today, I received a very interesting question on the blog at first by a customer I know very well. Then we exchanged mails – and I was caught forgetting what I wrote on the blog a longer while ago. The core question is: Does AutoUpgrade support the MOVE option? But there was much more to discuss and figure out as you can read below.

Does AutoUpgrade support the MOVE option?

Photo by Arron Choi on Unsplash

Which options does AutoUpgrade offer?

The case here is …

Sign up for the next Virtual Classroom Seminar: Patch Smarter, Not Harder

Posted on March 9, 2026 by Mike.Dietrich Workshop 2

Some of you may have realized: We moved the Virtual Classroom Seminar #27 from its original date in February to March 12 this week. Usually we don’t do this – but we ended up with so much content. If you haven’t already, it is time for you to sign up for the next Virtual Classroom Seminar: Patch Smarter, Not Harder.

Photo by Moritz Mentges on Unsplash

What are we going to talk about?

Database Patching – with or without RAC or Data Guard. With demos, as usual.

The idea is that you may learn a lot. And of course, …

Don’t use AI to build your AutoUpgrade config file, please!

Posted on February 13, 2026 by Mike.Dietrich AutoUpgrade Oracle AI Database 26ai Oracle Database 19c Upgrade / Migration 4

Let me do a quick Friday rant. Many of you can easily ignore this. But regardless of whether you are a colleague, a friend, a customer, a partner or just exploring AutoUpgrade because it is the coolest small tiny little tool Oracle has to offer, don’t use AI to build your AutoUpgrade config file, please!

Don't use AI to build your AutoUpgrade config file, please!

Photo by Enchanted Tools on Unsplash

AI models are great … somehow …

No worries, I use AI tools as well, especially when I need to create some complex PL/SQL scripts. There is nothing wrong with it – unless you stay in control. I …

OJVM patching fails with ORA-1403 in 19.30 if JAVAVM is not installed

Posted on February 12, 2026 by Mike.Dietrich Flaws and Pitfalls JVM Patch Recommendation 106

Thanks to all the people (Jeff, Daniele, Lothar and others) who alerted me about this topic. Some of you had even created their own fix already. So, this is about an issue which happens only if you have no JAVAVM installed in your database or PDB but you still apply the OJVM Bundle on to of the Oracle Database 19.30 Release Update. You may find then: OJVM patching fails with ORA-1403 in 19.30 if JAVAVM is not installed.

OJVM patching fails with ORA-1403 in 19.30 if JVM is not installed

Photo by Michiel Leunens on Unsplash

When does this happen?

This issue happens when you apply the OJVM bundle together with …

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 …

What has happened to the 19.29 and 19.30 RUs?

Posted on February 9, 2026 by Mike.Dietrich Flaws and Pitfalls Oracle Database 19c Patch Recommendation 44

Many of you mailed us asking why AutoUpgrade does not download 19.29 or 19.30 RUs anymore. Others just noticed that the RUs got pulled without further communication visible. And a few people informed me about an issue with the 19.30 RU when you don’t have OJVM configured but install the OJVM bundle. So, what has happened to the 19.29 and 19.30 RUs??

What has happened to the 19.29 and 19.30 RUs?

Photo by Lukas Seitz on Unsplash

Release Update 19.29 and 19.30

A fix for Bug 34352668 – LNX64-23.1-RAC: SVCB HIT ORA-600 [KCBGTCR_17] has been included into RUs 19.29 and 19.30 but unfortunately it could potentially cause a regression…

How do you check whether a list of bug fixes is included in an RU?

Posted on February 5, 2026 by Mike.Dietrich ORAdiff Patch Recommendation 6

Today, a customer sent me a workaround for the misbehavior they were seeing with the Conflict Checker Tool in the Support portal. They use oradiff to check whether a given fix they have a one-off right now is included in a future Release Update (RU). This works nicely, but I have a recommendation for an even easier check (thanks Rodrigo!).

How do you check whether a list of bug fixes is included in an RU?

Photo by Charlotte Wurch on Unsplash

Ask ORAdiff …

I am using this specific customer case as an example. Of course, this will work with your list of fixes as well. Let’s assume that this is the list of one-off …

Upgrade Workshops in Copenhagen, Munich and Berlin

Posted on January 26, 2026 by Mike.Dietrich Oracle AI Database 26ai Workshop 4

Your chance to sign up NOW! We are going to run Full Day Oracle AI Database 26ai Upgrade Workshops in Copenhagen, Munich and Berlin. And this is NOT a repeat – it is the 2nd edition of the workshop you may have attended last year in spring with brand-new content, new features.

As usual, zero marketing – just tech!!

Photo by Denis Linine on Unsplash

When?

Copenhagen: Tuesday, Jan 27, 2026
- 9:00h – 16:30h
- Scandic Sydhavnen – Sydhavns Plads 15 – 2450 Copenhagen
  .
Berlin: Monday, Feb 2, 2026
- 9:00 – 16:30h
- Oracle Office – Invalidenstrasse 65 –

Finally … Oracle AI Database 26ai is going to be available on non-Oracle hardware

Posted on December 3, 2025 by Mike.Dietrich Oracle AI Database 26ai 65

Many of you have read my blog post from October during Oracle AI World in Las Vegas about Oracle AI Database 26ai replacing Oracle Database 23ai. But the main question remained: When is it available on-prem on non-Oracle hardware? It’s December now, and Christmas is coming soon, it is time for presents. Yes, finally … Oracle AI Database 26ai is going to be available on non-Oracle hardware.

Finally ... Oracle AI Database 26ai is going to be available on non-Oracle hardware

Photo by JOHN TOWNER on Unsplash

When is it going to be released?

You still need to wait a few weeks, potentially until the 2nd half of January 2026. The CPU …

19c

Inclusion criteria

What happens?

Which note, and what’s the statement?

What is an MRP?

Paraguay

catctl_options – what it is meant for

catctl_options in CDB upgrades

The patch parameter

Which download?

Create directories

Download the newest version of AutoUpgrade

What’s the topic?

The Prelude

Read the official announcements

Workshops and Events in April / May 2026

What has happened?

Which options does AutoUpgrade offer?

What are we going to talk about?

AI models are great … somehow …

When does this happen?

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

Release Update 19.29 and 19.30

Ask ORAdiff …

When?

When is it going to be released?

Archives

Categories

Upgrade @YouTube

Subscribe via Email

Recent Posts