Oracle Version Info

Release Number Format

To understand the release nomenclature used by Oracle, examine the following example of an Oracle Database server labeled “Release 10.1.0.2.3”.

10 – Major Database Release Number

The first digit is the most general identifier. It represents a major new version of the software that contains significant new functionality.

1 – Database Maintenance Release Number

The second digit represents a maintenance release level. Some new features may also be included.

0 – Application Server Release Number

The third digit reflects the release level of the Oracle Application Server (OracleAS).

2 – Component-Specific Release Number

The fourth digit identifies a release level specific to a component. Different components can have different numbers in this position depending upon, for example, component patch sets or interim releases.

3 – Platform-Specific Release Number

The fifth digit identifies a platform-specific release. Usually this is a patch set. When different platforms require the equivalent patch set, this digit will be the same across the affected platforms.

 

 

# Getting oracle version
SQL> select * from v$version;

BANNER
——————————————————————————–
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production
PL/SQL Release 11.2.0.2.0 – Production
CORE    11.2.0.2.0      Production
TNS for Linux: Version 11.2.0.2.0 – Production
NLSRTL Version 11.2.0.2.0 – Production

# component versions
select * from product_component_version;

# instance version
SELECT version FROM v$instance;

Leave a Reply