Oracle® Database Licensing Information 11g Release 2 (11.2) Part Number E10594-01 |
|
|
View PDF |
This chapter describes the four Oracle Database editions and the features available with those editions. It contains the following sections:
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 purposes. This section describes the Oracle Database editions. The database options and associated 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. The current version of Oracle Database XE is Oracle Database 10g Release 2.
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 2000, Windows NT, Windows XP, and Windows Server 2003 (32-bit and 64-bit versions). The Management Packs are not included in Personal 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. The current version of Oracle Database XE is Oracle Database 10g Release 2.
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 RAC One Node |
N |
N |
Y |
Extra cost option |
Oracle Data Guard—Redo Apply |
N |
N |
Y |
|
Oracle Data Guard—SQL Apply |
N |
N |
Y |
|
Oracle Data Guard—Snapshot Standby |
N |
N |
Y |
|
Oracle Active Data Guard |
N |
N |
Y |
Extra cost option |
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 |
|
Online table redefinition |
N |
N |
Y |
Using the |
Duplexed backup sets |
N |
N |
Y |
|
Incremental backup and recovery |
Y |
Y |
Y |
SE1/SE: no optimized incremental backup |
Unused block compression in backups |
N |
N |
Y |
|
Block-level media recovery |
N |
N |
Y |
|
Lost Write Protection |
N |
N |
Y |
|
Automatic Block Repair |
N |
N |
Y |
Requires Active Data Guard option |
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 |
N |
N |
Y |
|
Flashback Transaction Query |
N |
N |
Y |
|
Oracle Total Recall |
N |
N |
Y |
Extra cost option |
Scalability |
||||
Oracle Real Application Clusters |
N |
Y |
Y |
Extra cost with EE, included with SE |
Automatic Workload Management |
N |
Y |
Y |
Requires Oracle Real Application Clusters |
Performance |
||||
Query Results Cache |
N |
N |
Y |
|
PL/SQL Function Result Cache |
N |
N |
Y |
|
Client Side Query Cache |
N |
N |
Y |
|
In-Memory Database Cache |
N |
N |
Y |
Extra cost option |
Support for Oracle Exadata Storage Server Software |
N |
N |
Y |
|
Security |
||||
Advanced Security Option |
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 |
|
Oracle Database Vault |
N |
N |
Y |
Extra cost option |
Secure External Password Store |
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 |
Oracle Real Application Testing |
N |
N |
Y |
Extra cost option |
Database Resource Manager |
N |
N |
Y |
|
Instance Caging |
N |
N |
Y |
|
SQL Plan Management |
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 |
Oracle Data Quality and Profiling |
N |
N |
Y |
Extra cost option |
Oracle Data Watch and Repair Connector |
N |
N |
Y |
Extra cost option |
Oracle Advanced Compression |
N |
N |
Y |
Extra cost option |
Basic Table Compression |
N |
N |
Y |
|
Bitmapped index and bitmapped join index |
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 |
|
In-memory Parallel Execution |
N |
N |
Y |
|
Parallel Statement Queuing |
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 |
||||
Oracle Streams |
Y |
Y |
Y |
SE1/SE: no capture from redo |
Messaging Gateway |
N |
N |
Y |
|
Basic Replication |
Y |
Y |
Y |
SE1/SE: read-only, updateable materialized view |
Advanced Replication |
N |
N |
Y |
Multi-master replication |
Database Gateways |
Y |
Y |
Y |
Separate product license |
Networking |
||||
Oracle Connection Manager |
N |
N |
Y |
|
Infiniband Support |
N |
N |
Y |
|
Content Management |
||||
Oracle Spatial |
N |
N |
Y |
Extra cost option |
Semantic Technologies (RDF/OWL) |
N |
N |
Y |
Requires Oracle Spatial and the Oracle Partitioning option |
The following features related to application development are available only on Windows platforms:
COM Automation
Microsoft Transaction Server/COM+ integration
Oracle OLE DB Provider
Oracle Objects for OLE (OO4O)
VLM Support
OLE DB .NET and ODBC .NET support
Native .NET Data Provider - ODP .NET
Oracle Database Extensions for .NET (.NET Stored Procedures)
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:
Express Edition is limited to a single instance on any server.
Express Edition may be installed on a multiple CPU server, but may only be executed on one processor in any server.
Express Edition may be used only to support up to 4GB of user data (not including Express Edition system data).
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 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.
The license restrictions for Standard Edition must be adhered to. The maximum number of CPUs defined is for the entire cluster; it is not a per node maximum.
Oracle Automatic Storage Management (Oracle ASM) must be used to manage all database-related files. Third-party volume managers and file systems are not supported for this purpose. Oracle ASM is required for the storage of:
Database data files
Online logs
Archive logs
Control files
Server parameter files (spfiles)
Fast Recovery Area
Voting disk
Oracle Cluster Registry
Local storage must be used for:
Oracle Home
Trace files
Dump files
No Oracle-maintained copies of any of the above files can exist in any other locations, with the following exception: Customers who want to manually script maintenance of a standby database can create a second copy of their archive logs outside of Oracle ASM on a local file system only, designated by the LOG_ARCHIVE_DEST_
n
parameter.
RMAN backups of files can reside on either a local or network mounted file system.
No other cluster software can be installed on the system, including, OCFS, OCFS2, third-party clusterware, third-party cluster volume managers, and third-party cluster file systems.
Grid Infrastructure
The Grid Infrastructure is the foundation of the Oracle Grid. It includes Oracle Clusterware, Oracle Automatic Storage Management (Oracle ASM), ASM Cluster File System (ACFS), and ASM Dynamic Volumes.
Oracle Clusterware provides cluster membership and high availability services. It provides the cluster membership for features such as Oracle Real Application Clusters and Oracle ASM.
Oracle ASM is a storage manager for Oracle database files and file systems.
ACFS is a shared file system enabling simultaneous access to files from multiple nodes.
ASM Dynamic Volumes provides volume manager services, enabling Oracle ASM to host ACFS and other file systems.
The Grid Infrastructure can be installed and used on any server where any of the following conditions are met:
The server OS is supported by a valid Oracle Unbreakable Linux support contract.
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.
Oracle Clusterware is used to protect a software product from failures. Oracle Clusterware can be used to protect a software product in cases that do not meet conditions 1 or 2 above if either of the following conditions are met:
The software being protected is from Oracle
The software being protected uses an Oracle database
A cluster is defined to include all the machines that share the same Oracle Cluster Registry (OCR) and Voting Disk.
Oracle Grid Infrastructure includes the following features:
Oracle Clusterware
Application monitoring, restart, and failover
Cluster membership services
Server monitoring and fencing
Single Client Access Name (SCAN)
Server Pools
Grid Naming Services
Oracle Automatic Storage Management
Dynamic storage rebalancing
Storage mirroring
Online disk add/drop
ASM Cluster File System
Shared file system with concurrent access to files from multiple nodes
Local file system
ASM Dynamic Volumes
Volume management services for ACFS
Volume management services for 3rd-party file systems
Oracle Database Vault and Oracle9i Database Release 2 (9.2.0.8)
A separate Oracle Database 11g 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 11g deployed in this manner may not be used or deployed for other uses.
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 Gateway for ODBC
Oracle Database Gateway for ODBC 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 Gateway for ODBC.
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:
Database Replay: Only the Workload Capture feature is supported, and the captured workload may only be replayed only on Oracle Database 11g. This feature can be used only to facilitate upgrades from Oracle 9i Database Release 2 to Oracle Database 11g.
The functionality available on Oracle Database 10g Release 2 is as follows:
Database Replay: Only the Workload Capture feature is supported, and the captured workload may be replayed only on Oracle Database 11g. This feature can be used only to facilitate upgrades from Oracle Database 10g Release 2 to Oracle Database 11g.
SQL Performance Analyzer: Only the Remote SQL Test Execute and SQL Capture into SQL Tuning Set features are supported. These features can be used only to facilitate upgrades from Oracle9i Database Release 2 and Oracle Database 10g Release 1 to Oracle Database 10g Release 2 or higher. When upgrading to Oracle Database 10g Release 2 from earlier releases (Oracle 9i Database or Oracle Database 10g Release1), Oracle Database 11g is needed to remotely execute SQL on the target database (that is, Oracle Database 10g Release 2). Real Application Testing licensing is required for both systems, Oracle Database 10g Release 2 and Oracle Database 11g.
Oracle Scheduler
Oracle Scheduler is a database feature that provides job scheduling functionality. Execution of jobs on machines where the Oracle database is installed is included with the Oracle Database license. For enterprise scheduling, the execution of jobs on remote machines where no Oracle database is installed is licensed as part of System Monitoring Plug-in for Hosts.
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
Oracle Wallet is a password-protected container used to store authentication and signing credentials, including passwords, private keys, certificates, trusted certificates, and TDE master keys. Oracle Wallet Manager is an application that wallet owners can use to manage and edit the security credentials in their 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 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.
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 a 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 In-Memory Database Cache Option
For the purposes of licensing Oracle In-Memory Database Cache, only the processors on which the TimesTen In-Memory Database component of the In-Memory Database Cache software is installed and/or running are counted for the purpose of determining the number of licenses required.
Oracle Advanced Security and Enterprise User Security
If you wish to use Enterprise User Security in Oracle Database Enterprise Edition, you no longer need to license the Oracle Advanced Security Option for password-based authentication. However, you must license Oracle Internet Directory (OID). If you wish to use stronger authentication alternatives (such as Kerberos or PKI) for Enterprise User Security, you must license Oracle Advanced Security and the Oracle Internet Directory (OID). Any Oracle Advanced Security licenses purchased on or before January 31, 2004, have restricted use of the Oracle Internet Directory (OID) to support enterprise user security. Please contact your Oracle sales representative for additional information.
Restricted-Use Licensing
The following restricted-use licenses are included with Oracle Database 11g in the editions indicated:
A restricted-use license for Oracle Internet Directory (OID) is included with all editions (except for Oracle Database Express Edition) if users use the Directory Naming feature to configure Oracle Net Services. OID may not be used or deployed for other uses. Please contact your Oracle sales representative for additional information on Oracle Internet Directory (OID).
A restricted-use license for Oracle Application Server Containers for J2EE (OC4J) is included with all editions (except for Oracle Database Express Edition). This embedded version is provided solely to support Oracle Enterprise Manager (Database and Grid Control), Advanced Queuing Servlet, Ultra Search, and Warehouse Builder, and may not be used or deployed for other purposes.
A restricted-use license for Oracle HTTP Server is with all editions (except for Oracle Database Express Edition) when the HTTP Server is running on the same server as the database. Running Oracle HTTP server on a different server requires that other server be licensed to use the HTTP server, either through an Oracle Database license or an Oracle Application Server license.
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:
Slowing Changing Dimensions (SCD) Type 2 and 3
XML Files as a target
Transportable ETL modules, multiple configurations, and pluggable mappings
Operators for pluggable mapping, pluggable mapping input signature, pluggable mapping output signature
Design Environment Support for RAC
Target load ordering
Seeded spatial and streams transformations
Process Flow Activity templates
Process Flow variables support
Process Flow looping activities such as For Loop and While Loop
Process Flow Route and Notification activities
Metadata lineage and impact analysis
Metadata change propagation
Schedulable Mappings and Process Flows
Metadata Extensibility
Deployment to Discoverer EUL
Deployment to Oracle BI Beans catalog