Skip Headers
Oracle® Database Licensing Information
10g Release 2 (10.2)

Part Number B14199-25
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

1 Oracle Database Editions

This chapter describes the four Oracle Database editions and the features available with those editions. It contains the following sections:

The Oracle Database Product Family

Oracle Database is available in five editions, each suitable for different development and deployment scenarios. Oracle also offers several database options, packs, and other products that enhance the capabilities of Oracle Database for specific application purposes. This section describes the Oracle Database editions. The database enhancement products are described in Chapter 2, "Options and Packs".

Oracle Database Standard Edition One Oracle Database Standard Edition One delivers unprecedented ease of use, power, and performance for workgroup, department-level, and Web applications. From single-server environments for small business to highly distributed branch environments, Oracle Database Standard Edition One includes all the facilities necessary to build business-critical applications.

Oracle Database Standard Edition Oracle Database Standard Edition delivers the unprecedented ease of use, power, and performance of Standard Edition One, with support for larger machines and clustering of services with Oracle Real Application Clusters (Oracle RAC). Oracle RAC is not included in the Standard Edition of releases prior to Oracle Database 10g, nor is it an available option with those earlier releases.

Oracle Database Enterprise Edition Oracle Database Enterprise Edition provides the performance, availability, scalability, and security required for mission-critical applications such as high-volume online transaction processing (OLTP) applications, query-intensive data warehouses, and demanding Internet applications. Oracle Database Enterprise Edition contains all of the components of Oracle Database, and can be further enhanced with the purchase of the options and packs described in Chapter 2, "Options and Packs".

Oracle Database Express Edition  Oracle Database Express Edition (Oracle Database XE) is an entry-level edition of Oracle Database that is quick to download, simple to install and manage, and is free to develop, deploy, and distribute. Oracle Database XE makes it easy to upgrade to the other editions of Oracle without costly and complex migrations. Oracle Database XE can be installed on any size machine with any number of CPUs, stores up to 4GB of user data, using up to 1GB of memory, and using only one CPU on the host machine. Support is provided by an online forum.

Oracle Database Personal Edition Oracle Database Personal Edition supports single-user development and deployment environments that require full compatibility with Oracle Database Standard Edition One, Oracle Database Standard Edition, and Oracle Database Enterprise Edition.

Personal Edition includes all of the components that are included with Enterprise Edition, as well as all of the options that are available with Enterprise Edition, with the exception of the Oracle Real Application Clusters option, which cannot be used with Personal Edition. Personal Edition is available on Windows platforms only. The Management Packs are not included in Personal Edition.

Feature Availability by Edition

Table 1-1 lists feature availability for Oracle Database Standard Edition One (SE1), Standard Edition (SE), and Enterprise Edition (EE). The Y value in a column means that the feature is available in the specified release; N means that it is unavailable. This table can help you understand the difference between the editions and determine whether you require Enterprise Edition (or Personal Edition for a single-user environment).

Note that Oracle Database XE is a separate product from the rest of the Oracle Database product family. The features available with Oracle Database XE are documented in Oracle Database Express Edition Licensing Information, which is installed along with the product itself.

Table 1-1 Feature Availability for Oracle Database Editions

Feature/Option SE1 SE EE Notes

High Availability

       

Oracle Fail Safe

Y

Y

Y

Windows only

Oracle Data Guard—Redo Apply

N

N

Y

 

Oracle Data Guard—SQL Apply

N

N

Y

 

Rolling Upgrades—Patch Set, Database, and Operating System

N

N

Y

 

Online index rebuild

N

N

Y

 

Online index-organized table organization

N

N

Y

ALTER TABLE ... MOVE ONLINE operations

Online table redefinition

N

N

Y

Using the DBMS_REDEFINITION package

Duplexed backup sets

N

N

Y

 

Block change tracking for fast incremental backup

N

N

Y

 

Unused block compression in backups

N

N

Y

 

Block-level media recovery

N

N

Y

 

Parallel backup and recovery

N

N

Y

 

Tablespace point-in-time recovery

N

N

Y

 

Trial recovery

N

N

Y

 

Fast-start fault recovery

N

N

Y

 

Flashback Table

N

N

Y

 

Flashback Database

N

N

Y

 

Flashback Transaction Query

N

N

Y

 

Scalability

       

Oracle Real Application Clusters

N

Y

Y

Extra cost with EE, included with SE

Automatic Workload Management

N

Y

Y

Requires RAC

Performance

       

In-Memory Database Cache

N

N

Y

Extra cost option

Security

       

Oracle Advanced Security

N

N

Y

Extra cost option

Oracle Label Security

N

N

Y

Extra cost option

Virtual Private Database

N

N

Y

 

Fine-grained auditing

N

N

Y

 

Development Platform

       

SQLJ

Y

Y

Y

Requires Oracle Programmer

Oracle Developer Tools for Visual Studio .NET

Y

Y

Y

Windows only

Microsoft Distributed Transaction Coordinator support

Y

Y

Y

Windows only

Active Directory integration

Y

Y

Y

Windows only

Native .NET Data Provider—ODP.NET

Y

Y

Y

Windows only

.NET Stored Procedures

Y

Y

Y

Windows only

Manageability

       

Oracle Change Management Pack

N

N

Y

Extra cost option

Oracle Configuration Management Pack

N

N

Y

Extra cost option

Oracle Diagnostic Pack

N

N

Y

Extra cost option

Oracle Tuning Pack

N

N

Y

Extra cost option, also requires the Diagnostic Pack

Oracle Provisioning and Patch Automation Pack

N

N

Y

Extra cost option

Database Resource Manager

N

N

Y

 

VLDB, Data Warehousing, Business Intelligence

       

Oracle Partitioning

N

N

Y

Extra cost option

Oracle OLAP

N

N

Y

Extra cost option

Oracle Data Mining

N

N

Y

Extra cost option

Data Compression

N

N

Y

 

Bitmapped index, bitmapped join index, and bitmap plan conversions

N

N

Y

 

Parallel query/DML

N

N

Y

 

Parallel statistics gathering

N

N

Y

 

Parallel index build/scans

N

N

Y

 

Parallel Data Pump Export/Import

N

N

Y

 

Transportable tablespaces, including cross-platform

N

N

Y

Import of transportable tablespaces supported into SE, SE1, and EE

Summary management—Materialized View Query Rewrite

N

N

Y

 

Asynchronous Change Data Capture

N

N

Y

 

Integration

       

Basic Replication

Y

Y

Y

SE1/SE: read-only, updateable materialized view

Advanced Replication

N

N

Y

Multi-master replication

Oracle Streams

N

N

Y

SE1/SE: apply only

Messaging Gateway

N

N

Y

 

Transparent Gateways

Y

Y

Y

Extra cost option

Networking

       

Oracle Connection Manager

N

N

Y

 

Infiniband Support

N

N

Y

 

Content Management

       

Oracle Spatial

N

N

Y

Extra cost option


Features Specific to the Windows Platform

The following features related to application development are available only on Windows platforms:

Special-Use Licensing

Oracle Standard Edition and Oracle Real Application Clusters (Oracle RAC) 

When used with Oracle Real Application Clusters in a clustered server environment, Oracle Database Standard Edition requires the use of Oracle Clusterware. Third-party clusterware management solutions are not supported. When used with Oracle Real Application Clusters, Oracle Advanced Security SSL/TLS is included. Automatic Storage Management (ASM) must be used to manage all database-related files. Third-party volume managers and file systems are not supported for this purpose. For more details see "Oracle Standard Edition and Oracle Real Application Clusters (Oracle RAC)".

Oracle Connection Manager  

Oracle Connection Manager can be installed and used on a machine different from the machine where the Oracle Database is installed and used. It is not necessary to obtain a separate license for the machine running Oracle Connection Manager.

Oracle Database Express Edition Oracle Database Express Edition may be used for free, for the purposes of developing, prototyping and running applications. It can also be used for free to provide demonstrations and training. It may also be distributed for free with any applications. However, any use of the Oracle Database Express Edition is subject to the following limitations:

  1. Express Edition is limited to a single instance on any server.

  2. Express Edition may be installed on a multiple CPU server, but may only be executed on one processor in any server.

  3. Express Edition may be used only to support up to 4GB of user data (not including Express Edition system data).

  4. Express Edition may use up to 1 GB RAM of available memory.

The Oracle technical support organization will not provide technical support, phone support, or updates for Oracle Database Express Edition.

Oracle Clusterware Oracle Clusterware can be installed and used to protect any Oracle or third-party software provided one of the following conditions are met:

  1. The software being protected is from Oracle.

  2. The software being protected uses an Oracle Database.

  3. The software being protected is running on Oracle Unbreakable Linux.

  4. The software being protected is running in a cluster where at least one machine involved in the cluster is licensed using the appropriate metric for either Oracle Database Enterprise Edition or Oracle Database Standard Edition.

A cluster is defined to include all the machines that share the same Oracle Cluster Registry (OCR) and Voting Disk.

Infrastructure Repository Databases A separate Oracle Database can be installed and used as a Recovery Manager (RMAN) repository without additional license requirements, provided that all the Oracle databases managed in this repository are correctly licensed. This repository database may also be used for the Oracle Enterprise Grid Control repository. It may not be used or deployed for other uses.

A separate Oracle Database can be installed and used as an Oracle Enterprise Manager Grid Control (OEM Grid Control) repository without additional license requirements, provided that all the targets (databases, applications, and so forth) managed in this repository are correctly licensed. This database may also be used for the RMAN repository. It may not be used or deployed for other uses.

Oracle Database Vault and Oracle9i Database Release 2 (9.2.0.8) 

A separate Oracle Database 10g Release 2 can be installed and used to administer Oracle Database Vault when installed with Oracle9i Database Release 2 (9.2.0.8), without additional license requirements. All 9.2.0.8 databases managed by Database Control in this manner must be correctly licensed with the Oracle Database Vault option. The installation of Oracle Database 10g Release 2 deployed in this manner may not be used or deployed for other uses.

Support of Real Application Testing in Earlier Releases 

The full functionality of Oracle Real Application Testing is available only on Oracle Database 11g Release 1 or higher. Partial functionality of Oracle Real Application Testing is available to customers wishing to upgrade from Oracle9i Database Release 2 or Oracle Database 10g.

The functionality available on Oracle9i Database Release 2 is as follows:

The functionality available on Oracle Database 10g Release 2 is as follows:

Oracle Secure Backup Express Oracle Secure Backup Express is bundled with the Oracle Database. Oracle's technical support organization will provide technical support, phone support, or updates to you for Oracle Secure Backup Express when it is used to back up another Oracle Product that has a valid Customer Support Identifier (CSI). For example, if Oracle Secure Backup Express is used to back up an Oracle database that has a valid Customer Support Identifier, then Oracle Support provides technical support for the backup of this database.

Updates and technical support are only provided to customers who maintain technical support services for their Oracle licenses in accordance with Oracle's Technical Support Policies. Oracle Secure Backup is a separately licensed product and is supported in accordance with Oracle's Technical Support Policies.

Legato Storage Manager and Legato Single Server Version. Oracle Secure Backup Express is the replacement product for Legato Storage Manager (LSM) and Legato Single Server Version (LSSV). If you are currently using LSM or LSSV, then you can use Oracle Secure Backup Migration Guide to learn how to migrate these products to Oracle Secure Backup Express.

Oracle Secure Backup Express can back up an Oracle database as well as Oracle home files and other file system data requiring tape protection.

For more information, refer to Oracle Secure Backup Licensing Information.

Oracle Wallet 

An Oracle Wallet is a PKCS#12 container used to store authentication and encryption keys. The database secure external password store feature stores passwords in an Oracle Wallet for authentication to the Oracle database. Oracle Advanced Security uses the Oracle Wallet to store credentials for PKI authentication to the Oracle Database, network encryption, and transparent data encryption. Oracle Wallet Manager is an application that wallet owners can use to manage and edit Oracle Wallets. Oracle Wallets can be deployed on clients, middle tiers, and database servers free of charge. However, the following features that use an Oracle Wallet in turn require licensing of the Oracle Advanced Security Option: PKI credentials for authentication to Oracle Database, network encryption (SSL/TLS) to the Oracle database from middle tiers and database clients, and transparent data encryption master keys. Oracle Advanced Security option is not required when configuring wallets to secure communication between the Oracle database and Oracle Internet Directory as part of the enterprise user security feature of Oracle Database.

Current User Database Links

Current user database links are one type of database link that is supported inside the Oracle Enterprise Edition database. Current user database links provide stronger security because they do not require credentials to be stored inside the database link definition. Current user database links require Enterprise User Security and use SSL to secure the communication channel over which the current user database link communicates with the target database. If you wish to use current user database links, you do not need to license Oracle Advanced Security to enable SSL.

Restricted-Use Licensing The following restricted-use licenses are included with Oracle Database 10g in the editions indicated:

Changes in Product Licensing

Oracle Warehouse Builder Enterprise ETL Option

The following features, previously licensed with the Oracle Warehouse Builder ETL Option, are no longer licensed with the Oracle Database. Instead, they are licensed via the Oracle Data Integrator Enterprise Edition: