- From the Enterprise menu, select Migration and Consolidation , then select Database Migration Planner .
- On the database target home page, select the Administration menu, then select Database Migration Planner .
- All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Database Migration Planner.
Database Migration Workbench
- Database Migration Workbench, introduced in Oracle Enterprise Manager Cloud Control 13c Release 4, is a single workbench that integrates all needs for migration sizing and performance comparison.
- An Oracle Real Application Testing license permits you to access the following links on the Database Migration Workbench page in Oracle Enterprise Manager:
- From the Enterprise menu, select Migration and Consolidation , then select Database Migration Workbench .
- All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Database Migration Workbench.
Oracle TimesTen Application-Tier Database Cache
Extra cost option: EE , EE-ES
Included option: PE
Oracle TimesTen Application-Tier 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
- Multi-node 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
1.5 Oracle Management Packs and Their Permitted Features
Table 1-15 lists Oracle management packs, the Oracle Database offerings for which each pack is available, and the features that are included with each pack. The features in these packs are accessible through Oracle Enterprise Manager, Desktop Widgets, and APIs provided with Oracle Database software. You must be licensed for a management pack in order to use any of its features.
Table 1-15 Oracle Management Packs and Their Permitted Features
Oracle Cloud Management Pack for Oracle Database
Extra cost pack: EE , EE-ES
Included pack: BaseDB EE-HP , BaseDB EE-EP , ExaDB
Oracle Cloud Management Pack for Oracle Database includes the following features:
- Database-as-a-Service comprising self-service database provisioning on physical or virtual infrastructure
- DBaaS Rapid Start Kit allowing users to set up and configure Enterprise Manager Cloud Control 12c in under a minute.
- Pluggable Database-as-a-Service (PDBaaS) providing self-service provisioning on a pool of multitenant container databases (CDBs).
- Support shared server, shared cluster, and shared database (Schema-as-a-Service) deployment models
- Virtual assembly provisioning. For example, if there is an assembly topology of three VMs (two WebLogic Server-managed servers and one database), you will need both packs to cover the respective tiers.
- Snap Clone, a fast, storage efficient way of cloning Oracle databases
- Full clones using RMAN backups
- Role based access and resource control through quotas and retirement policies
- Schedule- and performance-based resource management policies
- Metering and chargeback based on fixed cost, utilization metrics and configuration parameters of the database
- Programmatic access to the Self-Service Portal
- Blueprint driven orchestration of cloud operations
Oracle Cloud Management Pack for Oracle Database requires Oracle Database Lifecycle Management Pack for Oracle Database.
Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Cloud Management Pack for Oracle Database.
Starting on the Enterprise Summary home page, click the Enterprise menu. Select:
- Cloud , then Infrastructure Home
- Cloud , then Infrastructure Request Dashboard
- Cloud , then Infrastructure Policies
- Cloud , then Middleware and Database Home
- Cloud , then Middleware and Database Request Dashboard
- Cloud , then Self Service Portal
- Cloud , then Service Instances
- Chargeback
- Provisioning and Patching , then Database Provisioning . In the Database Provisioning page, in the Related Links section of the left menu pane, click Provision Pluggable Databases . Next, from the PDB Operations section, select Create New Pluggable Databases . Click Launch , and from Pluggable Database Creation Options, select Clone an Existing PDB -> Snap Clone .
Starting on the Enterprise Summary home page, click the Setup menu. Select:
- Cloud . Select Infrastructure
- Cloud . Select Database
- Provisioning and Patching , then Storage Registration
On the Multitenant container database's home page, from the Oracle Database menu, select Provisioning , then Provision Pluggable Database . Next, from the PDB Operations section, select Create New Pluggable Databases . Click Launch , and from Pluggable Database Creation Options, select Clone an Existing PDB -> Snap Clone .
Use of the following APIs requires a license for Oracle Cloud Management Pack for Oracle Database:
- Assembly Operations — Any POST / GET / PUT / DELETE on /em/cloud/iaas URI space for Resources Assembly Template and Assembly Instance
- DBaaS Operations — Any POST / GET / PUT / DELETE on /em/cloud/dbaas URI space
- DBaaS Setup Operations — Any POST / GET / PUT / DELETE on /em/websvcs/restful/extws/cloudservices/admin/cfw/v1 URI space.
Licensed Command Line Interface (CLI) Verbs:
The following Enterprise Manager Command Line Interface (CLI) verbs are licensed as part of Oracle Cloud Management Pack for Oracle Database. These verbs operate on a database pool.
- add_pool_members
- create_charge_item
- create_dbaas_quota
- create_dbprofile
- create_pool
- create_service_template
- delete_charge_item
- delete_dbaas_quota
- delete_pool
- delete_service_template
- get_dbaas_quota
- get_dbaas_request_settings
- get_metering_data
- get_pool_capacity_data
- get_pool_capacity_summary_data
- get_pool_constraints
- get_pool_criteria
- get_pool_detail
- get_pool_instance_data
- get_pool_target_type
- get_pools
- get_service_template
- list_charge_item_candidates
- remove_pool_members
- update_dbaas_quota
- update_dbaas_request_settings
- update_pool
Licensed Views and Tables:
The following objects within the repository schema are licensed under Oracle Cloud Management Pack for Oracle Database:
- Tables starting with EMCT_CBA
- Views starting with EMCT$CBA
- The GP_EMCT_CBA_TARGET_CHARGE views
- The MGMT$EMCT_CBA_CHARGE_DAILY view
- The MGMT$EMCT_CBA_CHARGE_HOURLY view
Licensed Chargeback Reports:
The following BI Publisher reports are licensed under Oracle Cloud Management Pack for Oracle Database:
- Charge Trend Report
- Charge Summary Report
- Usage Trend Report
- Usage Summary Report
Also, any report created using the "create-like" feature of BI publisher referring the preceding reports, falls under this license.
Oracle Data Masking and Subsetting Pack
Extra cost pack: EE , EE-ES
Included pack: BaseDB EE , BaseDB EE-HP , BaseDB EE-EP , ExaDB
Oracle Data Masking and Subsetting Pack includes the following features:
- Application Data Modeling
- Data Masking Formats Library
- Data Masking Definitions
- Data Subsetting Definitions
- Application Data Modeling, Data Masking and Subsetting Enterprise Manager Command Line Interface (CLI) verbs
- Application Data Modeling accelerator for select versions of Oracle E-Business Suite
- Application Data Modeling accelerator for select versions of Oracle Fusion Applications
- Data Masking templates for select versions of Oracle Fusion Applications
- Data Masking templates for select versions of Oracle E-Business Suite
Oracle Data Masking and Subsetting Pack includes the following restricted use licenses:
- Database Gateway for APPC
- Database Gateway for DRDA
- Database Gateway for Informix
- Database Gateway for SQLServer
- Database Gateway for Sybase
- Database Gateway for Teradata
If you want to use the Oracle Database Gateways listed above not solely for the purposes of Oracle Data Masking and Subsetting Pack, then you must purchase full-use licenses for the Oracle Database Gateways. When using Oracle Data Masking and Subsetting Pack for non-Oracle databases, the Oracle Database Gateways stage the data in a separately licensed Oracle Database. Oracle Data Masking and Subsetting functionality cannot be executed directly against the non-Oracle database.
Oracle Data Masking and Subsetting Pack must be licensed only for the source database server, i.e., the databases from which the data originates.
There is no requirement to license the pack for the staging database server on which masking and subsetting operations are executed, or for copies made of the masked database.
- Oracle Data Masking and Subsetting Pack incorporates the previous Oracle Data Masking Pack, Oracle Test Data Management Pack, and Oracle Data Masking and Subsetting Pack for non-Oracle Databases.
- Application Data Modeling was previously called Data Discovery and Modeling.
All features, functions, links, buttons, and drill-downs on these Oracle Enterprise Manager menus are licensed as part of the Oracle Data Masking and Subsetting Pack.
Starting on the Enterprise Summary home page, click the Enterprise menu, then Quality Management , then select:
- Application Data Modeling
- Data Masking Definitions
- Data Masking Formats
- Data Subset Definitions
From the Oracle database or cluster database target home page, click the Security menu, then select:
- Application Data Modeling
- Data Masking Definitions
- Data Subsetting
Oracle Database Lifecycle Management Pack for Oracle Database
Extra cost pack: EE , EE-ES
Included pack: BaseDB EE-HP , BaseDB EE-EP , ExaDB
Oracle Database Lifecycle Management Pack for Oracle Database includes the following features:
- Change Activity Plans
- Client system analyzer
- Compliance
- Configuration Collection Extensibility
- Configuration Compare
- Configuration History
- Configuration Instance Browser
- Configuration Save
- Configuration Search
- Configuration Topology
- Copy Objects
- Database Patching
- Database Provisioning
- Database Upgrade
- Disaster Recovery via Site Guard
- Enterprise Data Governance
- File Synchronization
- Notifications
- Pluggable Database (PDB) Clone
- PDB Create/Plug/Unplug (Multiple target operations or performed using a customized deployment procedure.)
- PDB Migrate
- RAC Scale Back
- RAC Scale Out
- Real-time configuration change detection
- Real-time schema change detection
- Schema and Data Comparisons
- Schema and Data Synchronization
- Schema Change Plans
- Schema Comparisons
- User Defined Deployment Procedures (UDDP)
With the purchase of Oracle Database Lifecycle 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.
- Application Configuration Console
- The oplan Utility (The basic OPlan feature is free for everyone that has an Oracle Support contract. Use of OPlan metadata to drive orchestration logic from either Enterprise Manager or custom/third-party scripts is part of Oracle Database Lifecycle Management Pack for Oracle Database.)
- Migrate to ASM
- Self Update
The init . ora parameter ENABLE_DDL_LOGGING is licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database when set to TRUE . When set to TRUE , the database reports schema changes in real time into the database alert log under the message group schema_ddl. The default setting is FALSE .
The Licensed Links, features, and functions listed in the following sections apply only to the Oracle Database target and the associated host an Oracle Database is deployed on. For management on non-Oracle Database targets, you must purchase the appropriate management pack.
Licensed Links – Database Provisioning Procedures:
Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:
- From the Enterprise Manager home page, click the Enterprise menu, Provisioning and Patching , then Procedure Library . All Procedures that Clone and Provision a Database are licensed with Oracle Database Lifecycle Management Pack for Oracle Database.
- From the Enterprise Manager home page, click the Enterprise menu, Provisioning and Patching , then Database Provisioning . All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
- From the Oracle database or cluster database target home page, click the Oracle Database menu, then Provisioning . All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
Licensed Links – Database Upgrade:
Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:
- From the Enterprise Manager home page, click the Enterprise menu, Provisioning and Patching , then Procedure Library . All Procedures that Upgrade a Database are licensed with Oracle Database Lifecycle Management Pack for Oracle Database.
- From the Oracle database or cluster database target home page, click the Oracle Database menu, then Provisioning . All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
Licensed Links – User Defined Deployment Procedures (UDDP)
Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:
- From the Enterprise Manager home page, click the Enterprise menu, Provisioning and Patching , then Procedure Library . On the Provisioning Library page, from the list of actions, the Create New option is licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
Licensed Links – RAC Scale Out and Scale Back
Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:
- From the Enterprise Manager home page, click the Enterprise menu, Provisioning and Patching , then Procedure Library . All Procedures that Extend or Scale a database or RAC are licensed with Oracle Database Lifecycle Management Pack for Oracle Database.
- From the Enterprise Manager home page, click the Enterprise menu, Provisioning and Patching , then Database Provisioning . All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
- From the Oracle cluster database target home page, click the Oracle Database menu, then Provisioning . All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
Licensed Links – Database Patching
Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:
- From the Enterprise Manager home page, click the Enterprise menu, Provisioning and Patching , then Procedure Library . All Procedures that patch a database, Clusterware or Real Application Clusters are licensed with Oracle Database Lifecycle Management Pack for Oracle Database.
Licensed Links – Offline Patching
Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:
- From the Enterprise Manager home page, click the Setup menu, Provisioning and Patching , then Offline Patching . From the Online and Offline Setting tab, the Connection , Offline setting is licensed with Oracle Database Lifecycle Management Pack for Oracle Database.
Licensed Links – Configuration Instance Browser
Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:
- From the Enterprise Manager home page, click on Targets , Databases , and select a Database. From the database home page, click on Oracle Database , Configuration . All features, functions, links, buttons, and drill-downs on this menu, excluding Topology, are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
- If the Target Home Page is accessed directly or by other paths:
- From the database home page, click on Oracle Database , Configuration . All features, functions, links, buttons, and drill-downs on this menu, excluding Topology, are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
Licensed Links – Configuration Search
Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:
- From the Enterprise Manager home page, click the Enterprise menu, then Configuration and Search . All features, functions, links, buttons, and drill-downs on this page are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
Licensed Links – Configuration History
Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:
- From the Enterprise Manager home page, click the Enterprise menu, then Configuration and History . All features, functions, links, buttons, and drill-downs on this page are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
Licensed Links – Configuration Compare
Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:
- From the Enterprise Manager home page, click the Enterprise menu, then Configuration and Compare . All features, functions, links, buttons, and drill-downs on this page are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
Licensed Links – Configuration Save
Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:
- From the Enterprise Manager home page, click the Enterprise menu, then Configuration and Save . All features, functions, links, buttons, and drill-downs on this page are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
Licensed Links – Configuration Topology
Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:
- From the Target Home Page, click on Oracle Database , Configuration , Topology . In the View Dropdown, Used By is licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
- From the Target Home Page, click on Oracle Database , Configuration , Topology , Customization . All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
- If the Target Home Page is accessed directly or by other paths:
- From the Target Home Page, click on Oracle Database , Configuration , Topology . In the View drop-down, Used By is licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
- From the Target Home Page, click on Oracle Database , Configuration , Topology , Customization . All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
Licensed Links – Configuration Collection Extensibility
Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:
- From the Enterprise Manager home page, click the Enterprise menu, then Configuration and Custom . All features, functions, links, buttons, and drill-downs on this page are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
Licensed Links – File Synchronization
Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:
- When viewing comparison results differences as described in the Configuration Compare feature, select the configuration specification in the tree on the left. Select Enable File Synchronization . All features, functions, links, buttons, and drill-downs on this page are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
Licensed Links – Schema Comparison:
Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:
- From the Enterprise Manager home page, click on Targets , Databases , and then select a Database. From the database home page, click on Schema , Change Management . All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
- If the Target Home Page is accessed directly or by other paths:
- From the database home page, click on Schema , Change Management . All features, unctions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
Licensed Links – Schema and Data Comparisons:
Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:
- From the Enterprise Manager home page, click on Targets , Databases , and then select a Database. From the database home page, click on Schema , Change Management . All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
- If the Target Home Page is accessed directly or by other paths:
- From the database home page, click on Schema , Change Management . All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
Licensed Links – Schema and Data Synchronization:
Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:
- From the Enterprise Manager home page, click on Targets , Databases , and then select a Database. From the database home page, click on Schema , Change Management . All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
- If the Target Home Page is accessed directly or by other paths:
- From the database home page, click on Schema , Change Management . All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
Licensed Links – Copy Objects:
Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:
- From the Enterprise Manager home page, click on Targets , Databases , and then select a Database. From the database home page, click on Schema , Change Management . All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
- If the Target Home Page is accessed directly or by other paths:
- From the database home page, click on Schema , Change Management . All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
Licensed Links – Real-Time Schema Change Detection:
Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:
- From the Enterprise Manager home page, click on Targets , Databases , and then select a Database. From the database home page, click on Schema , Change Management . All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
- If the Target Home Page is accessed directly or by other paths:
- From the database home page, click on Schema , Change Management . All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
Licensed Links – Real-time Configuration Change Detection and Compliance:
Use of the following Oracle Enterprise Manager pages and links requires a license for Oracle Database Lifecycle Management Pack for Oracle Database:
- From the Enterprise Manager home page, click the Enterprise menu and Compliance . All features, functions, links, buttons, and drill-downs associated with the Library, Results and Real-Time Observations pages are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
The following reports are part of Oracle Database Lifecycle Management Pack for Oracle Database. All reports in each of these sections are licensed as part of this pack. To access the reports go to the Enterprise Manager home page, click the Reports, Information Publisher Reports or BI Publisher Enterprise Reports.
The following reporting areas, reports, and sub-reports under Information Publisher Reports are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database:
- Compliance
- Deployment and Configuration
- Sample Host reports, Configuration Reports
- Security
The following reporting areas, reports and sub-reports under BI Publisher Enterprise Reports are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database:
- Compliance
- Deployment and Configuration
- Sample Host reports, Configuration Reports
- Security
Licensed Command Line Interface (CLI) Verbs:
The following Enterprise Manager Command Line Interface (CLI) verbs are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.
- associate_cs_targets
- clone_database
- config_compare
- config_db_service_target
- configure_log_archive_locations
- confirm_instance
- create_database
- describe_instance
- describe_procedure_input
- disable_config_history
- enable_config_history
- export_compliance_group
- export_compliance_standard_rule
- export_facet
- export_standard
- fix_compliance_state
- get_config_searches
- get_config_templates
- get_executions
- get_instance_data
- get_instance_status
- get_instances
- get_oms_config_property
- get_procedure_types
- get_procedure_xml
- get_procedures
- get_retry_argument
- get_saved_configs
- ignore_instance
- import_compliance_object
- list_oms_config_properties
- remove_cs_target_association
- reschedule_instance
- resume_instance
- run_config_search
- save_procedure
- set_config_history_retention_period
- stop_instance
- submit_procedure
- suspend_instance
- update_and_retry_step
- update_procedure_input
- upgrade_database
Licensed Repository Views – Compliance Views:
The following compliance views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:
- MGMT$CCC_ALL_OBS_BUNDLES
- MGMT$CCC_ALL_OBSERVATIONS
- MGMT$CCC_DIAG_ANALYTICS
- MGMT$CCC_DIAG_QUEUEBACKLOG
- MGMT$COMPLIANCE_STANDARD
- MGMT$COMPLIANCE_STANDARD_GROUP
- MGMT$COMPLIANCE_STANDARD_RULE
- MGMT$COMPOSITE_CS_EVAL_SUMMARY
- MGMT$CS_ASM_DISKGRP_SETTINGS
- MGMT$CS_DB_CONTROL_FILE_COUNT
- MGMT$CS_DB_INIT_PARAMS
- MGMT$CS_DB_RBS_IN_SYSTEM
- MGMT$CS_DB_REC_SEG_SETTINGS
- MGMT$CS_DB_REC_TS_SETTINGS
- MGMT$CS_DB_REC_USER_SETTINGS
- MGMT$CS_DB_REDO_LOG_COUNT
- MGMT$CS_DB_REDO_LOGS
- MGMT$CS_DB_TABLESPACES
- MGMT$CS_DB_TBSP_SEGSPACE_MGMT
- MGMT$CS_EVAL_SUMMARY
- MGMT$CS_FEATURE_USAGE
- MGMT$CS_GROUP_EVAL_SUMMARY
- MGMT$CS_GROUP_KEYWORD
- MGMT$CS_HA_INFO
- MGMT$CS_HIERARCHY
- MGMT$CS_KEYWORD
- MGMT$CS_RQS_HIERARCHY
- MGMT$CS_RULE_ATTRS
- MGMT$CS_RULE_EVAL_SUMMARY
- MGMT$CS_RULEFOLDER
- MGMT$CS_TARGET_ASSOC
- MGMT$CS_TGT_ASSOC_TXF_REQ
- MGMT$CSG_HIERARCHY
- MGMT$CSG_SUBGROUP
- MGMT$CSR_CURRENT_VIOLATION
- MGMT$CSR_TARGET_ASSOC
- MGMT$CSR_VIOLATION_CONTEXT
- MGMT$CSRF_TARGET_ASSOC
- MGMT$EM_CS_RULE_EVENT_ERROR
- MGMT$EM_RULE_VIOL_CTXT_DEF
- MGMT$ICS_TARGET_ASSOC
- MGMT$REPO_RULE_CHK_DETAILS
- MGMT$REPOSITORY_RULE_BIND_VARS
- MGMT$REPOSITORY_RULE_PARAMS
- MGMT$RULE_KEYWORD
Licensed Repository Views – Provisioning and Patching Views:
The following provisioning and patching views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:
- EM$PROV_APPTYPES
- EM$PROVAPP_METADATA
- EM$PROVAPP_METADATA_VERSION
- EM$PROVAPP_TAG_PROPERTIES
- EM$PROVAPP_TAGS
- MGMT$PA_RECOM_METRIC_SOURCE
Licensed Repository Views – Patching Views:
The following patching views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:
- GC$EM_PC_PLAN_PATCHES
- GC$EM_PC_PLANS
- GC$EM_PC_PLAN_TARGETS
- GC_PC_EXECUTION_INSTANCES
- GC_PC_PLAN_ANALYSIS_RS
- GC_PC_PLAN_REMEDY
- GC_PC_PLAN_REMEDY_DETAILS
- GC_PC_PLAN_USERS
- GC_PC_TARGETS
- MGMT$APPLIED_PATCHES
- MGMT$APPLIED_PATCHSETS
- MGMT$ARU_FAMILY_PRODUCT_MAP
- MGMT$ARU_LANGUAGES
- MGMT$ARU_PATCH_RECOMMENDATIONS
- MGMT$ARU_PLATFORMS
- MGMT$ARU_PRODUCT_RELEASE_MAP
- MGMT$ARU_PRODUCTS
- MGMT$ARU_RELEASES
- MGMT$ARU_TARGETS
- MGMT$PA_AFFTED_HOST_GUID_OH
- MGMT$PA_AFFTED_HOST_OH
- MGMT$PA_AFFTED_TARGETS
- MGMT$PA_FINAL_PATCH_LIST
- MGMT$PA_TARGET_MAPPING
- MGMT$PR_APPL_PATCHES_TO_OH
- MGMT$PR_APPL_PATCHES_TO_OH_TGT
- MGMT$PR_HOME_INFO
- MGMT$PR_HOMES_AFFECTED_COUNT
- MGMT$RECOM_METRIC_SOURCE
Licensed Repository Views – Configuration Views:
The following configuration views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:
- GC$ECM_COMP_PROPERTIES
- GC$ECM_CONFIG_SUMMARY
- GC$ECM_CURR_CONFIG
- GC$ECM_CURR_CONFIG_FLAT_MEMS
- GC$ECM_CURR_CONFIG_SNAPSHOTS
- GC$ECM_CURR_TARGET_SNAPSHOTS
- GC$ECM_DATA_RETENTION_TIME
- GC$ECM_GEN_SNAPSHOT
- GC$ECM_SAVED_CONFIG
- GC$ECM_SAVED_CONFIG_FLAT_MEMS
- GC$ECM_SAVED_CONFIG_SNAPSHOTS
- GC$ECM_SAVED_CONFIG_TARGETS
- GC$ECM_SAVED_TARGET_SNAPSHOTS
- MGMT$CCS_DATA
- MGMT$CCS_DATA_SOURCE
- MGMT$CCS_DATA_SOURCE_VISIBLE
- MGMT$CCS_DATA_VISIBLE
- MGMT$DB_CONTROLFILES
- MGMT$DB_DATAFILES
- MGMT$DB_DBNINSTANCEINFO
- MGMT$DB_FEATUREUSAGE
- MGMT$DB_INIT_PARAMS
- MGMT$DB_LICENSE
- MGMT$DB_OPTIONS
- MGMT$DB_REDOLOGS
- MGMT$DB_ROLLBACK_SEGS
- MGMT$DB_SGA
- MGMT$DB_TABLESPACES
- MGMT$DB_TABLESPACES_ALL
- MGMT$ECM_CMP_JOB_LAST_RESULTS
- MGMT$ECM_CMP_JOBS
- MGMT$ECM_CMP_RPT_CCS_DS
- MGMT$ECM_CMP_RPT_CCS_DS_DTLS
- MGMT$ECM_CMP_RPT_CCS_PD_ALL
- MGMT$ECM_CMP_RPT_CCS_PD_DIFFS
- MGMT$ECM_CMP_RPT_CI_DIFFS
- MGMT$ECM_CMP_VISIBLE_CONFIGS
- MGMT$ECM_CURRENT_SNAPSHOTS
- MGMT$ECM_VISIBLE_SNAPSHOTS
- MGMT$SERVICETAG_INSTANCES
- MGMT$SERVICETAG_REGISTRY
- MGMT$UNPATCHABLE_DB_TARGETS
Licensed Repository Views – Oracle Home Patching Views:
The following Oracle home patching views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:
- MGMT$APPLIED_PATCHES
- MGMT$APPLIED_PATCHSETS
- MGMT$APPL_PATCH_AND_PATCHSET
- MGMT$CPF_ADVISORY_INFO
- MGMT$CPF_HOMES_INFO
- MGMT$CPF_PATCH_INFO
- MGMT$EM_HOMES_PLATFORM
- MGMT$HOMES_AFFECTED
- MGMT$OH_CLONE_PROPERTIES
- MGMT$OH_COMP_DEP_RULE
- MGMT$OH_COMP_INST_TYPE
- MGMT$OH_COMPONENT
- MGMT$OH_CRS_NODES
- MGMT$OH_DEP_HOMES
- MGMT$OH_FILE
- MGMT$OH_HOME_INFO
- MGMT$OH_INSTALLED_TARGETS
- MGMT$OH_INV_SUMMARY
- MGMT$OH_PATCH
- MGMT$OH_PATCHED_COMPONENT
- MGMT$OH_PATCHED_FILE
- MGMT$OH_PATCH_FIXED_BUG
- MGMT$OH_PATCHSET
- MGMT$OH_VERSIONED_PATCHV
- MGMT$PATCH_ADVISORIES
Licensed Repository Views – Security Views:
The following security views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:
- 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
Licensed Repository Views – Client Configuration Views:
The following client configuration views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:
- MGMT$CSA_COLLECTIONS
- MGMT$CSA_FAILED
- MGMT$CSA_HOST_COOKIES
- MGMT$CSA_HOST_CPUS
- MGMT$CSA_HOST_CUSTOM
- MGMT$CSA_HOST_IOCARDS
- MGMT$CSA_HOST_NICS
- MGMT$CSA_HOST_OS_COMPONENTS
- MGMT$CSA_HOST_OS_FILESYSEMS
- MGMT$CSA_HOST_OS_PROPERTIES
- MGMT$CSA_HOST_RULES
- MGMT$CSA_HOST_SW
- MGMT$ECM_CONFIG_HISTORY
Oracle Diagnostics Pack
Extra cost pack: EE , EE-ES
Included pack: BaseDB EE , BaseDB EE-HP , BaseDB EE-EP , ExaDB
Oracle Diagnostics Pack includes the following features:
- Performance monitoring and diagnostics (database and host)
- Automatic Workload Repository (AWR)
- AWR Warehouse
- Automatic Database Diagnostic Monitor (ADDM)
- Compare Period ADDM
- Real Time ADDM
- ADDM Spotlight
- Active Session History (ASH)
- ASH analytics
- Performance Hub
- Top Activity Lite
- Exadata Cell Grid Administration
- Exadata Cell Grid Performance
- Exadata Cell Group Health Overview page
- Exadata Resource Utilization
- Blackouts
- Notifications
- Metric and Alert/Event history
- User-Defined Metrics and Metric Extensions
- Management Connectors
- Dynamic metric baselines and Adaptive metric thresholds
- Monitoring templates and Template Collections
- Replay Compare Period Report
- Supporting functionality to perform per stream bottleneck detection and per component top wait event analysis
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.
Any and all methods of accessing Oracle Diagnostics Pack functionality, whether through Enterprise Manager Console, Desktop Widgets, command-line APIs, or direct access to the underlying data, requires an Oracle Diagnostics Pack license.
To determine which links in Enterprise Manager 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 Cloud 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.
Licensed Command-Line APIs:
Oracle Diagnostics Pack features can also be accessed by way of database server APIs and command-line interfaces:
- The DBMS_ADDM , DBMS_PERF , DBMS_UMF , and DBMS_WORKLOAD_REPOSITORY packages are 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';
Licensed Repository Views – Monitoring Views:
The following monitoring views are licensed under Oracle Diagnostics Pack:
- MGMT$ALERT_ANNOTATIONS
- MGMT$ALERT_CURRENT
- MGMT$ALERT_HISTORY
- MGMT$ALERT_NOTIF_LOG
- MGMT$AVAILABILITY_CURRENT
- MGMT$AVAILABILITY_HISTORY
- MGMT$BLACKOUT_HISTORY
- MGMT$BLACKOUTS
- MGMT$METRIC_COLLECTIONS
- MGMT$ALERT_CURRENT
- MGMT$METRIC_DAILY
- MGMT$METRIC_DETAILS
- MGMT$METRIC_HOURLY
- MGMT$TARGET_METRIC_COLLECTIONS
- MGMT$TARGET_METRIC_SETTINGS
Licensed Repository Views – Template Views:
The following template views are licensed under Oracle Diagnostics Pack:
- MGMT$TEMPLATES
- MGMT$TEMPLATE_METRIC_COLLECTION
- MGMT$TEMPLATE_METRIC_SETTINGS
- MGMT$TEMPLATE_POLICY_SETTINGS
Additional Licensing Information:
- The use of Automatic Workload Repository Hub (AWR Hub) features in the database requires both an Oracle Diagnostics Pack license and an OCI Operations Insights Service subscription.
- The use of PL/SQL APIs through the DBMS_AWRHUB package requires both an Oracle Diagnostics Pack license and an OCI Operations Insights Service subscription.
- The use of ADDM Spotlight in Enterprise Manager requires an Oracle Diagnostics Pack license.
- The use of ADDM Spotlight in OCI Operations Insights Service requires both an Oracle Diagnostics Pack license and an OCI Operations Insights Service subscription.
- The use of Top Activity Lite in Enterprise Manager requires an Oracle Diagnostics Pack license.
- The use of Top Activity Lite in OCI Database Management Service requires both an Oracle Diagnostics Pack license and an OCI Database Management Service subscription – Full Management.
Oracle Tuning Pack
Extra cost pack: EE , EE-ES
Included pack: BaseDB EE , BaseDB EE-HP , BaseDB EE-EP , ExaDB
Oracle Tuning Pack includes the following features:
- SQL Access Advisor
- SQL Tuning Advisor
- Oracle Database In-Memory Advisor
- Automatic SQL Tuning
- SQL Profiles
- Real-time SQL and PL/SQL Monitoring
- Real-time Database Operations Monitoring
- Reorganize objects
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.
Any and all methods of accessing Oracle Tuning Pack functionality, whether through Enterprise Manager Console, Desktop Widgets, command-line APIs, or direct access to the underlying data, requires an Oracle Tuning Pack license.
Oracle Tuning Pack requires Oracle Diagnostics Pack.
To determine which links in Enterprise Manager 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 Cloud 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.
Licensed Command Line APIs:
Oracle Tuning Pack features can also be accessed by way of database server APIs and command-line interfaces:
- DBMS_ADVISOR , when the value of the advisor_name parameter is either SQL Tuning Advisor or SQL Access Advisor.
- DBMS_AUTO_SQLTUNE
- DBMS_PERF
- DBMS_SQL_MONITOR
- DBMS_SQLTUNE (See Note)
- 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 .
Note : If you are licensed for the on-premises Oracle Database Enterprise Edition, then you can use certain subprograms of the DBMS_SQLTUNE package even if you do not have an Oracle Tuning Pack license. See the SQL Tuning Sets entry in Table 1-6 for more information.
1.6 Checking for Feature, Option, and Management Pack Usage
Oracle provides the script options_packs_usage_statistics.sql , which enables you to check feature usage, Oracle Database option usage, and Oracle management pack usage on your database. This script lists, in two distinct sections:
- Oracle Database option and Oracle management pack usage
- Features used by each option and management pack
You can obtain the script from My Oracle Support as follows:
- Use a Web browser to view the My Oracle Support Web site: https://support.oracle.com
- Log in to My Oracle Support. If you are not a My Oracle Support registered user, then click Register and follow the registration instructions.
- Search for Document ID 1317265.1, or access it directly with the following URL: https://support.oracle.com/rs?type=doc&id=1317265.1
You can manually run the script on an individual database or use Oracle Enterprise Manager Job System to automatically run the script on multiple databases. Refer to Oracle Enterprise Manager Cloud Control Administrator's Guide for information on Oracle Enterprise Manager Job System.
The information obtained from this script will provide you an overview of the licensable Oracle Database options and Oracle management packs that were identified as used by your organization. This is to be used for informational purposes only and this does not represent your license entitlement or requirement. Please contact the License Management Services representative at http://www.oracle.com/us/corporate/license-management-services/index.html to understand your license requirements.
1.7 Special License Rights
Table 1-16 Special License Rights
Data Guard Far Sync
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.
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.
Global Data Services
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.
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, Sharding 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, Global Data Services Catalog, and Sharding 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 for RMAN, Oracle Enterprise Manager Cloud Control, AWR Warehouse, Global Data Services, and Grid infrastructure management Repository, then an Enterprise Edition license for the standby server is required. The Infrastructure Database for the Sharding Catalog can be protected with Data Guard without a second Enterprise Edition license.
Oracle ASM Cluster File System (Oracle ACFS)
When used with non-Oracle Database files, all Oracle ACFS features are free.
When used with Oracle Database files, all Oracle ACFS features are free, with the following exceptions:
- ACFS Auditing - Not available (use Oracle Audit Vault*)
- ACFS Compression - Not available (use Oracle Advanced Compression*)
- ACFS Encryption - Not available (use Oracle Transparent Data Encryption (TDE), part of the Oracle Advanced Security option*)
- ACFS Security - Not available (use Oracle Database Vault*)
* Requires appropriate full-use licenses to these products or components.
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.
Oracle Automatic Storage Management (Oracle ASM)
Oracle ASM is free to use with all Oracle databases and Oracle ACFS file systems.
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 that is under a valid Oracle support contract. Examples of such products include, but are not limited to, Oracle Linux, Oracle Solaris, Oracle Database, and Oracle Fusion Middleware.
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 Data Guard broker
You can install the broker command line interface DGMGRL and run the observer software on computer systems that are separate from the Oracle Data Guard primary and standby systems. It is not necessary to obtain a separate license for a system hosting the observer.
Oracle Database Backup Cloud Service
Oracle Database Backup Cloud Service includes use of the following two features from the Oracle Advanced Security option or the Oracle Advanced Compression option at no additional cost:
- 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 separately licensed when performing RMAN encrypted backups directly to disk.
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 Vault
When Oracle Database Vault is configured and enabled, it configures and enables Oracle Label Security. Oracle Label Security is solely restricted for use by the Oracle Database Vault software. If you want to create Oracle Label Security policies, then you must purchase a full-use license for Oracle Label Security.
Oracle Real Application Testing
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 Oracle9 i Database Release 2 or Oracle Database 10g.
The functionality available on Oracle9 i 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 9 i 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 Oracle9 i 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 9 i Database or Oracle Database 10g Release 1), Oracle Database 11g is needed to remotely execute SQL on the target database (that is, Oracle Database 10g Release 2). Oracle Real Application Testing licensing is required for both systems, Oracle Database 10g Release 2 and Oracle Database 11g.
Oracle Secure Backup
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 Cloud Module on ZDLRA
Oracle Secure Backup Cloud Module can be used free of charge on Oracle Zero Data Loss Recovery Appliance (ZDLRA) for the sole purpose of backing up data to and restoring data from S3-compatible storage devices that are in the same campus as ZDLRA.
This special use license does not allow you to move such data to or from Non-Oracle Public Cloud Environments, either directly or through gateway devices.
You are allowed to move such data to and from Oracle databases that do not have ZDLRA, however, Oracle Secure Backup Cloud Module must be licensed on those Oracle databases. For example, if you use Oracle Secure Backup Cloud Module free of charge on ZDLRA to back up data to an S3-compatible storage device, you can then use Oracle Secure Backup Cloud Module to restore that data to an Oracle database without ZDLRA, but only if Oracle Secure Backup Cloud Module is licensed on that Oracle database.
To move data to or from the Oracle Cloud Infrastructure, the ZDLRA provides an integration with the OCI Backup Cloud Module which does not require a license.
Oracle Secure Backup Express
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 .
Oracle Spatial and Graph
These Oracle Spatial and Graph components can be installed and used on a server different from the server where the Oracle Database is installed and used without a separate license:
- Spatial Geocoder
- Spatial Routing engine
- Spatial Web Services
- Property Graph client
- In-memory analyst (PGX)
- Spatial Visualization component
- Spatial Studio
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. Network encryption (native network encryption, network data integrity, and SSL/TLS) and strong authentication services (Kerberos, PKI, and RADIUS) are no longer part of Oracle Advanced Security and are available in all licensed editions of all supported releases of Oracle Database.
The shard directors 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 shard directors.
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.
1.8 Restricted Use Licenses
Table 1-17 Restricted Use Licenses
AQ Sharded Queues
Restricted use of Oracle Partitioning is allowed on all offerings, free of charge, for the sole purpose of supporting AQ Sharded Queues. All other uses of Oracle Partitioning require a license for the Oracle Partitioning option, where available.
Oracle Advanced Compression
Oracle Advanced Security
Restricted use licenses for Oracle Advanced Compression and Oracle Advanced Security are granted when performing either of the following migrations:
- Oracle Zero Downtime Migration
- Oracle Cloud Infrastructure Database Migration (DMS)
These restricted use licenses are in effect only while the migration is being performed and apply solely for the purposes of the migration operation. All other uses of Oracle Advanced Compression and Oracle Advanced Security require a license.
Oracle Advanced Security
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 Advanced Security includes a restricted use license for the following Oracle Enterprise Manager features:
- Application Data Models (previously called Data Discovery and Modeling)
- Sensitive Column Types and Sensitive Data Discovery
- Application Accelerators
If you want to use the Oracle Enterprise Manager features listed above not solely for the purposes of Oracle Advanced Security, then you must purchase a full-use license for Oracle Data Masking and Subsetting Pack.
Oracle Application Server Containers for J2EE
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, and Application Express, and may not be used or deployed for other purposes
Oracle Applications Unlimited
An Oracle Base Database Service Enterprise Edition (BaseDB EE) instance being used to support an Oracle Cloud deployment of an Oracle Applications Unlimited application has restricted use of the following options: Oracle On-Line Analytical Processing (OLAP) and Oracle Partitioning. These options may be used only to support Oracle Applications Unlimited and may not be used or deployed for any other purpose.
Oracle Big Data SQL
Oracle Big Data SQL includes a Query Server that is used to query data sources including HDFS, Kafka, and NoSQL stores. Oracle Big Data SQL includes a restricted use license of Oracle Database for storing metadata (i.e. external tables and views) maintained by the Query Server. No other objects may be created in this Oracle Database.
Oracle Data Masking and Subsetting Pack
A restricted use license for Oracle Advanced Security is included for encrypted Data Pump exports and imports used by Oracle Data Masking and Subsetting. No other features of Oracle Advanced Security are included.
Oracle Database Mobile Server
Oracle Database Mobile Server is a powerful tool for controlling networks of mobile or embedded devices from a centralized management console. It provides a secure, scalable method for connecting applications running locally on mobile or embedded devices to an Oracle enterprise backend. The synchronization system is robust and fault tolerant. It is able to successfully synchronize over unreliable or intermittently available networks. Oracle Database Mobile Server provides management for applications, users, and devices. It runs on a variety of application server platforms, including Oracle WebLogic, Oracle Glassfish, and Apache TomEE.
On the client device side, it is designed to work with Oracle Berkeley DB as a data store, providing efficient, reliable, and secure data management running locally on mobile and embedded devices. It is also compatible with SQLite, a widely used open source data store. Database Mobile Server supports many popular device platforms including Oracle Java, Linux, Windows (laptop as well as mobile/CE), and Android.
Oracle Database Vault
Oracle Database Vault includes a restricted use license for the following Oracle Enterprise Management features:
- Application Data Modeling (previously called Data Discovery and Modeling)
- Application Data Modeling accelerator for select versions of Oracle E-Business Suite
- Application Data Modeling accelerator for select versions of Oracle Fusion Applications
Oracle HTTP Server
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
Oracle Internet Directory
Oracle Unified Directory
A restricted use license for Oracle Identity Management Directory Services Plus components Oracle Internet Directory (OID)/Oracle Unified Directory (OUD) is included with all editions (except for Oracle Database Express Edition) if users use the Directory Naming feature to configure Oracle Net Services. OID/OUD may not be used or deployed for other uses.
Oracle Label Security
Oracle Label Security includes a restricted use license for the following Oracle Enterprise Manager features:
- Application Data Models (previously called Data Discovery and Modeling)
- Sensitive Column Types and Sensitive Data Discovery
- Application Accelerators
If you want to use the Oracle Enterprise Manager features listed above not solely for the purposes of Oracle Label Security, then you must purchase a full-use license for Oracle Data Masking and Subsetting Pack.
Oracle Programmer provides application programmers with a programmatic interface to any edition of Oracle Database. However, in order to user Oracle Programmer, you must purchase a separate Oracle Programmer license.
Oracle Programmer includes the following products:
- Embedded SQL-style interfaces: Pro*C/C++, Pro*COBOL, Pro*Fortran, SQL*Module for Ada, SQLJ
- Utilities to generate host-language bindings from database schemas: Object Type Translator and JPub
Oracle Radius Agent
A restricted use license for Oracle Identity Management Directory Services Plus component Oracle Radius Agent (ORA) is included with all editions (except for Oracle Database Express Edition) if users use Oracle Unified Directory/Oracle Internet Directory/Microsoft Active Directory for first-factor authentication. ORA may not be used or deployed for use with other Radius services. For MFA capabilities, additional licensing would be required, refer to Oracle Identity and Access Management Independent License Offerings.
Oracle Real Application Testing
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 Secure Backup Express
Oracle Secure Backup Express is a centralized tape backup management solution that provides data protection for single-server Oracle Database environments. A restricted use license for Oracle Secure Backup Express is included with all Oracle Database editions. Oracle Secure Backup Express is limited to a single host with one direct-attached tape drive and has some restrictions on advanced feature usage. Refer to the Oracle Secure Backup Licensing Information for additional information.
Oracle Sharding includes a restricted use license for Global Data Services.
If you want to use Global Data Services not solely for the purposes of Oracle Sharding, then you must be licensed for the Oracle Active Data Guard option.
Oracle Spatial and Graph
Restricted use of Oracle Partitioning is allowed on all offerings, free of charge, for the sole purpose of supporting the following Spatial, Property Graph, and RDF Graph Technologies (RDF/OWL) features: spatial topology, property graph schema, and RDF Semantic Graph. All other uses of Oracle Partitioning require a license for the Oracle Partitioning option, where available.
Oracle Zero Data Loss Recovery Appliance (ZDLRA)
Restricted use of Oracle Advanced Security is allowed for Oracle databases hosted on on-premises Linux platforms, free of charge, for the sole purpose of using the Recovery Appliance Space-Efficient Encrypted Backup feature of ZDLRA. All other uses of Oracle Advanced Security require a license for the Oracle Advanced Security option, where available.
Recovery Manager (RMAN)
Restricted use of Oracle Partitioning is allowed on all offerings, free of charge, for the sole purpose of supporting the RMAN recovery catalog. All other uses of Oracle Partitioning require a license for the Oracle Partitioning option, where available.
Real Application Security
Restricted use of Real Application Security (RAS) is allowed on Oracle Database Standard Edition 2 (SE2) and Oracle Base Database Service Standard Edition (BaseDB SE), free of charge, for the sole purpose of using the subprograms in the DBMS_NETWORK_ACL_ADMIN package.
Restricted use of Oracle Partitioning is allowed on all offerings, free of charge, for the sole purpose of storing the unified audit trail. All other uses of Oracle Partitioning require a license for the Oracle Partitioning option, where available.
