Release Number Format --每日一译【2013-01-28】

To understand the release nomenclature used by Oracle, examine the following example of an Oracle Database release labeled "11.2.0.1.0".

理解O的版本术语，查看以下例子关于O的发行版标签为“11.2.0.1.0”

Figure 1–1 Example of an Oracle Database Release Number

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.

Database Maintenance Release Number

主数据库发行号

第一位是最常见的标识，它显示的是主要的新版软件包含的重大的新的功能项；

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

Fusion Middleware Release Number

第二位显示的是维护的发行级别。一些新的功能也可能包含于其中。

融合了中间件发行的号码。

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

Component-Specific Release Number

第三位反映的是O的整合中间件的发生级别

特定的组件的发行号码

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.

Platform-Specific Release Number

第4位标识特定组件的发行级别。不同组件可以拥有不同的号码依赖于不同的位置平台，比如组件补丁集或者是过渡发行版本。

指定平台的发行号码

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.

第5位标识了一个指定平台的发生号码。通常这是个补丁集。当不同的平台要求相类似的补丁集，在受影响的平台中数据位是相同的；

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 A15
Note:
Starting with release 9.2, maintenance releases of Oracle Database are denoted by a change to the second digit of a release number. In previous releases, the third digit indicated a particular maintenance release.

备注：

从9.2开始，O的数据库发行号的显示被改成第2位的发行号。在之前的发行号中，第3位标识的是一特殊的维护发行号。

SELECT * FROM PRODUCT_COMPONENT_VERSION;
PRODUCT VERSION STATUS
---------------------------------------- ----------- -----------
NLSRTL 11.2.0.0.1 Production
Oracle Database 11g Enterprise Edition 11.2.0.0.1 Production
PL/SQL 11.2.0.0.1 Production
...
It is important to convey to Oracle the results of this query when you report problems with the software.

当你要对O汇报软件的问题时这个查询信息是重要的！