What will you get when you download the most recent Oracle Database PSU or BP from October 2016?
MOS Note: 1683799.1 – 12.1.0.2 Patch Set – Availability and Known Issues is not entirely clear. Therefore lets shed some light …
The Matrix
This matrix in MOS Note: 1683799.1 tells you about the availability of PSUs and BPs for a regular database installation (non-RAC, non-Exadata). But it doesn’t clearly tell you what’s included – and the names being used aren’t very revealing either.
Document Description Rolling RAC Patch Download Note:24448103.8 12.1.0.2.161018 Database Proactive Bundle Patch (Oct 2016) Yes Patch:24448103 Note:24436306.8 Combo of 12.1.0.2.161018 OJVM PSU and 12.1.0.2.161018 DBBP (Oct 2016) Part Patch:24436306 Note:24433133.8 Combo of 12.1.0.2.161018 OJVM PSU and 12.1.0.2.161018 DB PSU (Oct 2016) Part Patch:24433133 Note:24315824.8 Oracle JavaVM Component 12.1.0.2.161018 Database PSU (Oct 2016) (OJVM PSU) No Patch:24315824 Note:24006101.8 12.1.0.2.161018 (Oct 2016) Database Patch Set Update (DB PSU) Yes Patch:24006101
My Matrix
I translate this into:
Non Exadata Non RAC
Document | Description | Rolling RAC | Patch Download | DB PSU | DB BP | GI PSU | OJVM |
Note:24448103.8 | 12.1.0.2.161018 Database Proactive Bundle Patch (Oct 2016) | Yes | Patch:24448103 | X | X | ||
Note:24436306.8 | Combo of 12.1.0.2.161018 OJVM PSU and 12.1.0.2.161018 DBBP (Oct 2016) | Part | Patch:24436306 | X | X | X | |
Note:24433133.8 | Combo of 12.1.0.2.161018 OJVM PSU and 12.1.0.2.161018 DB PSU (Oct 2016) | Part | Patch:24433133 | X | X | ||
Note:24315824.8 | Oracle JavaVM Component 12.1.0.2.161018 Database PSU (Oct 2016) (OJVM PSU) | No | Patch:24315824 | X | |||
Note:24006101.8 | 12.1.0.2.161018 (Oct 2016) Database Patch Set Update (DB PSU) | Yes | Patch:24006101 | X |
How to apply a Proactive Bundle Patch?
If you’ve never done it before, applying a Proactive Bundle Patch to a database-only installation is not very complicated. Please see my own step-by-step instructions here (but don’t forget to check the current readme as well please!).
More Information:
- General information: Critical Patch Update – October 2016
- Risk Matrix for: Oracle Database Server, version(s) 11.2.0.4, 12.1.0.2
- Patch Availability: MOS Note: 2171485.1
- Download the Database PSU or BP:
MOS Note: 1683799.1 – 12.1.0.2 Patch Set – Availability and Known Issues - Example on how to apply the April 16 Proactive Bundle Patch:
https://mikedietrichde.com/2016/04/21/oracle-database-bp-april16-applied-successfully/
–Mike
Hi Mike,
I attended your 12.2 Upgrade Workshop in Calgary and it’s very informative and helpful. For the question I asked about "How to remove all Windows DB Bundle Patches and back to the pure original state", can you please provide the URL links or MOC# for the steps or scripts?
To refresh background info of my question, we are on 12c (12.1.0.2) on Windows now. We encounter some weird issues while installing Jan & Apr 2016 DB & JVM BPs: passed on opatch part but getting "Nothing to apply" during post-installation step (datapatch). We have tried de-installation but seems not cleanly according to DBA_REGISTRY_SQLPATCH. There are no clear info in logs or Oracle Support thus we are looking for a clean procedure to remove any applied or "half" applied related patches from our 12c databases and bring them back to the ground zero i.e. original version 12.1.0.2.0.
Thank you in advance and hope that you could spare more time for your next trip to Calgary.
Stewart
Hi Stewart,
this was the blog post I mentioned:
https://blogs.oracle.com/UPGRADE/entry/can_i_apply_a_bp1
Afterwards you’ll have to start a "datapatch -verbose" in order to clean out the SQL changes as well.
Cheers
Mike
Are PSU patches truly backward compatible, if I apply Oct 2016 rdbms PSU I get all the critical, high, low fixes that were released in July 2016 PSU ?
Ted,
yes, SPUs, PSUs and BPs are cummulative – if you take the Jan 17 one you’ll have all the previous fixes from either the SPUs, the PSUs or the BPs included.
Cheers
Mike
Hi mike.
I would like to know if on a fresh 11.2.0.4 GI Clusterware and RAC RDBMS is sufficient with apply GI PSU only using #opatch auto.
Laverde,
may I ask you to please open an SR as I’m not the master of patching?
The PSU only is correct and fine. And you should please refer to the readme – and if this is incorrect or unclear log an SR. I say this NOT to give you a bad impression but I logged 21 bugs against a single patch readme a while back – and I’d blindly say that half of them are not fixed and carried forward and forward. I get complaints about those readmes at every customer I visit when we discuss patching. And if you don’t open SRs against the readmes the responsible people will never improve the quality of those reeadmes.
I believe yes, you can use opatch auto – but again, I’m not the master of patching 😉
Cheers
Mike