Skip to content

Oracle Version Format

March 30, 2012

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

 Oracle Version 11.2.0.1.6 (5 Digits)

 First Digit (11): 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.

 E.g.: 8i, 9i, 10g, 11g

 Second Digit (2): Database Maintenance Release Number:

===================================================

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

 In our case it is release 2 also called (11g release 2 or shortly 11gR2)

 E.g.: 9.2, 10.2, 11.2

 Third Digit (0): Fusion Middleware Release Number:

==================================================

The third digit reflects the release level of Oracle Fusion Middleware.

The third digit is Oracle application specific number, always equal to 0 for database software.

 Fourth Digit (1): 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.

Patch Set is the The fourth digit, component specific release number of 11.2.0.3. Oracle Support adds new features to the Patch Set.

 E.g.: 9.2.0.8, 10.2.0.5, 11.2.0.3

 

Fifth Digit (6): 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.

 

Patch Set Update is the fifth number 11.2.0.1.6;

 Every 3 months or so, Oracle Support release a Patch Set Update (PSU) to fix Patch Set bugs and does not add any new features to the PSU.

 E.g.: 11.2.0.1.6

 

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. (You can also query the V$VERSION view to see component-level information.)

 

Other product release levels may increment independent of the database server.

COL PRODUCT FORMAT A40
COL VERSION FORMAT A15
COL STATUS FORMAT A20 
SQL> SELECT * FROM PRODUCT_COMPONENT_VERSION;
 PRODUCT                                  VERSION         STATUS
---------------------------------------- --------------- --------------------
NLSRTL                                   11.2.0.1.0      Production
Oracle Database 11g Enterprise Edition   11.2.0.1.0      64bit Production
PL/SQL                                   11.2.0.1.0      Production
TNS for Solaris:                         11.2.0.1.0      Production

SQL> select COMMENTS,ID,BUNDLE_SERIES,VERSION,NAMESPACE,ACTION,ACTION_TIME from registry$history where BUNDLE_SERIES='PSU';

COMMENTS                          ID BUNDLE_SERIES   VERSION         NAMESPACE       ACTION                         ACTION_TIME
------------------------- ---------- --------------- --------------- --------------- ------------------------------ ----------------------------------
PSU 11.2.0.1.6                     6 PSU             11.2.0.1        SERVER          APPLY                          25-JUL-11 04.42.08.761645 AM

 http://docs.oracle.com/cd/E11882_01/server.112/e25494/dba004.htm
Advertisements

From → Oracle

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: