Shulou(Shulou.com)06/01 Report--

Customer A: 11g extension service expired, new environment version Why do you recommend 19.3?

Customer B: Will it be difficult to operate across so many versions?

Customer C: Then why are there still manufacturers in Amway 10g/11g?

Intern D: From 12c to 18c to 19c, where did the middle 13-17 go?

(Questions about Oracle Database)

Don't be afraid! I will answer your questions one by one:

For the above problem, we must start with Oracle version number changes.

Taking 2018 as a dividing line, Oracle has iterated on larger features in the database before, naming large versions with features.

Oracle·Large version

Oracle 9i

Oracle 9i version i refers to internet, officially renamed RAC from 8i ops, using Cache Fusion, greatly improved, this version has basically disappeared, but in some large enterprises relatively stable business model, there are still some systems used. From the author, more and more new systems are gradually replacing old systems to better adapt to current or future business models, thus achieving smooth elimination of database environments such as 8i/9i.

Oracle 10g

The g in Oracle 10g refers to grid. ASM storage management has been introduced since 10g, supporting grid management and supporting Load Balancer. A series of "new features" have been introduced for databases from 9i to 10g. Of course, looking back now, it has become commonplace.

Oracle 11g

In 11g, although still grid, but expanded the characteristics of the grid, improve availability, reduce downtime, and enhance security. From the host user level, cluster and database differentiation, replacement of asmlib with asm service, and the introduction of adg, enhanced backup recovery, provided relatively complete error diagnosis, can easily achieve read-write separation. Some of the database automation features introduced since 9i have been developed in several versions, where they have been greatly simplified. As one of the mainstream versions on the market, 11g has been recognized by the market for its stable and efficient service and increasingly convenient deployment steps.

Oracle 12c

12c is also an epoch-making version, C refers to cloud (cloud), provides cloud platform management, launches CDB/PDB, supports fragmentation, and meets the urgent needs of a large number of customers to achieve data fragmentation.

In 2018, Oracle started naming version numbers by year.

The database launched in 2018 is named after 18c.

The database launched in 2019 is named after 19c.

Naturally, launching the database in 2020 is 20c.

This brings us to the fourth question in the opening question.

Version Number·Name

For the specific version number, we will find the answer from the official documentation of each version of Oracle.

Here is the naming convention for version 9i:

9i version naming convention

The first digit is the version number.

The second digit is the new features release number.

The third digit is the maintenance release number.

The fourth digit is the generic patch set number.

The fifth digit is the platform specific patch set number.

The following is the naming convention for version 10g:

10g version of the naming convention

The first digit is the Major Database Release Number, which usually marks the release of some new feature.

The second digit is the database Maintenance release number.

The third digit is the maintenance release number of the application server.

The fourth digit is the Component Specific Release Number.

The fifth digit is the platform specific patch set number.

The following is the naming convention for version 11g:

11g version of the naming convention

Comparing the naming rules of 10g and 11g, we find that except for the definition of the third digit, the rest are the same.

The third digit is defined in 11g as the version number of the fusion median valence, which has little to do with the oracle database version.

12c is completely named after the version of 11g, see the following figure for details:

12c version naming convention

The definition of 18c/19c is as follows:

Naming convention for version 18c/19c

This number indicates the major release version. It also denotes the last two digits of the year in which the Oracle Database version was released for the first time. (This number indicates the major release.) It also indicates the last two digits of the year in which the Oracle database version was first released.)

The second number is the release quarter of Oracle RU (release update)

The third number is the release quarter of Oracle RUR (release update revision).

The fourth number is an incremental version of the database

The fifth number is reserved for future better naming conventions

Do you have a clear impression of the current mainstream version of Oracle?

Oracle is still the leader of relational databases, and compatible SQL standards are consistent. As for how you need to choose the right database version to adapt to the application, the author's suggestion is: because the extended support for 11g will end in December 2020, and starting from the second quarter of 2019, Oracle official regular quarterly patches for 11g have to provide special passwords to download.

If it is new, prioritize the deployment of a higher version of the data environment for availability testing and stress testing.

If you don't want to use an environment like CDB/PDB, Oracle will still support the normal standard database schema from 12c onwards, so embrace the new version.

For the early years, in the oracle dba spread, the version upgrade do not go too fast, easy to fall into the pit, and after 12c, this sentence may not be so arbitrary to say, you can understand 19c as the most stable 12c.

Just recently, Oracle has launched 20c, let's test it together.

come on

Due to space constraints, we'll talk about data software life cycles and patches later.

references

Oracle Database Administrator's Guide in the official documentation for each release

Meichuang Technology has a strong database service team in the operation and maintenance center, including 1 Oracle ACE, more than 10 OCM, dozens of Oracle OCP, MySQL OCP, Red Hat RHCA, middleware weblogic, tuxedo certification, and dream engineers.

Based on years of knowledge and experience in the field of data center operation and maintenance, Meichuang Technology independently develops OSM (database operation security management platform) and OKP (operation and maintenance integrated machine), and constructs Meichuang operation and maintenance cloud to realize panoramic monitoring of data center and intelligent operation and maintenance of database, effectively ensuring the stability of production business operation and database integrity.

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.