You surely receive such messages and most probably like me you trash them… No time to apply them, no support from applicative teams to test them on QA, tons of other things to do !
Example of January message:
Above message the first link redirect you to:
Then is you choose the latest one available you will be redirected to:
To finally go, for Oracle Database Oracle Database 11 g Release 2, version 188.8.131.52, to Note 1089044.1. In this note they mention what they call a Database Patch Set Update. A Patch Set Update (PSU) is a proactive, cumulative patch that contains the recommended bug fixes and the Critical Patch Update security content, and therefore is an option to apply instead of the Critical Patch Update (the taste of a patchset but not really a patchset, as it is changing only the last digit of your release).
As of September the 27th PSU 184.108.40.206.2 for Oracle Database 11gR2 is available, this PSU obviously includes CPUJUL2010 BUT also contains lots of bugs correction.
So instead of applying one single one-off patch to correct a bug it could be interesting to apply the latest PSU to be more proactive. Please note that once you have decided to apply a PSU (that can be applied on any release) you cannot revert to CPU security update (in fact you can but it’s quite a lot of work).
- AWR mining for performance trend analysis - January 20, 2018
- Oracle Disk Manager (ODM) successful implementation - December 20, 2017
- Oracle Label Security (OLS) 12c installation and configuration - November 20, 2017
- Database Vault 12cR1 installation and configuration - October 23, 2017
- Data Redaction (DBMS_REDACT) with 12cR1 (220.127.116.11) - September 26, 2017
- Resolve ORA-01578 error with and without a backup - August 28, 2017