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 writing. But in case you read this in a few months, it may be 19.12.0 or 19.13.0 or even newer.

And here comes our first MOS Note tip into play – the Download Assistant. With this note you quickly access the newest patch bundles for the Database and for Grid Infrastructure.

MOS Note: 2118136.2 – Assistant: Download Reference for Oracle DB/GI Release Update, Revision, PSU, SPU(CPU), etc.

In addition, this MOS Note gives you an overview on the patching itself but lists also the dates and other information about patch availability:

MOS Note: 888.1 – Master Note for Database Proactive Patch Program

Are there Known Issues with this RU or RUR?

In every Release Update’s (and Revision’s) README there is a link to Known Issues. Please don’t forget to check it. It is typically listed under %. Critical Issues. In the 19.11.0 RU case for example, find it here:

MOS Note: 19202194.9 – Oracle DB/GI/OJVM Update/Revision R19 Apr 2021 Known Issues (19.11.0)

In addition, in the README itself under the same chapter 5, Critical Issues, you may find other issues happening during patch apply.

But why do you need extra patches?

Now the question you may ask yourself: When I already used the most recent Release Update, for instance at the moment 19.11.0, why do I need extra patches on top of it?

There is always a chance that an important fix (or more than one) are not present in this Release Update.

The fix didn’t make it into the RU because of code freeze timelines
The fix is not eligible for a patch bundle which has to be “RAC Rolling” – this is often the case for fixes changing the common API – Data Pump or Real Application Testing fixes are common examples
The fix is scheduled for inclusion into a later Release Update
The issue is simply too new or got introduced with this Release Update – we call this a regression

Therefore, you may consider some extra sources. And currently those are not linked together in all cases.

Let me start with the first one as it lists the most critical issues:

MOS Note: 555.1 – Oracle Database 19c Important Recommended One-off Patches

Applying fixes listed in this MOS note is almost a must before you patch or upgrade.

But there are more notes to take care on.

Performance, Wrong Results and SPM

Of course, everybody wants to learn about specific performance issues, wrong result topics and not to forget, SQL Plan Management.

Grid Infrastructure

In case you use Grid Infrastructure, this note is coming to my mind as something you may want to check as well:

MOS Note: 2669766.1 – How to Upgrade to/Downgrade from Grid Infrastructure 19c and Known Issues

Data Pump

In addition, Sven recommended this note for Data Pump:

MOS Note: 453895.1 – Checklist For Slow Performance Of DataPump Export (expdp) And Import (impdp)

GoldenGate

And another recommendation by Sven for those of you using Oracle GoldenGate:

MOS Note: 2193391.1 – Latest GoldenGate/Database (OGG/RDBMS) Patch recommendations

You know other important notes?

Of course, we don’t claim that this is a complete collection. Nor do we dictate you’ll have to look at all of them. But if you have tips for other very important notes to check before you upgrade or patch, please let us know via the comments section.

And just on the side, there is a reason why I didn’t include MOS Note: 2539751.1 – Patches to apply before upgrading Oracle GI and DB to 19c or downgrading to previous release. In our opinion, this note is very misleading, especially regarding the database patches. And it hasn’t been updated for over a year.

Summary of all links listed in this blog post

–Mike

GI Patch 28553832 may be needed before you upgrade to 19c

Thanks to my colleague Sebastian Alasino who works in the MAA team out of the UK. Sebas highlighted this issue to. And I'd like to share it with you when you attempt to upgrade Grid Infrastructure to Oracle 19c. If you have the Docker RPM installed and you were lazy…

January 7, 2020

Patching all my environments with the October 2020 Patch Bundles

I have to confess: Time didn't allow to rearrange my lab yet to have GI and ASM. Hence, this will be another blog post about Patching all my environments with the October 2020 Patch Bundles with only non-RAC patching. But it is in the works ... As usual, an important…

October 22, 2020

Bug Fixing Support for Oracle 18c ends June 30, 2021

Time flies so quickly. I remember when we had intense discussions with a very large automotive customer whether they should use Oracle 18c, or rather wait for Oracle 19c. They went straight to Oracle 19c. But I know that many customers out there are still on Oracle 18c. So this…

June 10, 2021

Some very important MOS Notes when you upgrade and patch