Oracle的版本号很多,先看11g的一个版本号说明:
注意:
在oracle 9.2版本之后,oracle的maintenance release number是在第二数字位更改。而在之前,是在第三个数字位。
1. Major Database Release Number
第一个数字位,它代表的是一个新版本软件,也标志着一些新的功能。如11g,10g。
2. Database Maintenance Release Number
第二个数字位,代表一个maintenance release级别,也可能包含一些新的特性。
3. Fusion Middleware Release Number
第三个数字位,反应Oracle中间件(Oracle Fusion Middleware)的版本号。
4. Component-Specific Release Number
第四个数字位,主要是针对组件的发布级别。不同的组件具有不同的号码。比如Oracle的patch包。
5. Platform-Specific Release Number
第五个数字位,这个数字位标识一个平台的版本。通常表示patch号。
6.如何查看版本信息:
(1)查看v$version
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE10.2.0.4.0Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
SQL>
(2)PRODUCT_COMPONENT_VERSION视图
SQL> COL PRODUCT FORMAT A40
SQL> COL VERSION FORMAT A15
SQL> COL STATUS FORMAT A15
SQL> SELECT * FROM PRODUCT_COMPONENT_VERSION;
PRODUCTVERSIONSTATUS
---------------------------------------- --------------- ---------------
NLSRTL10.2.0.4.0Production
Oracle Database 10g Enterprise Edition10.2.0.4.0Prod
PL/SQL10.2.0.4.0Production
TNS for Linux:10.2.0.4.0Production
SQL>
(3)dba_registry
SQL> select comp_name,version,status from dba_registry;
COMP_NAMEVERSIONSTATUS
------------------------------ --------------- ---------------
Oracle Enterprise Manager10.2.0.4.0VALID
Spatial10.2.0.4.0VALID
Oracle interMedia10.2.0.4.0VALID
OLAP Catalog10.2.0.4.0VALID
Oracle XML Database10.2.0.4.0VALID
Oracle Text10.2.0.4.0VALID
Oracle Expression Filter10.2.0.4.0VALID
Oracle Rule Manager10.2.0.4.0VALID
Oracle Workspace Manager10.2.0.4.3VALID
Oracle Data Mining10.2.0.4.0VALID
Oracle Database Catalog Views10.2.0.4.0VALID
Oracle Database Packages and T 10.2.0.4.0VALID
ypes
JServer JAVA Virtual Machine10.2.0.4.0VALID
Oracle XDK10.2.0.4.0VALID
Oracle Database Java Packages10.2.0.4.0VALID
OLAP Analytic Workspace10.2.0.4.0VALID
Oracle OLAP API10.2.0.4.0VALID
SQL>
(4)v$option视图
这个视图是基于底层的X$OPTION表创建,记录了数据库选件及特性。根据不同的版本,如标准版,企业版,个人版。部分选件需要购买相关的许可才可以使用,比如RAC,DG,分区表等。
SQL> col PARAMETER format a40
SQL> select * from v$option;
PARAMETERVALUE
---------------------------------------- ---------------------------------------
PartitioningTRUE
ObjectsTRUE
Real Application ClustersFALSE
Advanced replicationTRUE
Bit-mapped indexesTRUE
Connection multiplexingTRUE
Connection poolingTRUE
Database queuingTRUE
Incremental backup and recoveryTRUE
Instead-of triggersTRUE
Parallel backup and recoveryTRUE
Parallel executionTRUE
Parallel loadTRUE
Point-in-time tablespace recoveryTRUE
Fine-grained access controlTRUE
Proxy authentication/authorizationTRUE
Change Data CaptureTRUE
Plan StabilityTRUE
Online Index BuildTRUE
Coalesce IndexTRUE
Managed StandbyTRUE
Materialized view rewriteTRUE
Materialized view warehouse refreshTRUE
Database resource managerTRUE
SpatialTRUE
Visual Information RetrievalTRUE
Export transportable tablespacesTRUE
Transparent Application FailoverTRUE
Fast-Start Fault RecoveryTRUE
Sample ScanTRUE
Duplexed backupsTRUE
JavaTRUE
OLAP Window FunctionsTRUE
Block Media RecoveryTRUE
Fine-grained AuditingTRUE
Application RoleTRUE
Enterprise User SecurityTRUE
Oracle Data GuardTRUE
Oracle Label SecurityFALSE
OLAPTRUE
Table compressionTRUE
Join indexTRUE
Trial RecoveryTRUE
Data MiningTRUE
Online RedefinitionTRUE
Streams CaptureTRUE
File MappingTRUE
Block Change TrackingTRUE
Flashback TableTRUE
Flashback DatabaseTRUE
Data Mining Scoring EngineFALSE
Transparent Data EncryptionTRUE
Backup EncryptionTRUE
Unused Block CompressionTRUE
Oracle Database VaultFALSE
Real Application TestingTRUE
SQL>
---------------------------------------------------------------------------------------------------