rollback

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

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,

Does OJVM patching fail again with ORA-1403 in 19.31?

Posted on May 15, 2026 by Mike.Dietrich JVM Patch Recommendation 8

Some of you had been trapped by ORA-1403 during patching to Oracle Database 19.30. I blogged about this in February this year, and I had to update the blog post a few times until we collected all the issues. The root cause got fixed and included in Release Update 19.31. But over the past days I received a good number of messages about the issue being there in 19.31 again. So, does OJVM patching fail again with ORA-1403 in 19.31?. Yes, and no.

Does OJVM patching fail again with ORA-1403 in 19.31?

Photo by Towfiqu barbhuiya on Unsplash

Why do some see the error again?

First of …

Should you attempt double-hop Oracle Database upgrades?

Posted on December 13, 2024 by Mike.Dietrich Lifetime Support Policy Oracle Database 19c Oracle Database 23ai Release Schedule 6

A long while ago I wrote a blog post about multiple-hop upgrades. And just recently I received many questions about whether one could skip Oracle Database 19c, and rather move into Oracle Database 23ai directly. So, the ask is: Should you attempt double-hop Oracle Database upgrades?

Should you attempt double-hop Oracle Database upgrades?

Photo by Nik on Unsplash

What is a double-hop or multiple-hop upgrade?

Let me clarify the self-invented term here at first. In every Oracle database release we define the minimum database version you can directly upgrade from. With “upgrade” we refer to using the scripts or tools such as AutoUpgrade. Please …

More about cleaning up datapatch patching files

Posted on September 30, 2024 by Mike.Dietrich Patch Recommendation 10

One of the reasons why I love my job: We have the smartest customers out there. Incredible. When I blogged the other day (after a longer pause) about Cleanup datapatch patching files in your database some of you commented the other day with either success messages, or tried out to rollback – or simply missed steps in the README. And since we have also smart developers at Oracle, I received some additional facts from the datapatch architect which I let him explain below.

More about cleaning up datapatch patching files

Photo by Brian Yurasits on Unsplash

The README file

Well, Devin commented on the previous blog post…

datapatch stores rollback patching files in the database

Posted on January 17, 2024 by Mike.Dietrich Patch Recommendation 29

I held back this blog post for a longer while. A customer (Thanks Jannes!) reported this to me many months ago but the fix was not as trivial as we thought initially, and there were several unlucky circumstances delaying it multiple times. But now it is time to tell you how datapatch stores rollback patching files in the database. And of course, how to cleanup.

datapatch stores rollback patching files in the database

Photo by Pawel Czerwinski on Unsplash

Why is this important?

At first, you may ask yourself: Why should I care? And you are right. This is normally nothing you should care about. …

The downsides of in-place patching – and a patching lab

Posted on January 10, 2024 by Mike.Dietrich Best Practice Patch Recommendation 40

Happy New Year to all of you at first. I hope you all had a good start – and for myself, I promise to blog a bit more again in 2024. Let me start with my first post since I received a question very often: Why should I patch out-of-place with a new Oracle Home? Since I need to patch a bit today I can easily show the downsides of in-place patching – and a patching lab.

The downsides of in-place patching - and a patching lab

Photo by Cederic Vandenberghe on Unsplash

It all started at OCW 2023

Ok, we didn’t really start it at OCW 2023 in …

Can I cleanup the previous Patch Bundles with opatch?

Posted on January 21, 2022 by Mike.Dietrich Best Practice Patch Recommendation 36

Addition May 16, 2023:

Before you read on, better jump to this blog post. With opatch 37, released in April 2023, a cleanup option is available – and this significantly improves performance:

Cleaning up older patch artifacts – and improve opatch performance

Today I will step on mined territory. Can I cleanup the previous Patch Bundles with opatch? Or can I just wipe out the old ones? That is a question which will bring people with temper quickly close to explosion. But let me start step by step, especially for those of you who aren’t familiar with this topic.…

Virtual Classroom Seminars 10-12: Videos and Slides are available

Posted on December 13, 2021 by Mike.Dietrich Workshop 0

Thanks to all of you for participating in our last 3 web seminar session. And since some of you had to leave earlier in one of the Virtual Classroom Seminars 10-12: Videos and Slides are available for download and on-demand viewing.

Virtual Classrom Seminar - Migrating Large Databases

No registration is required – you can watch all of our seminars anytime.

And as usual, our workshops are free of buzz words and explain only technical topics. The presenters Roy Swonger, Daniel Overby Hansen, Rodrigo Jorge, Bill Beauregard and myself, we all love to talk about technical topics, show and share demos and put …

Virtual Classroom Seminar: Fallback Is Your Insurance – on Nov 11, 2021

Posted on November 10, 2021 by Mike.Dietrich Workshop 4

No worries, I haven’t become lazy recently. But the past weeks were more busy than anything I have experienced so far. And I had a full week off and enjoyed the silence and absence from blogs and cell phones and email in the mountains. But now I’m back – and surprise, surprise – this week on Thursday we’ll have our 11th Virtual Classroom Seminar: Fallback Is Your Insurance – on Nov 11, 2021.

Fallback Seminar

When will it happen?

Thursday, Nov 11, 2021 – 10:00h CET

What are we going to talk about?

Fallback and Rollback. How to secure your job. …

The newest patching surprises – and how to fix some of them

Posted on September 4, 2019 by Mike.Dietrich Patch Recommendation 19

Well, there is no Product Manager for patching. And I’m glad that I’m not in this position. But thanks to all of you, internally and externally, who share your findings with me. In this blog post I’d like to inform you about the newest patching surprises – and how to fix some of them.

The newest patching surprises - and how to fix some of them

Patch apply without confirmation?

Peter Lehmann informed me about this a few weeks ago. Peter told me that he patched systems with the July 2019 RU for Oracle 12.2.0.1 and recognized that the patch installed with opatch without waiting for confirmation. It looked as somebody has …

Can I apply a BP on top of a PSU? Or vice versa? PART 2

Posted on October 4, 2016 by Mike.Dietrich Patch Recommendation 4

I thought I won’t blog about this again:

Can I apply a BP on top of a PSU? Or vice versa?

But then a colleague of mine raised this simple question:

“I have a customer that would like to change from patching using PSU to patching using Bundle Patch. I am
wondering what happens if my home has had several PSUs installed. Before applying a BP, would I need to rollback one by one all the PSUs that have been installed in reverse order (tedious) OR only the latest PSU (good)?”

Unfortunately the “simple” solution is hidden deep down in …

rollback

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

Which note, and what’s the statement?

How to rollback an MRP

What is an MRP?

Does OJVM patching fail again with ORA-1403 in 19.31?

Why do some see the error again?

Should you attempt double-hop Oracle Database upgrades?

What is a double-hop or multiple-hop upgrade?

More about cleaning up datapatch patching files

The README file

datapatch stores rollback patching files in the database

Why is this important?

The downsides of in-place patching – and a patching lab

It all started at OCW 2023

Can I cleanup the previous Patch Bundles with opatch?

Virtual Classroom Seminars 10-12: Videos and Slides are available

Virtual Classroom Seminar: Fallback Is Your Insurance – on Nov 11, 2021

When will it happen?

What are we going to talk about?

The newest patching surprises – and how to fix some of them

Patch apply without confirmation?

Can I apply a BP on top of a PSU? Or vice versa? PART 2

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts