Well, in my new role as unofficial Junior Product Manager for Patching (just kidding) I get asked once a day (at least!) via email or in customer meetings or workshops: Should we take the PSUs or the BPs? Or RUs or RURs?
Addition: I updated the blog post due to the arrival of the RUs and RURs in Oracle Database 126.96.36.199.Changes are marked in orange.
Should we take the PSUs or the BPs? RURs or RUs?
PSUs are Patch Set Updates, BPs are (sometimes called: Proactive) Bundle Patches.
RUs are Release Upgrades which replace the BPs in Oracle Database 188.8.131.52, RURs are Release Upgrade Revisions which DON’T replace the PSUs in Oracle Database 184.108.40.206.. And this is important – Revisions are different from PSUs.
PLEASE SEE: https://mikedietrichde.com/2017/10/24/differences-psubp-rurur/
And the answer is very simple:
- If you have an Oracle Engineered System: Take the Bundle Patches for Engineered Systems
- In all other cases:
- If you are on Oracle Database 220.127.116.11 or newer: Take the Upgrades (RU)
- If you are on Oracle Database 12.1.0.x: Take the Bundle Patches (BP)
- If you are on Oracle Database 18.104.22.168: Take the Patch Set Updates (PSU)
- If you are on a release below Oracle Database 22.214.171.124: Upgrade!
Is there an official recommendation or guideline?
Yes, of course, there’s one. Very well explained in MOS Note: 1962125.1 – Overview of Database Patch Delivery Methods:
What else do you need to know?
- Q: Is there a difference between “Bundle Patch” and “Proactive Bundle Patch“.
A: It’s the same thing.
- Q: What are RUs and RURs? Do they replace BPs and PSUs?
A: Please see: https://mikedietrichde.com/2017/07/19/first-ru-oracle-12-2-0-1-available/
- Q: Can I apply Exadata Bundle Patches on non-Exadata Systems in Oracle 11g?
A: Even though this is technically possible for Linux, there are certain restrictions. This is only supported in a standby configuration where one part is operated on an Exadata. See the FAQ at the end of MOS Note: 1962125.1 – Overview of Database Patch Delivery Methods
- Q: Can I flip from PSUs to BPs?
A: When you approach a release or patch set upgrade (i.e. Oracle Database 126.96.36.199 to Oracle Database 188.8.131.52, or Oracle Database 184.108.40.206 to Oracle Database 220.127.116.11) you will start from scratch and have the full choice. But in-between a release you’ll have to deinstall at least the sql changes and roll in the new sql changes when you change between PSUs and BPs or vice versa. See my previous blog posts about switching from PSUs to BPs: https://mikedietrichde.com/2016/05/03/can-i-apply-a-bp-on-top-of-a-psu-or-vice-versa/
- Q: Why does Oracle still deliver PSUs in Oracle 12c even though it recommends to use the BPs?
A: I don’t know. I can just assume that some customers insist to get the PSUs having a smaller number of fixes meaning potentially lower effect on their systems. But personally I totally disagree. When you look up the current issues list for Oracle 18.104.22.168 you will find out that many of the fixes are included in the BPs but not in the PSUs. If it would be my choice, I can perfectly (and better) live without PSUs but only getting BPs instead.
- Q: I have issues with the patches’ readme – can you explain it to me?
A: No. Please log an SR. I get the “readme complaint” from almost every customer I see. And I see all the points and agree in most of them. Still, I’m not the owner of patching nor the owner of the readme’s. Telling it me is good – but telling it Oracle Support via an SR, and force a bug to be logged is the much better solution. Please please please, do log SRs when you are not happy with the patches’ readme, when things are unclear or wrongly carried over or whatever. The readmes get written by humans and they will need your feedback to improve the readmes.