Oracle® Database Licensing Information 11g Release 2 (11.2) Part Number E10594-01 |
|
|
View PDF |
This chapter describes the separately licensed Oracle Database options, management packs, and other products you can purchase to enhance the capabilities of Oracle Database in specific application environments. This chapter contains the following sections:
You may not use the options, packs, or products described below without separately purchased licenses. The fact that these options, packs, or products may be included in product CDs or downloads or described in documentation that you receive does not authorize you to use them without purchasing appropriate licenses.
All the Oracle Database options can be purchased with Oracle Database Enterprise Edition. Oracle Real Application Clusters (Oracle RAC) is included with Oracle Database Standard Edition. You cannot purchase any options with Oracle Database Standard Edition One or Oracle Express Edition. The Personal Edition includes all options except Oracle RAC at no additional cost.
This section describes the following database options:
Oracle Active Data Guard enhances the Quality of Service (QoS) for production databases by off-loading resource-intensive operations to one or more standby databases, which are synchronized copies of the production database. With Oracle Active Data Guard, a physical standby database can be used for real-time reporting, with minimal latency between reporting and production data. Compared with traditional replication methods, Active Data Guard is very simple to use, transparently supports all datatypes, and offers very high performance. Oracle Active Data Guard also allows backup operations to be off-loaded to the standby database, and be done very fast using intelligent incremental backups. Oracle Active Data Guard thus is a very effective way to insulate interactive users and critical business tasks on the production system from the impact of such long-running operations. Oracle Active Data Guard provides the additional benefit of high availability and disaster protection by quickly failing over to the standby database in the event of a planned or an unplanned outage at the production site.
The Active Data Guard option contains the following features:
Physical Standby with Real-time Query
Fast Incremental Backup on Physical Standby
Automatic Block Repair
If a physical standby database in a Data Guard configuration has any of the above features enabled, then the Active Data Guard option must be licensed for every such physical standby, and also for the primary database.
Oracle Advanced Compression provides comprehensive data compression capabilities to compress all types of data, backups, and network traffic in an application transparent manner. With Advanced Compression, Oracle includes table compression targeted at OLTP workloads, resulting in reduced storage consumption and improved query performance while incurring minimal write performance overhead. Advanced Compression can be used to compress any unstructured content using SecureFiles Compression. Deduplication provides the ability to automatically eliminate redundant copies of SecureFiles data. RMAN offers multiple backup compression levels, to meet the needs of various environments, including faster compression and better compression ratio choices. Note that the RMAN
DEFAULT
COMPRESS
option does not require Advanced Compression. With Advanced Compression, Data Pump exports can now be compressed to reduce disk space requirements. Note that the COMPRESSION=METADATA_ONLY
option for Data Pump does not require Advanced Compression, and is the default behavior. Finally, Data Guard can compress redo data resulting in reduced network traffic and faster gap resolution.
The Oracle Advanced Compression option contains the following features:
Data Guard Network Compression
Data Pump Compression (COMPRESSION=METADATA_ONLY
does not require the Advanced Compression option)
Multiple RMAN Compression Levels (RMAN
DEFAULT
COMPRESS
does not require the Advanced Compression option)
OLTP Table Compression
SecureFiles Compression and Deduplication
Oracle Advanced Security provides transparent data encryption of data stored in the database, the encryption of disk-based backups of the database, and also network encryption for data traveling across the network between the database and client or mid-tier applications. In addition it provides a complete suite of strong authentication services to Oracle Database. Network encryption is implemented using industry-standard data encryption and data integrity algorithms. This feature provides a choice of algorithms and cipher strengths for deployment. Strong authentication services support a comprehensive suite of industry-standard third-party authentication options. The authentication options include single sign-on services to the Oracle Database by interoperating with existing authentication frameworks and two-factor authentication choices such as smart cards and token cards.
Oracle Advanced Security includes the following features:
Transparent Data Encryption (TDE) for columns
Transparent Data Encryption (TDE) for tablespace
Transparent Data Encryption (TDE) for SecureFiles
DataPump Export File encryption
RMAN backup encryption
Hardware Security Module (HSM) TDE Master Key Protection
Database strong authentication support (PKI, Kerberos, Radius)
Smartcard support (PKCS#11)
Transport Layer Security (TLS) Support
Native network encryption
SSL/TLS network encryption
SSL acceleration
Certificate Revocation List (CRL) support
Oracle Data Mining enables you to build advanced business intelligence applications that mine corporate databases, reveal new patterns and relationships, and integrate that information into business applications. This option embeds data mining functionality into Oracle Database for making classifications, predictions, and associations. All model-building, scoring, and metadata management operations are accessible by way of either a Java or PL/SQL API.
The Oracle Data Mining option includes the following features:
APIs and GUIs Supported to Access Algorithms:
PL/SQL API—for model build, model apply, and data transformations
Java API—for model build, model apply & data transformations
Oracle Data Miner (GUI)
Spreadsheet Add-in for Predictive Analytics
Algorithm Category and Supported Algorithms:
Classification
Naive Bayes
Decision Trees
Support Vector Machines
Logistic Regression
Regression
Multivariate Linear Regression
Support Vector Machines
Anomaly Detection
One Class Support Vector Machines
Attribute Importance
Minimum Description Length
Association Rules
A Priori
Clustering
Hierarchical K-Means Clustering
Hierarchical O-Clustering
Predictive Analytics (PL/SQL Packages)
Predict
Explain
Profile
Feature Extraction
Nonnegative Matrix Factorization
The Data Quality and Profiling option enables you to convert raw data into quality information. Developers and data librarians can gain insight into their data and identify previously unknown data quality problems. Subsequently, developers can define rules and generate mappings that correct the data. Based on the data rules, developers can also create data auditors to ensure the quality of incoming data on a repeated basis.
To write corrected data back into a source system, see "Oracle Data Watch and Repair Connector".
The Oracle Data Quality and Profiling option includes the following features:
Data Profiling
Data Rules
Data Auditors
Data Auditor Monitor Usage in Process Flows
Data Corrections
Use this in conjunction with the Oracle Data Quality and Profiling Option. This combination of options constitutes a Data Watch and Repair solution. You can profile and cleanse data in the database and write the corrected data back into the source application.
Oracle Database Vault lets you control who, when, and where data and applications can be accessed—protecting your business against the most common security threat: malicious internal users. Enforcing separation of duties, even among administrators, Oracle Database Vault additionally serves as a powerful preventive control to help comply with today's stringent compliance and privacy requirements.
It improves your ability to meet compliance requirements like Sarbanes-Oxley and other regulations that mandate control of access to, and release of, sensitive information
It controls access to application and database data, even by super-users and other highly privileged users
It enforces multi factor authorization via flexible business rules
It shows who is accessing what and when via over three dozen out-of-the-box security reports
Oracle Database Vault is an option for Oracle Database 10g or later. However, it has also been provided for earlier releases as well, including Oracle9i Database Release 2 (9.2.0.8) on a limited number of platforms. Please contact your Oracle Sales Representative if you are interested in Oracle Database Vault as an option on Oracle9i Database.
The Oracle Database Vault option includes the following features:
Realms
Separation of Duty
Factors
Command Rules
Rule Sets
Oracle In-Memory Database Cache enables you to improve application transaction response time by caching a performance critical subset of tables from an Oracle Database to the application tier. Applications perform read/write operations on the cache tables using standard SQL with automatic persistence, transactional consistency, and data synchronization with the Oracle database.
Oracle In-Memory Database Cache includes the following features:
Data access using PL/SQL, JDBC, ODBC, ttClasses, OCI, and Pro*C/C++ interfaces
Transaction Log API (XLA) for change notification
In-memory Database Cache Grid
Automatic data synchronization with the Oracle database
Transactional replication between the in-memory cache databases
Automated failure detection and database failovers
TimesTen Extension for Oracle SQL Developer
TimesTen Plug-in for Oracle Enterprise Manager
Oracle Label Security provides sophisticated and flexible security based on row labels for fine-grained access control. This option employs labeling concepts used by government, defense, and commercial organizations to protect sensitive information and provide data separation. It includes a powerful tool to manage policies, labels, and user label authorizations.
By default, Oracle Label Security is configured to use Oracle Database for all policy management. Users interested in centralized policy management using the Oracle identity management infrastructure must additionally license Oracle Identity and Access Management Suite. Please contact your Oracle sales representative for additional information.
The Oracle Label Security option includes the following features:
Label based access control (LBAC)
Multi-level security (MLS)
Label factors for Database Vault (Confidential, Sensitive)
User label authorizations (Confidential, Sensitive: PII)
Data labels (Sensitive: PII)
The OLAP option to Oracle Database is a full-featured OLAP server embedded in Oracle Database Enterprise Edition. Oracle OLAP cube datatypes improve business intelligence tools and applications by providing excellent query performance, rich analysis, and fast incremental updates of data sets. OLAP cubes are easily queried by SQL-based business intelligence tools through cube-organized materialized views and OLAP cube views. Cube-organized materialized views provide an alternative summary management solution to table-based materialized views. As with a table-based materialized view, an OLAP cube is accessed by SQL-based tools transparently using the automatic SQL query rewrite feature of the materialized views. SQL-based tools can access both summary data and rich analytic content directly through OLAP cube views. Multidimensional OLAP tools can provides a full-dimensional OLAP experience using the Oracle OLAP multidimensional API to cubes. A single OLAP cube can service each of these types of applications.
The Oracle OLAP option includes the following features:
OLAP Cube Definition, Storage, and Querying
OLAP API and Metadata
OLAP Cube Materialized Views
Analytic Workspaces
SQL Access to OLAP Cubes
Oracle Partitioning enhances the data management environment for OLTP, data mart, data warehouse, and content management applications by adding significant manageability, availability, and performance capabilities to large underlying database tables and indexes. Oracle Partitioning lets you store large tables as individually managed smaller pieces, while retaining a single application-level view of the data.
The Oracle Partitioning option includes the following features:
Table Partitions and Subpartitions
Local Index Partitions and Subpartitions
Global Index Partitions and Subpartitions
Range Partitioning
Hash Partitioning
List Partitioning
Interval Partitioning
Reference Partitioning
System Partitioning
Virtual Column-based Partitioning
Composite Partitioning
Subpartition Template
Fast Partition Split
Partition Exchange
Oracle RAC One Node is the one-node version of Oracle Real Application Clusters (Oracle RAC). It enables customers to standardize on a single deployment model for all their database needs. Oracle RAC One Node makes the database highly available in the presence of computer hardware failures, software failures, or planned software maintenance events. In the event of failures, the database instance is restarted on an available server in the cluster and the client connections are moved to the new instance. Oracle RAC One Node can be online upgraded to full Oracle RAC (RAC license required) in order to scale to multiple servers.
Oracle RAC One Node includes the following features:
Database Cold Failover to another node in the cluster in case of server or instance failure
Online migration of the database instance to another server
Support for online rolling upgrades of the database, grid infrastructure, and OS homes
Online upgrade to Oracle Real Application Clusters
Policy-managed Server Pools
ASM Cluster File System snapshots
Oracle Real Application Clusters (Oracle RAC) is a database computing environment that harnesses the processing power of multiple interconnected computers using clustering technology. Oracle RAC enables multiple servers to mount a single databases, providing unlimited scalability and high availability for all applications. Oracle RAC makes the database highly available in the presence of computer hardware or software failure: in the event any computer in the cluster fails, the database continues to provide service on the surviving computers in the cluster. Oracle RAC provides scalable performance: as demand for database throughput grows, additional computers can be added to the database cluster with no downtime. Oracle RAC also supports a single-system image for ease of management.
Oracle Real Application Clusters includes the following features:
Real Application Clusters
Connection Load Balancing
Fast Connection Failover
Hot Cluster Failover
Includes all the capabilities of Oracle RAC One Node
The Oracle Real Application Testing option comprises a suite of features that help protect database applications from undesirable impact of routine changes such as hardware/software upgrades, configuration changes, platform migrations, and so forth. These features enable comprehensive testing of real-world applications so that any issues resulting from system changes are fully identified and addressed during testing, and unexpected problems encountered when a change is finally made in the production systems are minimized.
The Oracle Real Application Testing option includes the following features:
Database Replay
SQL Performance Analyzer (SPA)
SQL Tuning Sets (STS)
In order to use the features listed above, you must purchase licenses for the Oracle Real Application Testing option, with one exception: SQL Tuning Sets (STS) can be used if you have licensed either Oracle Tuning Pack or Oracle Real Application Testing. Oracle Real Application Testing functionality can be accessed by Enterprise Manager as well as through the database server command-line APIs. The use of either interface requires an Oracle Real Application Testing option license.
In addition, the use of the 'Replay Compare Period Report' requires a license of Oracle Diagnostics Pack.
The Database Replay feature can also be accessed by way of database server APIs and command-line interfaces:
DBMS_WORKLOAD_CAPTURE
package is part of the Oracle Real Application Testing option
DBMS_WORKLOAD_REPLAY
package is part of the Oracle Real Application Testing option
The use of the DBMS_WORKLOAD_REPLAY
.COMPARE_PERIOD_REPORT()
function also requires a license of Oracle Diagnostics Pack.
The SQL Performance Analyzer feature can also be accessed by way of database server APIs and command-line interfaces:
DBMS_SQLPA
package is part of Oracle Real Application Testing option
SQL Tuning Sets can also be accessed by way of database server APIs and command-line interfaces. The following subprograms, part of the DBMS_SQLTUNE
package, provide an interface to manage SQL tuning sets and are part of the Oracle Real Application Testing option:
ADD_SQLSET_REFERENCE
CAPTURE_CURSOR_CACHE_SQLSET
CREATE_SQLSET
CREATE_STGTAB_SQLSET
DELETE_SQLSET
DROP_SQLSET
LOAD_SQLSET
PACK_STGTAB_SQLSET
REMOVE_SQLSET_REFERENCE
SELECT_CURSOR_CACHE
SELECT_SQLSET
SELECT_WORKLOAD_REPOSITORY
UNPACK_STGTAB_SQLSET
UPDATE_SQLSET
The Oracle Real Application Testing license is required on both capture and replay systems for Database Replay and is charged by the total number of CPUs on those systems.
Oracle Spatial provides advanced spatial analysis features for complex geographic information systems (GIS) applications, enterprise applications, and location-based services applications. It augments the Oracle Locator feature, which provides storage, analysis, and indexing of location data accessible through SQL and standard programming languages, supporting seamless integration of location data into enterprise applications, and use of any leading third-party GIS tool to access location data. Oracle Spatial advanced features include GeoRaster for storage, indexing, and analysis of image and gridded raster data, such as satellite imagery and remotely sensed data; a network data model that allows users to model and analyze link-node networks (graphs) for applications; a topology data model and schema to persistently manage topology; a fully functional geocoding engine and routing engine; location-based analysis functions for business intelligence applications, including location-based classification, binning, association, and correlation; and support for 3D and point cloud data used in visualization, city modeling, simulations and Lidar-based map production. Oracle Spatial also supports spatial data manipulation and analysis such as buffer generation, area/distance calculations, linear referencing, and more.
Note:
Oracle Locator, a feature of Oracle Database 11g (XE, SE1, SE, and EE), includes the spatial vector geometry type, spatial indexing and operators, and a limited set of spatial functions.For detailed lists of functions included in Locator and those included only in Oracle Spatial option, please refer to Appendix B of Oracle Spatial Developer's Guide.
Oracle Spatial also includes Semantic database features including support for W3C Resource Description Framework (RDF) triple storage, indexing and querying, Web Ontology Language (OWL), ontology management, and semantic inferencing.
Note:
The Semantic database features in Oracle Spatial require the Oracle Partitioning option.The Oracle Spatial option includes the following features:
Selected Spatial Functions
Linear Referencing System
GeoRaster Storage, Indexing and Querying
Network Data Model
Topology Data Model
Spatial Analysis and Mining Functions
Spatial Routing Engine
Geocoding Engine
Spatial Web Services (new with 11g)
3-D Geometry, Surface, and Point Cloud Storage, Indexing and Querying (new with 11g)
Semantic Content Storage, Indexing and Querying (RDF/OWL Support)
Oracle Total Recall provides the ability to transparently track and archive historical changes to all data stored in an Oracle database. History data is stored in a secure and highly optimized storage and can be accessed in a seamless manner using Flashback Queries. With Total Recall, you can enable history tracking on tables instantaneously and retain the history data any length of time. In addition, Total Recall provides for easier manageability by automating purge of historical data based on specified retention policy. History tracking is non-intrusive and completely transparent to applications. Flashback queries are supported across most DDL changes; complex DDL changes are accommodated with the Associate/Disassociate feature.
The Oracle Total Recall option includes the following features:
Flashback Data Archive
Associate/Disassociate
The sections that follow describe the Oracle management packs. The management packs can be purchased only with Enterprise Edition. The features in these packs are accessible through Oracle Enterprise Manager Database Control, Oracle Enterprise Manager Grid Control, and APIs provided with Oracle Database software.
This section describes the following management packs:
Oracle Change Management Pack enables administrators to evaluate, plan, and implement database schema changes. Using Oracle Change Management Pack, administrators can investigate and track changes, compare and synchronize objects and schemas, modify schema objects, evaluate the change impact, and if required undo changes that have been made previously. Oracle Change Management Pack makes change management simple and efficient and minimizes chances for error, thereby reducing the opportunity for data loss and system down-time.
Oracle Change Management Pack includes the following features:
Dictionary Baselines
Dictionary Comparisons
Dictionary Synchronizations
Realtime Schema Change Tracking
Reverse Engineering Dictionary objects
Copying Dictionary Object
Object Definition Update
Evaluate Change Impact
Clone and Propagate Schema
The following licensed pages and links in Enterprise Manager apply to Oracle Change Management Pack.
From the Enterprise Manager Home page, select the Schema property page. In the Change Management section, the following links and associated pages are licensed as part of the pack:
Dictionary Baselines: All links, buttons, and drilldowns on this page are licensed features of this pack.
Dictionary Comparisons: All links, buttons, and drilldowns on this page are licensed features of this pack.
Dictionary Synchronizations: All links, buttons, and drilldowns on this page are licensed features of this pack.
The Configuration Management Pack for Oracle Database automates the time-consuming, costly, and often error-prone process of software configuration, software and hardware inventory tracking, patching, policy management, and compliance, ensuring consistency across deployments. You can access the Configuration Management Pack for Oracle Database functionality through Enterprise Manager licensed links and by installing the Configuration Change Console and Application Configuration Console. All three of these components comprise the features provided by the Configuration Management Pack for Oracle Database.
Note:
To obtain all features of the Configuration Management Pack for Oracle Database, you need to enable the Configuration Management Pack for Non-Oracle Systems in Grid Control for the host on which you have the licensed Configuration Management Pack for Oracle Database. If you already have the licensed Pack for Oracle Database, you are entitled to the Configuration Management Pack for Non Oracle Systems for the host on which you have the Configuration Management Pack for Oracle Database.Oracle Configuration Management Pack includes the following features:
Database and host configuration management
Patching
Policy and security management
Policy groups
Deployments/installations, including patch-level
Client system analyzer
Security at a glance
Real-time configuration change detection
Application configuration management
The following licensed pages and links in Enterprise Manager apply to Oracle Configuration Management Pack:
Grid Control Home page:
All links in the All Targets Policy Violations section
Database, Hardware, and Operating System related information in the Deployments Summary section
All links in the Security Policy Violations section
All links in the Critical Patch Advisories for Oracle Homes section
From the Grid Control Home page, click the Targets tab, then the Databases sub-tab. On the Databases page, the Policy Violations links are licensed as part of the pack.
From the Grid Control Home page, click the Deployments tab. On the Deployments page, the following items are licensed as part of the pack:
All links in the Configuration and Client Configurations sections
From the Grid Control Home page, select the Compliance tab to display the Policy Violations page, which is grouped in the Violations sub-tab. All links, sub-navigation tabs, and features available on or linked to from the Grid Control Policies Violations page for policies related to databases and hosts are licensed as part of this pack.
From the Grid Control Home page, select the Compliance tab, then the Policy Groups sub-tab. On the Grid Control Policy Group Evaluation Results page, all links and features are licensed as a part of this pack.
From the Grid Control Home page, select the Compliance tab, then the Security at a Glance sub-tab. On the Grid Control Security at a Glance page, all links and features are licensed as a part of this pack.
From the Grid Control Hosts page, click a specific host to display the Host Home page. The following links are licensed as part of the pack:
All links in the Security section
Under Related Links, the following links are licensed:
Deployments
Metric and Policy Settings
From the Host Home page, click the Targets tab. The following links and columns are licensed:
Policy Violations and associated links
Compliance Score (%)
From the Host Home page, click the Configuration tab. The following buttons are licensed:
Save
History
Compare Configuration
Compare to Multiple Configurations
From the Grid Control Home page, click the Targets tab, then select the Systems sub-tab. On the Systems page, the following items are licensed as part of the pack:
Policy Violations links
From the Systems page, click any system Name. On the System Home page, everything is licensed as part of the pack except for the Status and Alerts sections.
From the Grid Control Home page, click the Targets tab, then select the Groups sub-tab. On the Groups page, the following items are licensed as part of the pack:
Policy Violations links
From the Groups page, click any group Name. On the Group Home page, everything is licensed as part of the pack except for the Status and Alerts sections.
From the Groups Home page, click the Administration tab. The following links and features are licensed features of the pack:
Hardware and Operating Systems related information in the Deployments Summary section
Host Operating System and Hardware Summaries selection for the Configuration Searches section
Click the Setup link on the upper right corner of the Enterprise Manager console, then click the Monitoring Templates link. On the Monitoring Templates page, click any Name. The Policies sub-tab on the View Monitoring Template page is a licensed feature of the pack.
The following reports are part of the Configuration Management Pack for Oracle Database. All reports in each of these sections are licensed for this pack. To display the Report Definitions page, click the Reports tab on the Grid Control Home page.
All reports under Deployment and Configuration
Monitoring reports
Alerts and Policy Violations
Disabled Policies
Security reports
Security Policy Overview
With the purchase of the Configuration Management Pack for Oracle Database, you also are entitled to the features described in the following sections. These features are restricted to the Oracle Database targets in the Oracle Database Home and the Platform (hardware and operating system) for the CPUs you have licensed.
Configuration Change Console
The Configuration Change Console offers real-time change detection and integration capabilities as described below.
Real-time Change Detection The Configuration Change Console is a policy-based system designed to help organizations and administrators support their IT compliance goals and help deliver the level of service expected by their users. The console includes a set of predefined frameworks created by industry experts to meet common compliance requirements. This enables IT departments to quickly and easily demonstrate compliance with government regulations and industry standards such as SOX, PCI, and ITIL.
The frameworks provide predefined controls mapped to application, device, and user event detection rules. These mappings empower the enterprise to monitor adherence for best practices from a centralized dashboard and provide concrete evidence in the form of reports for internal and external audits, reducing both the risk and cost of compliance. The console also provides an easy-to-use interface enabling administrators to define their own specific frameworks, policies, and controls and map them to the devices across their environment that they decide to monitor.
The Configuration Change Console automates the detection and capture of user and application actions that result in changes to the infrastructure without requesting or requiring user input. This automates the compliance audit trail and minimizes the time required to uncover compliance breaches.
Examples of components monitored for configuration change include:
Files and directories
Processes
User accounts
Server resources
Databases
Middeware
Network devices
Integration Capabilities The Configuration Change Console complements many existing IT infrastructure and service management systems through the following integration approaches:
Change management system integration — The Configuration Change Console integrates with popular change management systems (such as Remedy) to create a closed-loop change management solution. Integration is achieved through an adapter that enables communication between the change management system and Configuration Change Console. This integration enables the Configuration Change Console to determine if a change was authorized or unauthorized through an open request for change in the change management system.
Simple Network Management Protocol traps — The Configuration Change Console can send an alert whenever a specific change is detected to any third-party system.
Standards-based APIs — The Configuration Change Console is based on industry standards such as Java Platform, Enterprise Edition (J2EE), and Extensible Markup Language (XML), and can integrate with similar standards-based interfaces.
Configuration Change Console Restricted-use LIcensing Configuration Change Console Server includes restricted-use licenses for Oracle Database (Enterprise Edition), Oracle BEA Weblogic, and Oracle Business Intelligence, solely for the purpose of running the Configuration Change Console Release Server.
Restricted-use License for Oracle Database (Enterprise Edition)
Oracle includes restricted-use licenses for Oracle Database (Enterprise Edition) with licenses of Configuration Change Console Release. If you want to use the Oracle Database (Enterprise Edition) not solely for the purposes of running Configuration Change Console Release Server, then you must purchase full-use licenses for Oracle Database (Enterprise Edition).
Restricted-use License for Oracle BEA Weblogic
Oracle includes restricted-use licenses for Oracle BEA Weblogic with licenses of the Configuration Change Console Release. If you want to use the Oracle BEA Weblogic not solely for the purposes of running the Configuration Change Console Release 5 Server, then you must purchase full-use licenses for Oracle BEA Weblogic.
Restricted-use License for Oracle Business Intelligence
Oracle includes restricted-use licenses for Oracle Business Intelligence with licenses of Configuration Change Console Release 5 (10.2.0.5). If you want to use Oracle Business Intelligence not solely for the purposes of reporting on the data within the Configuration Change Console Release 5 (10.2.0.5) Server, then you must purchase full-use licenses for Oracle Business Intelligence. You may use the restricted-use license to, (1) utilize out-of-box reports shipped with the Configuration Change Console, (2) modify out-of-box report visualization and layouts, (3) add additional data to reports with the Configuration Change Console repository as the sole source of additional data, (4) create new reports with the Configuration Change Console repository as the sole source of data.
Application Configuration Console
Enterprises today require a comprehensive solution for managing their application infrastructure underlying their mission-critical applications. The Application Configuration Console provides IT infrastructure teams with an automated “gold master” approach to application infrastructure configuration management that enables smooth delivery and support of mission-critical business applications. IT infrastructure personnel can capture the current state of configuration settings for IT assets, monitor them for changes, and automate processes for provisioning changes as well as set up new environments throughout the application lifecycle — from development, testing, and through production.
The Application Configuration Console provides:
Management of database and IT infrastructure configuration data at individual property levels
System-level configuration comparisons
Template-based configuration collections
Policy enforcement at individual configuration property levels
Intelligent parameter-setting for configuration properties
Change tracking and alerts for individual configuration property changes
Blueprints for configuration collection of 100+ software assets
Role-based views of configuration data
Agentless collections
The following repository views are part of Oracle Configuration Management Pack:
Policy Definition Views
MGMT$POLICIES
MGMT$POLICY_PARAMETERS
MGMT$POLICY_VIOLATION_CTXT
MGMT$POLICY_VIOL_ANNOTATIONS
MGMT$POLICY_VIOL_NOTIF_LOG
Policy Association Views
MGMT$TARGET_POLICIES
MGMT$TARGET_POLICY_SETTINGS
MGMT$TARGET_POLICY_EVAL_SUM
MGMT$TARGET_COMPLIANCE_SCORE
Policy Violation Views
MGMT$POLICY_VIOLATION_CURRENT
MGMT$POLICY_VIOLATION_HISTORY
MGMT$POLICY_VIOLATION_CONTEXT
Configuration Views
MGMT$DB_TABLESPACES
MGMT$DB_DATAFILES
MGMT$DB_CONTROLFILES
Oracle Home Patching
MGMT$CPF_ADVISORY_INFO
MGMT$CPF_HOMES_INFO
MGMT$CPF_PATCH_INFO
MGMT$EM_HOMES_PLATFORM
MGMT$HOMES_AFFECTED
MGMT$PATCH_ADVISORIES
MGMT$APPL_PATCH_AND_PATCHSET
MGMT$APPLIED_PATCHES
MGMT$APPLIED_PATCHSETS
Linux Patching
MGMT$HOSTPATCH_HOSTS
MGMT$HOSTPATCH_GROUPS
MGMT$HOSTPATCH_GRP_COMPL_HIST
MGMT$HOSTPATCH_HOST_COMPL
Security Views
MGMT$ESA_ALL_PRIVS_REPORT
MGMT$ESA_ANY_DICT_REPORT
MGMT$ESA_ANY_PRIV_REPORT
MGMT$ESA_AUDIT_SYSTEM_REPORT
MGMT$ESA_BECOME_USER_REPORT
MGMT$ESA_CATALOG_REPORT
MGMT$ESA_CONN_PRIV_REPORT
MGMT$ESA_CREATE_PRIV_REPORT
MGMT$ESA_DBA_GROUP_REPORT
MGMT$ESA_DBA_ROLE_REPORT
MGMT$ESA_DIRECT_PRIV_REPORT
MGMT$ESA_EXMPT_ACCESS_REPORT
MGMT$ESA_KEY_OBJECTS_REPORT
MGMT$ESA_OH_OWNERSHIP_REPORT
MGMT$ESA_OH_PERMISSION_REPORT
MGMT$ESA_POWER_PRIV_REPORT
MGMT$ESA_PUB_PRIV_REPORT
MGMT$ESA_SYS_PUB_PKG_REPORT
MGMT$ESA_TABSP_OWNERS_REPORT
MGMT$ESA_TRC_AUD_PERM_REPORT
MGMT$ESA_WITH_ADMIN_REPORT
MGMT$ESA_WITH_GRANT_REPORT
Client Configuration Views
MGMT$CSA_COLLECTIONS
MGMT$CSA_FAILED
MGMT$CSA_HOST_OS_COMPONENTS
MGMT$CSA_HOST_SW
MGMT$CSA_HOST_COOKIES
MGMT$CSA_HOST_CUSTOM
MGMT$CSA_HOST_RULES
MGMT$CSA_HOST_CPUS
MGMT$CSA_HOST_IOCARDS
MGMT$CSA_HOST_NICS
MGMT$CSA_HOST_OS_PROPERTIES
MGMT$CSA_HOST_OS_FILESYSEMS
MGMT$ECM_CONFIG_HISTORY
MGMT$ECM_CONFIG_HISTORY_KEY1
MGMT$ECM_CONFIG_HISTORY_KEY2
MGMT$ECM_CONFIG_HISTORY_KEY3
MGMT$ECM_CONFIG_HISTORY_KEY4
MGMT$ECM_CONFIG_HISTORY_KEY5
MGMT$ECM_CONFIG_HISTORY_KEY6
MGMT$HW_NIC
MGMT$OS_COMPONENTS
MGMT$OS_FS_MOUNT
MGMT$OS_HW_SUMMARY
MGMT$OS_HW_SUMMARY
MGMT$OS_PATCHES
MGMT$OS_SUMMARY
MGMT$SOFTWARE_COMP_PATCHSET
MGMT$SOFTWARE_COMPONENT_ONEOFF
MGMT$SOFTWARE_COMPONENTS
MGMT$SOFTWARE_DEPENDENCIES
MGMT$SOFTWARE_HOMES
MGMT$SOFTWARE_ONEOFF_PATCHES
MGMT$SOFTWARE_OTHERS
MGMT$SOFTWARE_PATCHES_IN_HOMES
MGMT$SOFTWARE_PATCHSETS
Oracle Data Masking Pack offers the ability to mask regulated or confidential data on test or development systems.
Oracle Data Masking Pack includes the following features:
Mask format libraries
Mask definitions
Masking techniques
Condition-based masking
Compound masking
Deterministic masking
Application masking templates import or export
Mask format library import or export
Masking script generation
Clone and Mask workflow
The following licensed pages and links in Enterprise Manager apply to Oracle Data Masking Pack.
From the Enterprise Manager Home page, select the Schema sub-tab. In the Data Masking section, the following links and associated pages are licensed as part of the pack:
Definitions: All links, buttons, and drilldowns on this page are licensed features of this pack.
Format Library: All links, buttons, and drilldowns on this page are licensed features of this pack.
Oracle Diagnostics Pack provides automatic performance diagnostic and advanced system monitoring functionality.
Oracle Diagnostics Pack includes the following features:
Automatic Workload Repository
Automatic Database Diagnostic Monitor (ADDM)
Active Session History (ASH)
Performance monitoring (database and host)
Event notifications: notification methods, rules, and schedules
Event history and metric history (database and host)
Blackouts
Dynamic metric baselines
Monitoring templates
Memory-access based performance monitoring
Supporting functionality to perform per stream bottleneck detection and per component top wait event analysis
Execution of the Real Application Testing 'Replay Compare Period Report'
In order to use the features listed above, you must purchase licenses for Oracle Diagnostics Pack. A new initialization parameter, CONTROL_MANAGEMENT_PACK_ACCESS
, controls access to Oracle Diagnostics Pack and Oracle Tuning Pack. This parameter can be set to one of three values:
DIAGNOSTIC+TUNING
: Oracle Diagnostics Pack and Oracle Tuning Pack functionally is enabled in the database server.
DIAGNOSTIC
: Only Oracle Diagnostics Pack functionality is enabled in the server.
NONE
: Oracle Diagnostics Pack and Oracle Tuning Pack functionally is disabled in the database server.
Oracle Diagnostics Pack functionality can be accessed by Enterprise Manager links as well as through the database server command-line APIs. The use of either interface requires an Oracle Diagnostics Pack license.
To determine which links in Enterprise Manager Grid Control and Database Control are part of Oracle Diagnostics Pack, click the Setup link on the top right-hand part of the Enterprise Manager Home page.
When you click the Setup link, the navigation bar contains the Management Pack Access link. Click this link.
This will take you to the Management Pack Access page, which allows you to grant and remove access from all the management packs.
For Enterprise Manager Database Control, click the Remove Access radio button for the Diagnostics Pack and click Apply.
For Enterprise Manager Grid Control, click the appropriate check box for the Diagnostics Pack and click Apply.
This procedure disables all the links and tabs associated with Oracle Diagnostics Pack in Enterprise Manager. All the disabled links and tabs are part of Oracle Diagnostics Pack and therefore require a pack license.
Oracle Diagnostics Pack features can also be accessed by way of database server APIs and command-line interfaces:
The DBMS_WORKLOAD_REPOSITORY
package is part of this pack.
The DBMS_ADDM
package is part of this pack.
The DBMS_ADVISOR
package is part of this pack if you specify ADDM as the value of the advisor_name
parameter, or if you specify for the value of the task_name
parameter any value starting with the ADDM prefix.
The DBMS_WORKLOAD_REPLAY
.COMPARE_PERIOD_REPORT
function is part of this pack.
The V$ACTIVE_SESSION_HISTORY
dynamic performance view and its underlying table, X$ASH
, are part of this pack.
The DBA_STREAMS_TP_PATH_BOTTLENECK
view is part of this pack.
All views beginning with DBA_ADDM_
are part of this pack.
Some data in DBA_STREAMS_TP_COMPONENT_STAT
requires Oracle Diagnostics Pack. The following filter clause to any query on DBA_STREAMS_TP_COMPONENT_STAT
shows Diagnostics-Pack-dependent data:
where STATISTIC_UNIT = 'PERCENT'
For example, the following query shows Diagnostics-Pack-dependent data only:
SELECT * FROM DBA_STREAMS_TP_COMPONENT_STAT where STATISTIC_UNIT = 'PERCENT';
All data dictionary views beginning with the prefix DBA_HIST_
are part of this pack, along with their underlying tables.The only exception are the views: DBA_HIST_SNAPSHOT, DBA_HIST_DATABASE_INSTANCE, DBA_HIST_SNAP_ERROR, DBA_HIST_SEG_STAT, DBA_HIST_SEG_STAT_OBJ,
and DBA_HIST_UNDOSTAT
. They can be used without the Oracle Diagnostics Pack license.
All data dictionary views with the prefix DBA_ADVISOR_
are part of this pack if queries to these views return rows with the value ADDM
in the ADVISOR_NAME
column or a value of ADDM*
in the TASK_NAME
column or the corresponding TASK_ID
.
The following reports found in the /rdbms/admin/ directory of the Oracle home directory are part of this pack: awrrpt.sql, awrrpti.sql, awrgrpt.sql, awrgrpti.sql, awrgdrpt.sql, awrgdrpi.sql, addmrpt.sql, addmrpti.sql, ashrpt.sql, ashrpti.sql, awrddrpt.sql, awrddrpi.sql, awrsqrpi.sql, awrsqrpt.sql, awrextr.sql, awrload.sql, awrinfo.sql, spawrrac.sql.
Monitoring Views
MGMT$BLACKOUT_HISTORY
MGMT$BLACKOUTS
MGMT$ALERT_ANNOTATIONS
MGMT$ALERT_NOTIF_LOG
MGMT$TARGET_METRIC_COLLECTIONS
MGMT$METRIC_COLLECTIONS
MGMT$TARGET_METRIC_SETTINGS
MGMT$AVAILABILITY_CURRENT
MGMT$AVAILABILITY_HISTORY
MGMT$ALERT_CURRENT
MGMT$ALERT_HISTORY
MGMT$METRIC_DETAILS
MGMT$METRIC_CURRENT
MGMT$METRIC_HOURLY
MGMT$METRIC_DAILY
Template Views
MGMT$TEMPLATES
MGMT$TEMPLATE_POLICY_SETTINGS
MGMT$TEMPLATE_METRIC_COLLECTION
MGMT$TEMPLATE_METRIC_SETTINGS
Oracle Provisioning and Patch Automation Pack automates the deployment of software, applications, and patches for the database and underlying operating system. It makes critical data center operations easy, efficient and scalable resulting in lower operational risk and cost of ownership. The ability to provision the entire software stack that includes the operating system and the database, supplemented by comprehensive reporting tools make Oracle Provisioning and Patch Automation Pack an extremely significant entity in overall System Management space.
Oracle Provisioning and Patch Automation Pack contains the following features:
Automated patching for Oracle database products and the operating system
Critical Patch Facility
Bare metal OS provisioning
Single instance and RAC provisioning, including when invoked in the context of Real Application Testing
Single click cluster scale up and scale down
Single instance-to-RAC conversion
CLI driven runtime of the above operations
Enterprise Security Advisor
Provisioning and deployment reports
Oracle Tuning Pack provides database administrators with expert performance management for the Oracle environment, including SQL tuning and storage optimizations. Oracle Diagnostics Pack is a prerequisite product to Oracle Tuning Pack. Therefore, to use Oracle Tuning Pack, you must also have Oracle Diagnostics Pack.
Oracle Tuning Pack includes the following features:
SQL Access Advisor
SQL Tuning Advisor
Automatic SQL Tuning
SQL Tuning Sets
Automatic Plan Evolution of SQL Plan Management
SQL Monitoring
Reorganize objects
In order to use the features listed above, you must purchase licenses for Oracle Tuning Pack, with one exception: SQL Tuning Sets can be used if you have licensed either Oracle Tuning Pack or Oracle Real Application Testing. A new initialization parameter, CONTROL_MANAGEMENT_PACK_ACCESS
, is introduced to control access to Oracle Diagnostics Pack and Oracle Tuning Pack in the database server. This parameter can be set to one of three values:
DIAGNOSTIC+TUNING
: Oracle Diagnostics Pack and Oracle Tuning Pack functionally is enabled in the database server.
DIAGNOSTIC
: Only Oracle Diagnostics Pack functionality is enabled in the server.
NONE
: Oracle Diagnostics Pack and Oracle Tuning Pack functionally is disabled in the database server.
Oracle Tuning Pack functionality can be accessed by the Enterprise Manager links as well as through the database server command-line APIs. The use of either interface requires licensing of Oracle Tuning Pack
To determine which links in Enterprise Manager Grid Control and Database Control are part of Oracle Tuning Pack, click the Setup link on the top right-hand part of the Enterprise Manager Home page.
When you click the Setup link, the navigation bar contains the Management Pack Access link. Click this link.
This will take you to the Management Pack Access page, which allows you to grant and remove access from all the management packs.
For Enterprise Manager Database Control, click the Remove Access radio button for the Tuning Pack and click Apply.
For Enterprise Manager Grid Control, click the appropriate check box for the Tuning Pack and click Apply.
This procedure disables all the links and tabs associated with Oracle Tuning Pack in Enterprise Manager. All the disabled links and tabs are part of Oracle Tuning Pack and therefore require a pack license.
Oracle Tuning Pack features can also be accessed by way of database server APIs and command-line interfaces:
DBMS_SQLTUNE
DBMS_ADVISOR
, when the value of the advisor_name
parameter is either SQL Tuning Advisor or SQL Access Advisor.
V$SQL_MONITOR
V$SQL_PLAN_MONITOR
The following report found in the /rdbms/admin/
directory of the Oracle home directory is part of this pack: sqltrpt.sql.
In addition to the options and packs described in this chapter, Oracle provides two additional products for specific customer environments.
This section describes the following products:
Oracle Database Lite Client Oracle Database Lite Client is a small general-purpose relational database used for mobile and embedded applications. Oracle Database Lite client can be used as a standalone database in embedded hardware and software applications or may be used as the data store for disconnected mobile applications when used with the Oracle Database Lite Mobile Server.
Each user must purchase a Named User Plus license.
Oracle Database Lite Mobile Server Oracle Database Lite Mobile Server is middle-tier infrastructure for mobile and disconnected applications that performs data synchronization and provides management for applications, users, and devices. Oracle Database Lite Mobile Server can use the Oracle Database Lite client as a data store for mobile and disconnected applications, providing efficient, reliable, and secure data management running locally on mobile and small-footprint devices (handhelds, notebooks, communicators, and so forth). The Lite Mobile Server supports scalable synchronization of data between devices and an Oracle Database.
Oracle Database Mobile Server is licensed by CPU.
Note:
When Lite Mobile Server is used with Lite Client, customers must purchase at least one CPU license for Lite Mobile Server and a Named User Plus license for each client user.Oracle Programmer is a separate Oracle product that provides a programmatic interface to any edition of Oracle Database for application programmers. Programmer provides a rich set of interfaces for developers who build enterprise applications that access and manipulate Oracle Database. This product is licensed separately from the Oracle Database products. Oracle Programmer is a family of the following products:
Three embedded SQL-style interfaces: precompilers, SQL*Module, and SQLJ
Two utilities to generate host-language bindings from database schemas: Object Type Translator and JPub
Oracle Secure Backup provides tape backup management for the entire Oracle environment. You can use Oracle Secure Backup to back up Oracle databases and host file systems to tape through direct-attached or network-attached tape drives. Oracle Secure Backup provides centralized management and control over backup and restore operations.
Oracle Secure Backup is available in the following forms, each suitable for different development and deployment scenarios:
Oracle Secure Backup For environments that consist of many servers, Oracle Secure Backup offers high performance data protection from server to tape. This protection is crucial for local and offsite storage of business-critical data.
Oracle Secure Backup Express For environments that consist of a single server, Oracle Secure Backup Express offers the same tape backup functionality as Oracle Secure Backup, but is limited to a single host with one direct-attached tape drive.