Why you shouldn’t ignore Oracle 11g support end-of-life

By Dave


Most of us are looking forward to seeing the end of 2020, for a multitude of reasons. However, if you are still enjoying the relative comfort of extended support on Oracle 11g, now might be the time for a change, as the extended support ends along with 2020.

 

There is no doubt that in today’s world, businesses cannot function without data and that managing and protecting that data is critical. According to DB Engines, Oracle and SQL are the most popular database management systems because of their reliability and the effective way they manage information and applications of their users.

In order to ensure that they keep being relevant for their customers and staying on top of the game, both systems constantly release new versions with new features and new tools that increase security, capabilities and performance. As new versions are released, support for the oldest versions gets retired, like in July 2019 when Microsoft stopped providing support for SQL Server 2008 and 2008 R2.

The same is about to happen with Oracle, as it will stop Oracle 11g extended support on December 31st, 2020.

 

So, what are your options?

1. Do nothing – you can literally ignore the end of support Oracle 11g and still be able to use your Oracle database.

What does this mean for you? If you are running this version of Oracle database, the support end-of-life means no further critical patch updates, hotfixes or security fixes. Basically, you can still use it, but you won’t receive any Oracle support if you incur any new problems, and critically, your system would be vulnerable from a security point of view.

2. Upgrade – DIY, via Oracle or using an external provider – upgrading will be the recommended choice and maybe a chance to consolidate your databases into multitenant architecture, before it becomes mandatory in Oracle 20c.

3. Move to CloudOracle provides guidance on how to migrate to the cloud, although once again you can decide to use your own DBA team or to outsource. If you are unsure about moving to the cloud, find out more about cloud database vs traditional database.

 

If you decide to upgrade, what do you need to do in order to migrate?

Oracle has an entire set of documents designed to help you with the migration.

However, before you start the upgrade process, it is critical that you take some time to plan the migration. In fact, planning is most likely the part of the process that requires the most time. In your plan you should allow time for:

· Checking the status of software and hardware, to ensure that you can actually complete the migration (See the next point ‘What if you can’t upgrade’)

· Planning for the downtime required for the migration.

· Preparing a back-out plan, should anything go wrong.

· Testing, testing, testing! Everything should be run on a test system before you move to the live system.

PRO TIP: On https://support.oracle.com check out MOS note 884522.1 where you can see how to access and run Oracle’s Database pre-upgrade utility. This will highlight any database issues that could occur during a database upgrade.

 

What if you can’t upgrade?

There are instances where upgrades are not possible, or at least not straight away. Oracle has set up a number of paths that need to be followed before you can jump from a very old version to the latest releases.

You can check this useful document from Oracle to find the supported upgrade paths from Oracle 11 to 12/18 and then onto 19.

 

Coverage for Oracle Technology Products

Oracle Database Releases
ReleaseGA DatePremier Support
Ends
Extended
Support Ends
Sustaining
Support Ends
8.1.7Sep 2000Dec 2004Dec 2006Indefinite
9.2Jul 2002Jul 2007Jul 2010Indefinite
10.1Jan 2004Jan 2009Jan2012Indefinite
10.2Jul 2005Jul 2010Jul 2013Indefinite
11.1Aug 2007Aug 2012Aug 2015Indefinite
11.2Sept 2009Jan 2015Dec 2020Indefinite
Enterprise
Edition 12.1
Jun 2013Jul 2018Jul 2022Indefinite
Standard
Edition (SE) 12.1
Jun 2013Aug 2016N/AIndefinite
Standard
Edition One (SE1) 12.1
Jun 2013Aug 2016N/AIndefinite
Standard
Edition 2 (SE2) 12.1
Sept 2015Jul 2018Jul 2022Indefinite
12.2.0.1Mar 2017Nov 2020N/AIndefinite
18cJun 2018Jun 2021N/AIndefinite
19c (Long
Term Release)
Apr 2019April 2024Apr 2007Indefinite

Also, your applications or your hardware might not be certified against the latest version, in which case you will need to invest in validating your application and updating your hardware before you can upgrade your Oracle system and enjoy again full extended support.

If you need assistance on checking what versions of Oracle Database are supported on what versions of Operating systems you can visit https://support.oracle.com:

1. Click on the certifications tab

2. Complete the Product and Release fields

3. Click on search to display certified versions.

Talk to us, if you need support, our team is here to help.

 

In summary

Such a drastic change of architecture may look daunting, but it is important for safeguarding your database estate and get a full extended support.

If you don’t feel comfortable or don’t have the in-house expertise to manage the migration, WellData has the expertise to help and advise on what is right for you by running oracle database health checks.

Whether it is a full or partial consolidation, or simply moving what will become a legacy technology right up to date with minimal disruption, getting premier Oracle Database support, and protecting your database, we are there for you.

In this way, you can concentrate on what you do best and leave the rest to us.

 

Get in touch

<< Back to Knowledge Centre

Related Technologies:


Join Our Newsletter

Contact Email  *
First Name 
Last Name 
*Required Fields
I agree to the  Privacy Policy and  Terms of Use 

Here's what other people think

Google Rating
5.0
High standard, professional service. I've worked with Welldata for a number of years and always found their DBA's to be knowledgeable and proactive. Throw any question at them and it will be resolved, it gives real peace of mind knowing you have a partner you can rely on from emergencies to general questions. They also like a challenge and we do throw a few curved balls at them.read more
Paul Miller
Paul Miller
12:34 27 Aug 21
The support I receive from Well Data is extremely responsive. Richard Parsons is my contact and keeps me informed daily on the health of our SQL Databases. Whenever I ask for assistance from Well Data it is quick and professional.read more
Kay Riley
Kay Riley
13:41 19 Aug 21
Really know their stuff and their response times are very good. They provide us with a vital service.
Andy Cole
Andy Cole
13:36 19 Aug 21
The guys at WellData really know their stuff. We wanted a quick route to doing something complex and they sorted it for us very quickly and to a high standard. Very professional, no ego, just excellent and to the point consultancy.read more
Steve Goacher
Steve Goacher
11:31 14 Nov 19
I have worked with the WellData team for many years now and they have always delivered.I would highly recommend them to any business looking for best-value outsourced Expert DBA’s.Being able to offer a rolling contract on the basis that if they don’t deliver you can leave shows their confidence and commitment.Their professionalism and knowledge is second to none.read more
Petro Bartoszyk
Petro Bartoszyk
08:51 18 Oct 19
A very dedicated team of extremely professional and knowledgeable experts
Giulia Iannucci
Giulia Iannucci
14:08 16 Nov 18
We use Welldata for SQL support and are very happy with their service.
David Sadler
David Sadler
09:40 15 Nov 18
Really know their stuff and their response times are very good.
Andy Cole
Andy Cole
11:45 06 Nov 18
Our partnership with WellData has enabled us to resolve critical database problems. Their attitude and service makes them a natural extension to our own technology team, which extends our capability in a critical area of our business.read more
Steve Fenton
Steve Fenton
10:56 05 Nov 18
Having worked with the team at Welldata for approaching 17 years, my company and I have always found them professional, reliable and generally a great firm to work with.read more
John Lynes
John Lynes
14:00 04 Oct 17
WellData provide an excellent level of support and their team are very knowledgeable and always go the extra mile. I would wholeheartedly recommend them.read more
Stefan Parrott
Stefan Parrott
13:12 19 Sep 17