Patching all my environments with the April 2022 Patch Bundles

Easter time is patching time. And since I was hiking and biking every day the last week up in the Northern Italian mountains, this blog post is coming with a slight delay. But better late than never. Time to show you my usual exercise, this time Patching all my environments with the April 2022 Patch Bundles.

As usual, an important annotation upfront: I patch in-place due to space issues. But in reality, you please patch always out-of-place with a separate home. Please see this blog post about how to apply the RU

Continue reading...

New AutoUpgrade version 20211115 (Nov 2021) available for download

Yesterday at DOAG conference I announced it already in our Upgrade and Migration Round Table – and just a few hours later my team mates made the New AutoUpgrade version 20211115 (Nov 2021) available for download.

How to download AutoUpgrade?

Always download the most recent version of AutoUpgrade via MOS Note: 2485457.1 – AutoUpgrade Tool.

Just click on this link in the MOS Note:AutoUpgrade Nov 2021

Why do you need a new version?

A good number of issues being logged to us via blogs, tweets, SRs and eMails can be solved with the current …

Continue reading...

Some very important MOS Notes when you upgrade and patch

Today, I would like to publish only a short blog post with some hints to MyOracle Support (MOS) notes we find quite helpful. The idea of all these notes I will list below is to help you finding the right patches before you upgrade or patch to Oracle 19c. So see our collection of Some very important MOS Notes when you upgrade and patch below.

Why do you need patch bundles?

At first, it is always our recommendation to upgrade to the most recent Release Update (RU). This is currently Oracle 19.11.0 while I’m …

Continue reading...

This MOS note is not available anymore??!?

Let me craft a very short Tuesday evening blog post as this happened quite often to me. We promote a MOS note, either via our blogs or in our Virtual Classroom seminars and workshops. And when you try to access it, the note is gone. Plus, MyOracle Support (MOS) gives you no indication why it has disappeared or what has happened.

One of the many cases …

Chris commented on the blog here saying:

Hello Mike,

Unfortunately document “MOS Note: 2720807.1 – Oracle Database 19c Important Recommended One-off Patches” is not available anymore as

Continue reading...

Why do you need a password to download older patch bundles?

A customer raised this question recently: Why do you need a password to download older patch bundles? The customer wanted to download a PSU from July 2020 on the MyOracle Support (MOS) platform but this wasn’t possible without a password.

Why do you need a password to download older patch bundles?

Photo by Privecstasy on Unsplash

Why is there an extra password required?

In MOS Note: 888.1 – Master Note for Database Proactive Patch Program we documented the following:

1.4 Policy to obtain older Oracle Database Bundles, Updates & Revisions

Through our review of customer Service Requests (SRs), we find that customers frequently run into issues because they have unknowingly downloaded

Continue reading...

Why is the 19.9.0 Release Update not available yet for MY platform?

I’ve had a week off and tried to relax and stay away from work topics (which worked quite well this time). The downside is 300+ emails in the inbox. And I spotted several ones already asking: Why is the 19.9.0 Release Update not available yet for MY platform?

Details for Patch 123456789 not found.

At first, this is not a uncommon question. And the root cause is two-fold. As you know from my quarterly blog posts such as Patching all my environments with the October 2020 Patch Bundles, these notes are important:

Continue reading...

datapatch and OPatch documentation and MOS note

Did you ever ask yourself whether there is documentation available for OPatch and for datapatch? It is not easy to find. And you won’t find it under “Database” in the Oracle Bookshelf. So today I would like to guide you in this short blog post to the datapatch and OPatch documentation and MOS note.

OPatch? Datapatch?

Just to recap: You use OPatch (or opatchauto) to apply the binaries to an Oracle installation. As a result, you change the second or the third number of the release from Oracle 19.5.0 to Oracle 19.8.0. But …

Continue reading...

Oracle – Clarification for Limited Error Correction Support

A few weeks ago, you read the announcement of the availability of Limited Error Correction Support for Oracle Database But many of you had some questions right away. I could answer most of them easily. But it was clear to us that there was more information needed. Hence, we published more information for Oracle – Clarification for Limited Error Correction Support.

Oracle - Clarification for Limited Error Correction Support

Photo by Alfred Aloushy on Unsplash

What has been announced in April 2020?

Just a few weeks ago we announced the availability of Limited Error Correction Support for Oracle after November 2020. You could find …

Continue reading...

List of PREUPGRADE checks executed by preupgrade.jar

List of PREUPGRADE checks executed by preupgrade.jar

Most of you may not care about the checks our Pre Upgrade Check tool preupgrade.jar does. But some may. Especially in cases where you plan to run a command line upgrade unattended via a script. Therefore this List of PREUPGRADE checks executed by preupgrade.jar may help you.

List of PREUPGRADE checks executed by preupgrade.jar

As a result of a joint initiative between our Upgrade Development team and the Support group dealing with upgrade-related SRs we released this MOS Note:

Purpose of the new MOS note is to give you a complete list …

Continue reading...

Download Assistant for RUs, RURs, BPs, PSUs, Patch Sets and Releases

How often did I launch a search in MyOracle Support (MOS) for a specific Bundle Patch or Patch Set Update. And usually the MOS search results don’t get me what I’m looking for no matter how clever I search. But there was relief. A MOS Note combined all PSUs and BPs and much more into table format including the links. But what if there would be a Download Assistant for RUs, RURs, BPs, PSUs, Patch Sets and Releases?

I did blog about the previous magic note a while back:
Where is the Jan 2017 PSU for Oracle Database

Continue reading...

Proactive Bundle Patches – Change reflected now in MOS as well

Now the Known Isuses and Alerts and Recommended Patches Notes in MOS reflect the naming and classification change of the different types of patches as well.

See in:

MOS Note:1683799.1 – Patch Set – Availability and Known Issues

We don’t speak about Bundle Patches for Exadata and DBIM anymore making it easier to find the correct patch for your platform.

Just wanted to share this as I’m refreshing our upgrade slide deck at the moment 🙂


Continue reading...

MOS Note 1454618.1: Quick Reference to Database PSUs, CPUs, BPs and Patchsets

Sometimes my mouse arm gets tired by clicking myself through MOS notes just to download a specific PSU or BP – and as I experiment a lot with PSUs and BPs right now I clicked a lot in the past days and nights.

Usually I’d start with either MOS Note:161818.1 – then click on the release link (e.g. 12.1.0.x) in the left-most column, then into the Availability and Known Issues not (e.g. MOS Note:1683799.1 for Oracle Database and then select the most recent patch from the list of Current Recommended Patches.

Even though we all agree that you should

Continue reading...

Oracle April 2016 PSU and Proactive BPs are there

Hurray, it’s Patching Day!

Sounds a bit like D-Day 😉 But April 19, 2016 the most recent April PSUs (Patch Set Updates) and BPs (Bundle Patches) got released.

Find all the necessary information with the below links:

The important change in the April PSU/BP release:
The database patch for “Engineered Systems and Database In-Memory” luckily got renamed into “Proactive Bundle Patch”. That is not only a rebranding but it should express that we would like to encourage you to apply the Bundle Patches

Continue reading...

Tech Tip: Get updates about new/important MOS Notes

There’s nothing more annoying than unwanted and useless email newsletters in your inbox.

No doubt.

But sometimes I wish to have an alert about important MOS Note changes, recent additions to my favorite notes, updates to the bugs I monitor etc. I would like to know about helpful new MOS articles – when they get published 😉

And this is what you need to do (and I’ll have to apologize for the small pictures but our fancy, modern blog design template does not allow to include larger pictures …).

Log into MOS and change your SETTINGS

Once you’ve …

Continue reading...

MOS Download for Oracle Database including SE2

Please find all our articles about Oracle Database Standard Edition SE2:


You have 3 options to download Oracle Database Enterprise Edition and Oracle Database Standard Edition SE2.

Regarding OTN and eDelivery nothing …

Continue reading...

New MOS Note:1962125.1 – Overview of Database Patch Delivery Methods

Usually I don’t announce MOS Notes but this one may be very helpful to sort out between all the different patches available these days for the database only. From Patch Sets to PSUs to SPUs to Interim Patches to Bundle Patches and so on.

Plus it includes also recommendations for testing and if you should apply them on a regular basis.

A very important MOS Note for most DBAs:

MOS Note:1962125.1
Overview of Database Patch Delivery Methods

MOS Note - Patch Delivery Methods


Continue reading...

New MOS Notes on Database Upgrades for 12c with or without Oracle Multitenant

Please find some new MyOracle Support (MOS) Notes about Database Upgrades to Oracle Database 12c, with or without Oracle Multitenant:

Credits for the CDB/PDB Notes go to

Continue reading... Pre-Upgrade Script Now Available!

It took a little while because of upgrades to My Oracle Support, but the pre-upgrade script for Oracle Database is now available for download. If you want the latest pre-upgrade script for any supported version of the database, simply go to MOS Note 884522.1 and download the script that corresponds to your destination release. This is a lot easier than downloading the entire kit in order to obtain the script!…

Continue reading...

Database Upgrade: Most important Support Notes Oracle

It’s been a while … sorry for not updating the Blog this frequently in the past weeks 😉

But now I’m back in business and today I’m updating our major slide set with some new stuff. And while I’m updating it I thought about what would be the most important MOS (My Oracle Support) Notes on Database Upgrades.

Actually I would say you should start here – and these Notes should guide you to the most important bits and pieces around upgrades. I won’t claim that this is THE final list so you might have a look into our comprehensive …

Continue reading...

Database Upgrade Troubleshooting Tool

Support recently released a new helpful tool to diagnose upgrade issues post upgrade:
The Database Upgrade Troubleshooting Tool.
You’ll access it via MOS Note:559339.1 and click on the top link in the middle column:

MOS Note:559339.1

The guided workflow has three steps:
1) Describe Problem
2) Upload Files
3) Review Recommendation

Describe Ugrade Problem

Once you have uploaded the upgrade diag log, the upgrade log, alert.log and maybe other things per request of the troubleshooting assistant you should see helpful recommendations.

Try it out if you encounter any issues during database upgrade.…

Continue reading...