This question sounds very simple: How long will Oracle Database 12.2 be supported? Right? But I learned at a customer site recently that the information about the support periods for Oracle 12.2 may puzzle people sometimes. Hence I thought some clarification may be useful.
Lifetime Support Policy Brochure
First of all, when you have a look into the Lifetime Support Policy brochure the answer you’ll read there is:
- Premier Support until March 2023
- Extended Support until March 2026
But this doesn’t give you any distinction between Oracle 22.214.171.124, Oracle 18c and Oracle 19c. These three releases fall under the Oracle 12.2 Release Family umbrella.
The problem here: One may just note down that Oracle 12.2 is in Premier Support until March 2023.
But this is not the complete picture.
Addition on Nov 14, 2019:
It took a longer while to convince some people that the above (now: older) table may lead to misunderstandings. But finally, the table has been updated end of October 2019 and differs now between Oracle 126.96.36.199, Oracle 18c and Oracle 19c – and this way, the information is now accurate and easier to understand:
The Single Source of Truth
I call MOS Note: 742060.1 (Release Schedule of Current Database Releases) the single source of truth as it gives much more detail than the Lifetime Support Brochure.
But, in this specific case, the graph MOS Note: 742060.1 displays may be puzzling as well as it has an “12.2” bar above Oracle 188.8.131.52, Oracle 18c and Oracle 19c.
I just had a discussion where customers interpreted this in conjunction with the Lifetime Support Brochure as if Oracle 184.108.40.206 would get Premier Support until March 2023. Oracle 12.2 == Oracle 220.127.116.11.
But I write this blog post to clarify that this is not the case.
Bug fixing will end for Oracle 18.104.22.168 on Nov 20, 2020. This strange date is derived from the availability of Oracle 18c for HP, AIX and zLinux. From this availability date on the clock of 2 years bug fixing support for Oracle 22.214.171.124 started ticking.
The end of bug fixing support for Oracle 18c will be announced once all ports for Oracle Database 19c on-premises becomes available.
You can find this information also in MOS Note: 742060.1 when you scroll down a bit to table 2:
This is the important information. And the reason why I call MOS Note: 742060.1 “the single source of truth”. Only Oracle Database 19c gives you the full span of bug fixing support until 31-Mar-2023 with the option to have Extended Support until 31-Mar-2026.
No Extended Support for Oracle 126.96.36.199 and Oracle 18c
And MOS Note: 742060.1 presents also another VERY important detail: There won’t be any Extended Support available for Oracle 188.8.131.52 or Oracle 18c. This is no different from previous releases as for example Oracle 184.108.40.206 or Oracle 220.127.116.11 didn’t get Extended Support either. Only the Terminal Patch Set (or here: the Terminal Release) received Extended Support optionally, in some cases waived.
Important Addition as of April 15, 2020:
And another important change: Oracle 18.104.22.168 got Limited Error Correction Support added until 31-Mar-2022.
See here: Oracle 22.214.171.124 Support extended with Limited Error Correction Support
You may read also a bit more about the topic here:
- Premier Support Extension for Oracle 19c – and more
- How long can you provision database version X in the cloud?
- Oracle 126.96.36.199 Support extended with Limited Error Correction Support
You may consider to add the Cloud Database Support portion as well –
Support Dates for Oracle Database Releases in Oracle Cloud Database Services (Doc ID 2377651.1)
I hope it won’t add additional confusion 🙂
but I link it from the current blog post as well.
Thanks for the hint – highly appreciated!
Thank you, very useful. I’m trying to find more context about 188.8.131.52 – it shows extended support until 2021 but what is the difference between Premier & Extended?
the differences are:
Premier Support means we fix everything at no additional cost. This is covered by your regular Oracle Support contract.
Extended Support means: 10% extra in year 1, 20% extra for each year in the following years. Then we fix only critical issues and provide access to bundle patches.
If Extended Support gets waived, then no extra costs.
Thank you Mike, much appreciated.
Note, as of Nov 2019 the table in 742060.1 has been updated, and now 184.108.40.206 Premier Support is extended till 31.3.2023. * Patching ends on 20-Nov-2020
It is not – and I gave up on explaining the responsible people that this leads to massive misunderstanding. The message with the asterisk is the correct one saying:
* Patching ends on 20-Nov-2020. You can still download and install existing patches but no new patches will be created. Premier Support includes more than patching. See Lifetime Support Policy – Oracle Technology Products for details.
Please EVERYBODY open SRs on this and ask Support to explain this.
Cheers – and SORRY for the inconvenience!
If this post is originally from January 30, 201, then I suppose the addition in red is Nov 14, 2019, not 2018, correct ? I’m only trying to re-construct what was announced (or clarified) when.
Oh thanks Hugo – you are absolutely right!
Good catch, now corrected – thanks!
Have you heard anything from oracle that the November 2020 end of support of 220.127.116.11 will be extended with this virus situation?
I’m not a spokes person of Oracle, and hence I can’t answer this question.
Thanks and take care,
i have place a support case on this to find this out as i have customers having a freeze at moment and will not make the 19c upgrade in time for November 2020.
this is the right way. Let Oracle Support know – but personally there is not much I can do.
In addition, get in touch with the account manager taking care on this customer. There may be something they can do.
Thanks for sharing this info.
Am I missing it or has that document reverted back again. we are currently running into a vendor that will not support us past 18.104.22.168 because 18 and 19 are major releases and they do not support them. Though they would support 22.214.171.124 or 126.96.36.199
I see what you mean – and I was not aware. We’ll check why and how and when etc.
This might help a few others that are in my same position with a vendor.
This note 161818.1 does say 12.2 and clearly shows 18 and 19 as part of that family. Its unfortunate this message seems to be mixed depending on where you look. I spent a lot of time looking for something like that.. My manager reached out to someone in oracle and was sent that.
I agree – and I tried to raise this internally.