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 11.2.0.4?
But it has been revised and transformed now into a Download Assistant.
The New Download Assistant for RUs, RURs, BPs, PSUs, Patch Sets and Releases
This is the MOS Note you must bookmark and/or add to your Favorites:
MOS Note: 2118136.2
Assistant: Download Reference for Oracle Database/GI PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases
Start by choosing the type of patch or release you’d like to download:
Let’s try to download the most recent Bundle Patch for an Oracle Database 12.1.0.2 installation. Click on “Oracle Database PSU, SPU (CPU), Bundle Patches“:
Afterwards you’ll choose the version. “12.1.0.2” in my example. A frame to the right will appear now offering all the available PSUs, SPUs and Bundle Patches for Oracle Database 12.1.0.2.:
On Windows you have no choice: pick the newest Bundle Patch in the rightmost column. On all over platforms I’d highly recommend you to pick the Proactive Bundle Patch – and of course the newest one.
In case you need more advice or clarification whether to use PSUs or BPs or RUs or RURs please read here:
PSU or BP? Patch Set Update or Bundle Patch? RUR or RU?
And just in case you’d like to change your selection or download a second patch – click on the Change
tag.
Thanks to my Support colleagues who maintain this note – this is SUPER HELPFUL!
–Mike
Hi Mike,
Thanks for the note.
Are there similar download assistants for Engineered systems like Exadata / Database appliance ?
Regarding OJVM, Doc ID 1929745.1 explains what are OJVM PSU meant for, but i can’t find a good reference helping to know whether or not i should go for OJVM psu. As a DBA i only know they are not standby first installable but i don’t know how to exactly qualify if a system needs OJVM PSU. This is especially the cas when patching exadata with QFSPD.
Basically, how can i decide if OJVM PSU is to be installed or not ? Is there a technical explaination about why OJVM psu are not standby first installable while standard PSUs are ? Last question, but not the least important :
I have noticed that when running Opatch lsinventory against GRID HOME, usually DB PSUs are also retrieved (Grid being reported as OCW) which is not really clear. Same when running Opatch lsinventory again DB HOME : Grid patch level is also reported. Is there a way to retrieve only patches which have been applied against a specific grid/db home ?
Thanks !
Olivier
Oliver,
I don’t think that there’s a download assistant for the Exadata patches. BUT … see this note here:
Oracle Support Document 888828.1 (Exadata Database Machine and Exadata Storage Server Supported Versions) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=888828.1
This is the one which should guide you for Exadata’s. For ODA I’m not sure if such notes exist.
Regarding OVJM patching:
https://mikedietrichde.com/2017/02/16/the-ojvm-patching-saga-and-how-to-solve-it-part-v/
and the linked articles. This should guide you through the OJVM topic.
And apologies for the inconvenience with GI patch namings (PSU or BP, OCW etc). Not in my hands unfortunately …
– OCW is Oracle Cluster Ware – internal code still kept and existed before Grid Infrastructure
But yes, this is the Clusterware (GI) component patch
– GI gets always a PSU patch – there’s no BPs (in theory)
Of course you can download BPs having the GI component (or OCW) – but the patch number stands for the PSU
I know this is strange and sounds pretty inconsistent … I can just advice customers to log SRs and ask for final clarifications.
Cheers
Mike
Hi
There is still no information about latest patches from October in Assistant 🙁
It’s there now – the responsible owners updated it.
Cheers
Mike
Nice one! Very useful,
cheers