This chapter describes Oracle Database editions and the features available with those editions. It contains the following sections:
Oracle Database is available in the following 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 2 Oracle Database Standard Edition 2 delivers unprecedented ease of use, power, and performance for workgroup, department-level, and Web applications.
Note: Oracle Database Standard Edition 2 is available starting with Oracle Database 12c Release 1 (12.1.0.2). For 12.1.0.1, Oracle Database Standard Edition One and Oracle Database Standard Edition are available.
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 11 GB of user data, using up to 1 GB 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 11g 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 and Linux platforms only. 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), Standard Edition 2 (SE2), 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 11g Release 2.
Note:
Oracle Database Standard Edition 2 (SE2) is available starting with Oracle Database 12c Release 1 (12.1.0.2). For 12.1.0.1, Oracle Database Standard Edition One (SE1) and Oracle Database Standard Edition (SE) are available.Table 1-1 Feature Availability for Oracle Database Editions
| Feature/Option | SE1 | SE/SE2 | EE | Notes |
|---|---|---|---|---|
|
Consolidation |
||||
|
N |
N |
Y |
Extra cost option for up to 252 pluggable databases. The multitenant architecture with one user-created pluggable database (single tenant) is available in all editions. |
|
|
Snapshots and Cloning |
||||
|
N |
N |
Y |
Requires the Advanced Compression option |
|
|
High Availability |
||||
|
N |
N |
Y |
Requires the Active Data Guard option or the Real Application Clusters option |
|
|
Y |
Y |
Y |
Windows only |
|
|
N |
N |
Y |
Extra cost option |
|
|
N |
N |
Y |
||
|
N |
N |
Y |
Requires the Active Data Guard option |
|
|
N |
N |
Y |
||
|
N |
N |
Y |
||
|
N |
N |
Y |
Requires the Active Data Guard option |
|
|
N |
N |
Y |
Extra cost option |
|
|
N |
N |
Y |
||
|
Rolling Upgrade Using Active Data Guard |
N |
N |
Y |
Requires the Active Data Guard option |
|
N |
N |
Y |
||
|
N |
N |
Y |
|
|
|
N |
N |
Y |
Using the |
|
|
N |
N |
Y |
||
|
N |
N |
Y |
||
|
N |
N |
Y |
||
|
N |
N |
Y |
||
|
N |
N |
Y |
||
|
N |
N |
Y |
Requires the Active Data Guard option |
|
|
N |
N |
Y |
||
|
N |
N |
Y |
||
|
N |
N |
Y |
||
|
N |
N |
Y |
||
|
N |
N |
Y |
||
|
N |
N |
Y |
||
|
N |
N |
Y |
||
|
N |
N |
Y |
||
|
N |
N |
Y |
Basic Flashback Data Archive is in all editions. Optimization for Flashback Data Archive requires EE and the Advanced Compression option. |
|
|
N |
N |
Y |
||
|
N |
N |
Y |
||
|
N |
N |
Y |
||
|
N |
N |
Y |
Requires the Active Data Guard option |
|
|
Recovering tables and table partitions from RMAN backups |
N |
N |
Y |
|
|
Scalability |
||||
|
N |
Y |
Y |
Extra cost with EE, included with SE and SE2 |
|
|
N |
Y |
Y |
Requires the Real Application Clusters option |
|
|
N |
N |
Y |
Requires the Real Application Clusters option |
|
|
Performance |
||||
|
N |
N |
Y |
||
|
N |
N |
Y |
||
|
N |
N |
Y |
||
|
N |
N |
Y |
Extra cost option |
|
|
N |
N |
Y |
Solaris and Oracle Linux only |
|
|
N |
N |
Y |
||
|
Adaptive Execution Plans |
N |
N |
Y |
|
|
Concurrent Execution of |
N |
N |
Y |
|
|
(Note 1) |
N |
N |
Y |
Requires the Database In-Memory option |
|
Fault Tolerant In-Memory Column Store (Note 1) |
N |
N |
Y |
Requires the Database In-Memory option, the Real Application Clusters option, and Exadata or Supercluster |
|
(Note 1) |
N |
N |
Y |
Requires the Database In-Memory option |
|
(Note 1) |
N |
N |
Y |
|
|
(Note 1) |
N |
N |
Y |
Requires the Partitioning option, and Exadata or Supercluster |
|
Security |
||||
|
N |
N |
Y |
Extra cost option |
|
|
N |
N |
Y |
Extra cost option |
|
|
N |
N |
Y |
Extra cost option |
|
|
N |
N |
Y |
Enterprise User Security is an EE feature for directory-based management of database users. It requires a corresponding Oracle Identity Management Directory Services Plus to be licensed. Usage of Enterprise User Security with Oracle Database strong authentication (PKI, Kerberos) no longer requires Oracle Advanced Security to be licensed. |
|
|
N |
N |
Y |
||
|
Privilege Analysis |
N |
N |
Y |
Requires the Database Vault option |
|
N |
N |
Y |
||
|
N |
N |
Y |
Requires Oracle Advanced Security |
|
|
Secure External Password Store |
N |
N |
Y |
|
|
Transparent Sensitive Data Protection |
N |
N |
Y |
|
|
N |
N |
Y |
||
|
Development Platform |
||||
|
Y |
Y |
Y |
Requires Oracle Programmer |
|
|
Y |
Y |
Y |
Windows only |
|
|
Y |
Y |
Y |
Windows only |
|
|
Y |
Y |
Y |
Windows only |
|
|
Y |
Y |
Y |
Windows only |
|
|
Y |
Y |
Y |
Windows only |
|
|
Manageability |
||||
|
N |
N |
Y |
Extra cost option |
|
|
Oracle Data Masking and Subsetting Pack for Oracle and Non-Oracle Databases |
N |
N |
Y |
Extra cost option |
|
Oracle Database Lifecycle Management Pack for Oracle Database |
N |
N |
Y |
Extra cost option |
|
N |
N |
Y |
Extra cost option |
|
|
N |
N |
Y |
Extra cost option, also requires Oracle Diagnostics Pack |
|
|
N |
N |
Y |
Extra cost option |
|
|
N |
N |
Y |
CPU resource management is available on all platforms; I/O resource management requires Exadata or Supercluster storage |
|
|
N |
N |
Y |
||
|
N |
N |
Y |
||
|
(Note 1) |
N |
N |
Y |
When deployed across multiple clusters, requires Lifecycle Management Pack on targets |
|
VLDB, Data Warehousing, Business Intelligence |
||||
|
N |
N |
Y |
Extra cost option |
|
|
N |
N |
Y |
Extra cost option |
|
|
N |
N |
Y |
Extra cost option |
|
|
N |
N |
Y |
Extra cost option |
|
|
(Note 1) |
N |
N |
Y |
Requires the Advanced Compression option |
|
N |
N |
Y |
||
|
N |
N |
Y |
Requires Exadata, Supercluster, ZFS, Axiom, or FS1 storage |
|
|
Hybrid Columnar Compression Row-Level Locking (Note 1) |
N |
N |
Y |
Requires the Advanced Compression option, and Exadata, Supercluster, ZFS, or FS1 storage |
|
N |
N |
Y |
Requires the Advanced Compression option, and Exadata or Supercluster |
|
|
N |
N |
Y |
Requires the Advanced Compression option |
|
|
N |
N |
Y |
Requires the Advanced Compression option |
|
|
N |
N |
Y |
||
|
N |
N |
Y |
||
|
Bitmapped index, bitmapped join index, and bitmap plan conversions |
N |
N |
Y |
|
|
N |
N |
Y |
||
|
N |
N |
Y |
||
|
N |
N |
Y |
||
|
N |
N |
Y |
||
|
N |
N |
Y |
||
|
N |
N |
Y |
||
|
N |
N |
Y |
||
|
Transportable tablespaces, including cross-platform and full transportable export and import |
N |
N |
Y |
Import of transportable tablespaces supported into SE, SE1, SE2, and EE |
|
N |
N |
Y |
||
|
Integration |
||||
|
Y |
Y |
Y |
SE/SE1/SE2: read-only, updateable materialized view |
|
|
N |
N |
Y |
Multi-master replication |
|
|
Y |
Y |
Y |
SE/SE1/SE2: no capture from redo |
|
|
Y |
Y |
Y |
Separate product license |
|
|
N |
N |
Y |
||
|
Sharded Queues |
N |
N |
Y |
Requires the Partitioning option |
|
Networking |
||||
|
N |
N |
Y |
Available via a custom install of the Oracle Database client, usually installed on a separate machine See "Oracle Connection Manager" for more information |
|
|
N |
N |
Y |
||
|
Network Compression |
N |
N |
Y |
Requires the Advanced Compression option |
|
Network Encryption (SSL/TLS) |
Y |
Y |
Y |
|
|
Spatial and Graph Data |
||||
|
N |
N |
Y |
Extra cost option |
|
|
N |
N |
Y |
Requires the Spatial and Graph option and the Partitioning option |
|
|
N |
N |
Y |
||
|
Multimaster replication of |
N |
N |
Y |
Single master/materialized view replication for |
|
N |
N |
Y |
Requires the Partitioning option |
Note 1: This feature is available starting with Oracle Database 12c Release 1 (12.1.0.2).
Table 1-2 lists feature availability for Oracle Engineered Systems and Oracle Storage.
Note:
Transparent features (such as smart scans and storage indexes) are not listed.Table 1-2 Feature Availability for Oracle Engineered Systems and Oracle Storage
| Feature | Exadata | Supercluster | ZFS | Axiom | FS1 | Notes |
|---|---|---|---|---|---|---|
|
Y |
Y |
Y |
Y |
Y |
||
|
Y |
Y |
Y |
N |
Y |
Requires the Advanced Compression option |
|
|
Y |
Y |
N |
N |
N |
Requires the Advanced Compression option |
|
|
Y |
Y |
N |
N |
N |
Requires the Partitioning option |
|
|
Y |
Y |
N |
N |
N |
Requires the Database In-Memory option and the Real Application Clusters option |
|
|
Y |
Y |
N |
N |
N |
The following features related to application development are available only on Windows platforms:
The following sections describe special-use licensing:
Infrastructure Repository Databases
A separate single instance Oracle Database can be installed and used as an infrastructure repository for RMAN, Oracle Enterprise Manager Cloud Control, Automatic Workload Repository (AWR) Warehouse, Global Data Services Catalog, and Grid Infrastructure Management Repository without additional license requirements, provided that all the targets are correctly licensed. It may not be used or deployed for other uses.
The infrastructure repositories for RMAN, Oracle Enterprise Manager Cloud Control, AWR Warehouse, and Global Data Services Catalog can be shared in one database, or deployed in separate databases. Enterprise Edition must be used for the infrastructure repository database(s).
If Oracle RAC is used for the infrastructure database, then Oracle RAC licenses for all servers, and Enterprise Edition licenses for all but the first server, are required.
If Data Guard is used for the infrastructure database, then an Enterprise Edition license for the standby server is required.
The far sync instance can be installed and used on a server different from the server where the Oracle Database is installed and used. It is not necessary to obtain a separate license for the server running the far sync instance.
The GSM listener can be installed and used on a server different from the server where the Oracle Database is installed and used. It is not necessary to obtain a separate license for the server running the GSM listener.
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 Kerberos and PKI based authentication. It does require a corresponding Oracle Identity Management Directory Services Plus to be licensed.
Any Oracle Advanced Security licenses purchased on or before January 31, 2004, have restricted use of the Oracle Internet Directory (OID) component of Oracle Directory Services Plus to support enterprise user security.
Oracle ASM Cluster File System (Oracle ACFS)
Refer to following table for the license requirements that apply to the Oracle ACFS features:
| Oracle ACFS Features | Oracle Database Files | Non-Oracle Database Files |
|---|---|---|
| All Oracle ACFS features other than those listed below | Free | Free |
| ACFS Snapshot | Requires Oracle Database Enterprise Edition* | Free |
| ACFS Encryption | Not available (use Oracle Transparent Data Encryption, part of the Oracle Advanced Security option*) | Free |
| ACFS Security | Not available (use Oracle Database Vault*) | Free |
| ACFS Replication | Not available (use Oracle Data Guard*) | Free |
| ACFS Auditing | Not available (use Oracle Audit Vault*) | Free |
| ACFS Tagging | Free | Free |
Oracle will provide support services for Oracle ACFS only if the server it operates on also operates an Oracle product, which may include Oracle Linux or Oracle Solaris, which is under an Oracle support contract.
* Requires appropriate full-use licenses to these products or components.
Oracle Clusterware provides cluster membership and high availability monitoring and failover. Oracle Clusterware may be used to protect any application (restarting or failing over the application in the event of a failure) on any server, free of charge. Oracle will provide support for Clusterware only if the server is running an Oracle product, which may include Oracle Linux or Oracle Solaris, that is also under Oracle support.
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 Backup Service
Oracle Database Backup Service includes use of two optimizations at no additional cost. These optimizations are normally available only with the purchase of the Oracle Advanced Security Option or the Oracle Advanced Compression Option. This Oracle Database Backup Service special-use licensing includes:
RMAN backup encryption
All RMAN backup compression algorithms
To use additional features of the Oracle Advanced Security Option or the Oracle Advanced Compression Option, you must license those options separately. In addition, the Oracle Advanced Security Option must be licensed when performing RMAN encrypted backups directly to disk.
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 11 GB 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 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.
Oracle Database Provider for DRDA
Oracle Database Provider for DRDA 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 Database Provider for DRDA.
Oracle Database 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 is required for creating and managing all Oracle database file types. Raw volumes, partitions, or third-party cluster file systems are not supported for storing Oracle database files with Oracle Standard Edition and Oracle RAC. Refer to Oracle Automatic Storage Management Administrator's Guide for a comprehensive list of all database file types.
ASM Cluster File System (ACFS) or a local OS file system must be used to store all non-database files. No Oracle-maintained copies of any non-database files can exist in any other locations, with the following exceptions:
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.
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 and Oracle Secure Backup Cloud Module
For backup of Oracle Database Enterprise Edition, Oracle Secure Backup includes restricted-use licenses for:
RMAN backup encryption to tape or Amazon S3
RMAN backup compression leveraging LOW, MEDIUM, BASIC or HIGH algorithms
The Oracle Secure Backup special-use licenses apply to RMAN backup encryption, which is a component of the Oracle Advanced Security Option, and RMAN backup compression levels, which are components of the Oracle Advanced Compression Option. To use additional features of the Oracle Advanced Security Option or the Oracle Advanced Compression Option, you must license those options separately. In addition, the Oracle Advanced Security Option must be licensed when performing RMAN encrypted backups directly to disk whether or not Oracle Secure Backup is the media manager.
Oracle Secure Backup Express is bundled with the Oracle Database. Support for Oracle Secure Backup Express is provided exclusively through a free Oracle Discussion Forum monitored by Oracle employees as well as community experts.
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.
An Oracle Wallet is a PKCS#12 container used to store authentication and encryption keys. The Oracle database secure external password store feature stores passwords in an Oracle Wallet for password-based authentication to the Oracle database. The Oracle Wallet may also be used to store credentials for PKI authentication to the Oracle Database, configuration of network encryption (SSL/TLS), and Oracle Advanced Security transparent data encryption (TDE) master encryption keys. Strong authentication services (Kerberos, PKI, and RADIUS) and network encryption (native network encryption and SSL/TLS) are no longer part of Oracle Advanced Security and are available in all licensed editions of all supported releases of the Oracle database.
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 or higher.
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.
XStream provides application programming interfaces (APIs) that enable client applications to receive real-time data changes from an Oracle database (using XStream Out APIs) and to send real-time data changes to an Oracle database (using XStream In APIs). These data changes can be shared between Oracle databases and other systems, such as filesystems and non-Oracle databases. XStream is licensed via the Oracle GoldenGate product. You must purchase a license for this product before using the XStream APIs. Please contact your Oracle sales representative for additional information.
The following restricted-use licenses are included with Oracle Database 12c in the editions indicated:
A restricted-use license for Oracle Identity Management Directory Services Plus component 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.
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 Cloud Control), Advanced Queuing Servlet, Ultra Search, Application Express, and Warehouse Builder, and may not be used or deployed for other purposes.
A restricted-use license for Oracle HTTP Server is included 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.
A restricted-use license for Oracle Application Express Listener is included with all editions (except for Oracle Database Express Edition) solely to support connectivity to Oracle Application Express, which may be installed in the Oracle Database. Running Oracle Application Express Listener on a different server does not require that that server be licensed to use the Oracle Database.
Restricted-use licenses of Load Testing Accelerator for Oracle Database, Oracle Load Testing, and Oracle Load Testing Controller are included with Oracle Real Application Testing for use for Oracle Database testing and may not be used for application testing.
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