As many as five numbers may be required to fully identify a release.
Because Oracle Database continues to evolve and can require maintenance, Oracle periodically produces new releases. Not all customers initially subscribe to a new release or require specific maintenance for their existing release. As a result, multiple releases of the product exist simultaneously.
About Oracle Database Release Numbers
Oracle Database releases are categorized by five numeric segments that indicate release information.
Checking Your Current Release Number
To identify the release of Oracle Database that is currently installed and to see the release levels of other database components you are using, query the data dictionary view PRODUCT_COMPONENT_VERSION.
Parent topic: Getting Started with Database Administration
1.5.1 About Oracle Database Release Numbers
Oracle Database releases are categorized by five numeric segments that indicate release information.
Note:Starting with Oracle Database 18c, Oracle provides quarterly updates in the form of Release Updates (Updates) and Release Update Revisions (Revisions). Oracle no longer releases 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:
Figure 1-1 Example of an Oracle Database Release Number
Description of Figure 1-1 follows
Description of “Figure 1-1 Example of an Oracle Database Release Number”
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).
Third numeral: This numeral indicates the release update revision version (Revision).
Fourth numeral: This numeral indicates the increment version. This nomenclature can apply to updates in future releases.
Fifth numeral: This numeral is reserved for future use.
Note:The first three numerals mainly identify an Oracle Database release.
Caution:Oracle strongly recommends that you apply the most recent release update (Update) or bundle patch or patch set update to your source and target databases before starting an upgrade, and before starting a downgrade.
Related Topics
My Oracle Support note 2285040.1
Parent topic: Identifying Your Oracle Database Software Release
1.5.2 Checking Your Current Release Number
To identify the release of Oracle Database that is currently installed and to see the release levels of other database components you are using, query the data dictionary view PRODUCT_COMPONENT_VERSION.
A sample query follows. Other product release levels may increment independent of the database server.
COL PRODUCT FORMAT A38
COL VERSION FORMAT A10
COL VERSION_FULL FORMAT A12
COL STATUS FORMAT A12
SELECT * FROM PRODUCT_COMPONENT_VERSION;
PRODUCT VERSION VERSION_FULL STATUS
NLSRTL 19.0.0.0.0 19.2.0.0.0 Production
Oracle Database 19c Enterprise Edition 19.0.0.0.0 19.2.0.0.0 Production
PL/SQL 19.0.0.0.0 19.2.0.0.0 Production
…
It is important to convey to Oracle the results of this query when you report problems with the software.
Note:You can also query the V$VERSION view to see component-level information about all the Oracle Database components that are currently installed.
Parent topic: Identifying Your Oracle Database Software Release
