Current Support Status for Oracle Database Releases

Yesterday a former colleague from the UK pointed me to a very old blog post about the fact that no patches will be produced for Oracle 11.2.0.3 anymore. Which is a true fact. But it reminded me that it may be time for an overview on the current support status for Oracle database releases as of October 2018. Current Support Status for Oracle Database Releases First of all, the single source of truth in case you’d like to look up support dates and patching periods is MOS Note:742060.1. Please always check this note first. Our Support Lifetime Policy brochure does…

How long can you provision database version X in the Cloud?

That’s a question I have gotten several times already: How long can you provision database version X in the Cloud? Meaning, is there a fixed date when you’ll be unable to provision an instance containing Oracle Database 12.1.0.2 for instance? How long can you provision database version X in the Cloud? First of all, it is important to note that the support time frames between on-prem and cloud are the same. But it is also important for you to notice that after a certain date you won’t be able to provision an instance with a specific database version anymore. And…

Patching my databases with the July 2018 PSU, BP and RU

As usual I download the patch bundles  and apply them to our Hands-On Lab environment as quickly as possible. First of all for the simple reason that I don’t want to trap into issues which are fixed already. Second for the reason that I always tell you: YOU MUST PATCH! But if I’m saying this over and over again, then I can’t have my own environments unpatched. And at third, because I want to learn if anything is not working correctly or has changed (see below). Of course my tiny single instance environments are not comparable to your critical production…

Where is the Jan 2017 PSU for Oracle Database 11.2.0.4?

Where is it? This question reached me a week ago: “Where is the January 2017 PSU for Oracle Database 11.2.0.4?” “What’s the deal?” was my first thought – just go and download it from MOS. Well, not really … Where to download Proactive Bundle Patches, Patch Set Updates and Patch Sets? My favorite note is: MOS Note:1454618.1 Quick Reference to Patch Numbers for PSU, SPU(CPU), BPs and Patchsets It gives me access to all the download links for the patch bundles I’m looking for. But for 11.2.0.4. there’s only “NA” (not available) stated: And a very small asterisk “m”: Why…

New 11.2.0.4 Parameter: ENABLE_GOLDENGATE_REPLICATION

Just learned something new I couldn’t find actually in the doc at the first glance: There’s a new init.ora parameter introduced in Oracle Database 11.2.0.4 named: ENABLE_GOLDENGATE_REPLICATION By default it is set to FALSE and the parameter got introduced because not only the external use of Oracle GoldenGate requires a valid license but also the use of the internal APIs. For example, XStream provides high performance APIs that enable client applications to receive and send real-time data changes from an Oracle database. Other APIs were added for encryption support, trigger suppression, etc. None of these APIs are licensed with the…