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.
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.
In addition, this MOS Note gives you an overview on the patching itself but lists also the dates and other information about patch availability:
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:
In addition, in the README itself under the same chapter 5, Critical Issues, you may find other issues happening during patch apply.
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.
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:
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.
Of course, everybody wants to learn about specific performance issues, wrong result topics and not to forget, SQL Plan Management.
In case you use Grid Infrastructure, this note is coming to my mind as something you may want to check as well:
In addition, Sven recommended this note for Data Pump:
And another recommendation by Sven for those of you using Oracle GoldenGate:
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.
–Mike
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…
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…
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…
联系客服
