Oracle Database releases are categorized by five numeric segments that indicate release information.
Note:
Oracle provides quarterly updates in the form of Release Updates (Updates, or RU) and Release Update Revisions (Revisions, or RUR). Oracle no longer releases patch sets or bundle patch sets. For more information, see My Oracle Support Note 2285040.1.
Oracle Database releases are released in version and version_full releases.
The version release is designated in the form major release version.0.0.0.0. The major release version is based on the last two digits of the year in which an Oracle Database version is released for the first time. For example, the Oracle Database version released for the first time in the year 2018 has the major release version of 18, and thus its version release is 18.0.0.0.0.
The version_full release is an update of a version release and is designated based on the major release version, the quarterly release update version (Update), and the quarterly release update revision version (Revision). The version_full releases are categorized by five numeric segments separated by periods as shown in the following example:
-
First numeral: This numeral 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.
-
Second numeral: This numeral indicates the release update version (Update, or RU).
-
Third numeral: This numeral indicates the release update revision version (Revision, or RUR).
-
Fourth numeral: This numeral is reserved for future use. Currently it is always set to 0.
-
Fifth numeral: Although only the first three fields are commonly used, the fifth field can show a numerical value that redundantly clarifies the release date of a release update (RU), such as 19.7.0.0.200414.
Note:
The first three numerals mainly identify an Oracle Database release.
Caution:
Oracle strongly recommends that you apply the most recent Release Update to your target databases before starting an upgrade, and before starting a downgrade. If possible, also ensure that your source environment is patched. Release updates are cumulative. If you are also updating an Oracle Grid Infrastructure environment, then always apply the latest Release Update to the Grid environment first before updating Oracle Database Oracle homes. For more information about updates, refer to My Oracle Support note 2118136.2.
FAQs
Oracle Database releases are categorized by five numeric segments that indicate release information. Note: Oracle provides quarterly updates in the form of Release Updates (Updates, or RU) and Release Update Revisions (Revisions, or RUR). Oracle no longer releases patch sets or bundle patch sets.
What is the version number of Oracle 19c release? ›
Changes in Oracle Database Release 19c, Version 19.16.
How to check database release in Oracle? ›
How do I check the version of the Oracle database? To check the Oracle database version, you can run the following SQL query: “SELECT * FROM v$version;” in SQL*Plus or any SQL client.
When was Oracle 10g released? ›
Releases and versions
| Oracle Database Version | Initial Release Version | Initial Release Date |
|---|
| Oracle Database 11g Release 1 | 11.1.0.6 | September 2007 |
| Oracle Database 10g Release 2 | 10.2.0.1 | July 2005 |
| Oracle Database 10g Release 1 | 10.1.0.2 | 2003 |
| Oracle9i Database Release 2 | 9.2.0.1 | 2002 |
22 more rowsCurrently, the latest Oracle versions include Oracle Database 19c (Long Term Release), 21c (Innovation Release), and the newly released, 23c (Long Term Release).
What is an Oracle Database release update? ›
Oracle Database releases are categorized by five numeric segments that indicate release information. Note: Starting with October 2022, Oracle provides quarterly updates in the form of Release Updates (Updates, or RU) and Monthly Recommended Patches (MRPs). Oracle no longer releases patch sets or bundle patch sets.
When was Oracle 23C released? ›
You can choose from the three mentioned cycles of quarterly updates. Since Oracle's 23C is a long term release, the database has already been released for developers on April 6th, 2023. Oracle Cloud's non-production environments are updated on the first Friday of your quarterly update month.
How to find Oracle release version? ›
Here's a quick guide to help you access the Oracle Database.
- Open your command prompt/terminal.
- Type 'sqlplus' followed by a space.
- Provide your username and password.
- At the SQL prompt, type 'SELECT * FROM V$VERSION;'
- This will show the Oracle database version.
- Make sure you have the right credentials.
If we can connect to the database, then the simplest way to find the Oracle version and edition is to query the V$Version view, using the following syntax: SELECT BANNER, BANNER_FULL FROM v$version; The banner column will display the edition and the “base” version (18.0. 0.0, 19.0.
How many versions of Oracle are there? ›
There were several other versions released in between, too, namely Oracle V3, V4, V5, V6, 7, 8, 9i, 10g Release1, 10g Release2, 11g Release1, 11g Release2, 12c Release1, 12c Release2 and 18c.
One of the many motivations for upgrading to Oracle Database 23c will be five years of premier support and three years of extended support. This long-term support is essential for many of the mission-critical workloads that the Oracle Database is used to support.
Is Oracle 12c end of life? ›
Oracle Database 12c Release 1 (12.1) has reached its end of life on July 31, 2022. Since this support end date, Oracle no longer provides bug fixes, security updates, or patches for this version.
When was Oracle 11g launched? ›
Oracle Database 11g, released in 2007, introduced a host of new features that enable administrators and developers to adapt quickly to changing business requirements.
Is Oracle 11g still in use? ›
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.
Is Oracle 19c end of life? ›
For product longevity and patching, Oracle strongly recommends upgrading to 19c which is the Long Term release with a support end date of April 30, 2027 (or April 30, 2026 if you choose not to pay Extended Support fees or purchase a ULA). If you are currently running 11.2. x/12.1.
What is Oracle release management? ›
It establishes a repeatable release process and provides structure to the configuration experience. Using Release Management also creates an audit trail for both past and future package releases. Changes to rules during this process can be tracked, eliminating the need for manual spreadsheets.
What is Oracle long term release? ›
Oracle Database Long Term Releases are ideal for use cases that benefit from less frequent upgrades to newer releases. Long Term Releases offer the highest level of stability and the longest length of error correction support. These releases have 5 years of Premier Support followed by 3 years of Extended Support.
