Shulou(Shulou.com)05/31 Report--

This article mainly explains "which version is better to upgrade Oracle". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Next, let the editor take you to learn "which version is better to upgrade Oracle?"

1.Oracle database version background

First of all, let's talk about the background of the Oracle version.

According to Oracle's product line plan, the new version starting with 18c will be the annual version, and the version will be the last two digits of the release year. The version originally planned to be 12.2.0.2 is now the release of 18cPerson12.2.0.3 in the form of 19c. It is expected that Oracle Database 19 will be the last version of 12.2 ("long-term support" version).

So after 8pr 8irec 10g dint 11g 12c, then 18c dint 19c, now it is 2020, the latest version is still 19c according to plan, but there is no 20c, otherwise it will be laughed at.

Since the development of version V2, I have counted some of the following versions.

Release year of the version

Version

19792.319833.1.319844.1.4.019855.0.2219886.0.1719927.0.1219978.0.319988.1.5.020019.0.1.020029.2.0.1200310.1.0.2200510.2.0.1200711.1.0.6200911.2.0.1201312.1.0.1201612.2.0.1201818.1.0201919c

If you want to see the differences in the version as a whole, you can look at the bar chart below.

This diagram does not reflect the time difference between versions, only in terms of the changes in the versions.

A striking difference can be seen from this diagram alone, that is, annual versions such as SQL Server can be less sensitive to version differences.

2.Oracle database version planning

We can see that there are many versions, if you want to choose to upgrade the database, whether to choose 12c, 18c or 19c, let's take a look at a version roadmap, you can refer to the official MOS article: Release Schedule of Current Database Releases (document ID 742060.1)

This diagram is the core of understanding the whole content, you can see that the positioning of 19c is a long-term version, and the deadline for extending the service is by far the longest.

In contrast, the life cycle of 18c will be much shorter, a bit like the transitional version of epiphyllum, which is not as cost-effective as the earlier version 12.2.0.1. How to relate to the time background at that time should be that a group of early users upgraded from 11g and chose to upgrade to 12.1.0.2 when there was no 12.2 release. So the release time of 12.2.0.1 and 18c is also very close.

It is worth mentioning that on April 15, 2020, Oracle revised the extension deadline of 12.2.0.1 from December 1, 2020 to March 31, 2020. (Added Limited Error Correction for 12.2.0.1 from Dec 1, 2020 until March 31, 2022)

3.Oracle database service support

When it comes to extended services, we may be a bit unfamiliar. In general, the intensity of support is divided into three levels: Premier Support (highest priority support), Extended Support (medium priority support), and Sustaining Support (lowest priority support).

If the figure above is related to some patches for extended services, you can give an example. For example, if the mainstream version is 11g, then there will be a relatively stable product life cycle, such as 5 years. Then during these 5 years is the stage of strong official support, a series of versions of bug will be repaired, some improvements and new features will be introduced, and upgrades will need to be considered as the product life cycle approaches. If you do not upgrade the service support, there will be a certain discount, for example, the extended service period is 2 years, then it is normally impossible to download some patch updates after 2 years. If you have not upgraded after the extended service cycle, if you are a major customer, you can also spend money to continue to support it. If it spans multiple periods of time, but the original version support is still needed, you need to do customized support.

For the database version, 10g is a hurdle, upgrading to 11g is a hurdle, and the options for upgrading to 12c are limited from the picture above. At present, the options are 12.2.0.1, 18c and 19c. Let's take a look at these three versions, and let me highlight them.

Version

Patch deadline

Remarks and instructions

19c

Long-Term Release

Mar 31, 2023 with no ES/ULA

Mar 31, 2026 with ES/ULA

Premier Support (PS) ends Mar 31, 2023, Extended Support (ES) fees will be required beginning Apr 01, 2023 through Mar 31, 2026

Error Correction / Patching is available through Mar 31, 2026 with paid ES. Without paid ES, patching is only available until Mar 31, 2023.

18c

Annual Release

Jun 08, 2021

Error Correction / Patching is available until Jun 08, 2021

18c is not eligible for Extended Support (ES)

12.2.0.1

Annual Release

* March 31, 2022 with Limited Error Correction from Dec 1, 2020

Error Correction / Patching is available until Nov 30, 2020

Limited Error Correction (Sev 1 and Security Updates only) is available from Dec 1, 2020-March 31, 2022 See Note 161818.1 for details.

12.2.0.1 is not eligible for Extended Support (ES)

Gen 1 ExaCC, OCC DBCS, and ODA will have 3 additional months of support life. The end of life dates for databases on these platforms is: 28-Feb-2021

From the above figure, in order to stabilize, we do not choose the nearest low version, but prefer the large version as stable as possible to avoid subsequent major version changes. If you put it more clearly, it is to choose 19c.

The situation of the version is almost over, let's take a look at the correct posture of the upgrade, because of the differences in the environment, the initial version must be different.

4.Oracle database version upgrade matrix

For 11g databases, if it is the latest version of 11g, it can be upgraded directly to 19c, which is a great good news and avoids the potential dangers caused by excessive upgrades and the unavailability of services.

For versions above 12c (12.1.0.2 or above), you can upgrade to 19c directly.

During the upgrade process, you can consider upgrading the data dictionary manually or using DBUA.

Oracle 19c-Complete Checklist for Upgrading to Oracle Database 19c (19.x) using DBUA (Doc ID 2545064.1)

If you use DBUA to upgrade, you can refer to the following table for direct upgrade:

Source Database

Target Database

11.2.0.4 and Higher

19.x

12.1.0.2

19.x

12.2.0.1

19.x

18.1

19.x

For some versions, you can't upgrade directly, but you need to transition. For example, if your version is 11.2.0.2, you need to upgrade to 11.2.0.4 before you can upgrade to 19c.

Source Database

Intermediate upgrade path

Target database

11.2.0.1/11.2.0.2/11.2.0.3

->

11.2.0.4

->

19.x

11.1.0.6/11.1.0.7

->

11.2.0.4

->

19.x

10.2.0.2, 10.2.0.3, 10.2.0.4, 10.2.0.5

->

11.2.0.4/12.1.0.2

->

19.x

10.1.0.5

->

11.2.0.4/12.1.0.2

->

19.x

9.2.0.8 or earlier

->

11.2.0.4

->

19.x

12.1.0.1

->

12.1.0.2/12.2.0.1

->

19.x

At this point, I believe you have a deeper understanding of "which version of Oracle upgrade is better?" you might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.