Re: any extra patches to consider?

Patrice,
I was looking in this area fairly recently and have a couple of pointers you may wish to consider.

Firstly, consider moving from PSU's to DBBP (Database Proactive Bundle Patches).
A few resources you can find about the differences: https://blogs.oracle.com/UPGRADE/entry/oracle_april_2016_psu_and https://www.pythian.com/blog/oracle-database-12c-psus-vs-database-proactive-bundle-patches/ In summary each DBBP contain a superset of bug fixes contained in the equivalent PSU.
Note that one-off patches must either be build for DBBP or PSU, they are not interchangable.
I decided that DBBP was the way to go on Linux (and maybe Solaris) only for now, as I guess Exadata customers install the DBBP as part of full stack patchset, so they are likely better tested, and individual bug fixes on top of the DBBPs are often available.
For AIX (our other main platform), seems individual bug-fixes are generally only available on top of PSU's for now, so I guess DBBP on AIX is less well tested, at least until Oracle does a better job of communicating the best practices.

In addition, you may also want to review the following document which lists some bug fixes not included in latest PSU or DBBP. Things to Consider to Avoid Poor Performance or Wrong Results on 12.1.0.2 (Doc ID 2034610.1) I guess there are equivalents for other versions.

Slightly worryingly (in the case of 12.1.0.2) we have encountered quite a few cases of wrong results, some very easy to reproduce. Bug fixes for some of these issues already exist, but they are neither included in PSU, DBBP or the support note above.

Regards
Patrick

https://hkpatora.com/

On 11 September 2016 at 00:30, Patrice sur GMail <patrice.boivin_at_gmail.com> wrote:

> After Y2K I was playing around with a software called Harris InfoSTAT
> which scanned our Windows workstation, told us what vulnerabilities
> existed, and which Windows security updates were missing. Even though we
> were applying all the updates recommended by Microsoft, there were 2 or 3
> which existed but that Microsoft had forgotten to put into the update
> system or decided to omit. (there were also a bunch of registry settings
> InfoSTAT recommended like disable CD drive autostart and probably now they
> would say disable USB ports but that's something else)
>
> When I realized Microsoft "missed' some vulnerability updates, it left me
> wondering what Windows bug fixes were also missing.
>
> Regarding Oracle, are there any "good" patches which aren't included in
> the PSU bundles? (PSU here including both bug and security fixes).
>
> Just wondering.
>
> Other than poking around in Oracle's Support site by product looking for
> patches, is there a tech note page which lists other patches, like perhaps
> for EBS or other products, that would be useful to have in more generic
> databases?
>
> ​I am fishing I suppose but I know there are smart people on this list who
> know more than I do.
>
> -- Patrice
> My profiles: [image: Facebook]
> <http://www.facebook.com/home.php?#!/profile.php?id=100000206805521>[image:
> LinkedIn] <http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9>[image:
> Twitter] <http://www.twitter.com/PatriceBoivin>
>

--
http://www.freelists.org/webpage/oracle-l