Database Licensing Information User Manual

Oracle® Database

21c

F31218-34

August 2024

Oracle Database Database Licensing Information User Manual, 21c

F31218-34

Contributors: Prabhaker Gongloor, Mughees Minhas, Anu Natarajan, Jill Robinson, Jenny Tsai-Smith

This software and related documentation are provided under a license agreement containing restrictions on use and

disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or

allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit,

perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation

of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find

any errors, please report them to us in writing.

If this is software, software documentation, data (as defined in the Federal Acquisition Regulation), or related

documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then

the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software, any

programs embedded, installed, or activated on delivered hardware, and modifications of such programs) and Oracle

computer documentation or other Oracle data delivered to or accessed by U.S. Government end users are "commercial

computer software," "commercial computer software documentation," or "limited rights data" pursuant to the applicable

Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, reproduction,

duplication, release, display, disclosure, modification, preparation of derivative works, and/or adaptation of i) Oracle

programs (including any operating system, integrated software, any programs embedded, installed, or activated on

delivered hardware, and modifications of such programs), ii) Oracle computer documentation and/or iii) other Oracle

data, is subject to the rights and limitations specified in the license contained in the applicable contract. The terms

governing the U.S. Government's use of Oracle cloud services are defined by the applicable contract for such services.

No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not

developed or intended for use in any inherently dangerous applications, including applications that may create a risk of

personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all

appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its

affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle®, Java, MySQL, and NetSuite are registered trademarks of Oracle and/or its affiliates. Other names may be

trademarks of their respective owners.

Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used

under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc, and the AMD logo

are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open

Group.

This software or hardware and documentation may provide access to or information about content, products, and

services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all

warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an

applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss,

costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth

in an applicable agreement between you and Oracle.

Contents

Preface

Audience vi

Documentation Accessibility vi

Diversity and Inclusion vi

Related Documents

For more information, see these Oracle resources:

• Learning Database New Features for information on the features new to this release of

Oracle Database

• Oracle Global Pricing and Licensing, available at:

Preface

http://www.oracle.com/us/corporate/pricing/index.html

• Oracle Database licensing guidelines, available at:

https://www.oracle.com/assets/databaselicensing-070584.pdf

Conventions

The following text conventions are used in this document:

Convention Meaning

boldface

Boldface type indicates graphical user interface elements associated with an

action, or terms defined in text or the glossary.

italic Italic type indicates book titles, emphasis, or placeholder variables for which

you supply particular values.

monospace

Monospace type indicates commands within a paragraph, URLs, code in

examples, text that appears on the screen, or text that you enter.

Preface

vii

Licensing Information

• Introduction

• Oracle Database Offerings

• Permitted Features, Options, and Management Packs by Oracle Database Offering

• Oracle Database Options and Their Permitted Features

• Oracle Management Packs and Their Permitted Features

• Checking for Feature, Option, and Management Pack Usage

• Special License Rights

• Restricted Use Licenses

1.1 Introduction

This Licensing Information document is a part of the product or program documentation under

the terms of your Oracle license agreement and is intended to help you understand the

program editions, entitlements, restrictions, prerequisites, special license rights, and/or

separately licensed third party technology terms associated with the Oracle software

program(s) covered by this document (the "Program(s)"). Entitled or restricted use products or

components identified in this document that are not provided with the particular Program may

be obtained from the Oracle Software Delivery Cloud website (

https://

edelivery.oracle.com

) or from media Oracle may provide. If you have a question about your

license rights and obligations, please contact your Oracle sales representative, review the

information provided in Oracle’s Software Investment Guide (

http://www.oracle.com/us/

corporate/pricing/software-investment-guide/index.html

), and/or contact the applicable

Oracle License Management Services representative listed on

http://www.oracle.com/us/

corporate/license-management-services/index.html

1-1

1.2 Oracle Database Offerings

Table 1-1 Oracle Database Offerings

Oracle Database Offering License

Deployment

Options

Abbreviated Name

Used in this Guide

Description

Oracle Database Express

Edition

On-Premises

Oracle Database Express Edition is available on

Linux x86-64 and Microsoft Windows platforms, and

is released under the Oracle Free Use Terms and

Conditions, which are described on the following

Oracle Technology Network website:

https://www.oracle.com/downloads/

licenses/oracle-free-license.html

The following development platforms are not included

with Oracle Database Express Edition. You can

download them separately and use them with Oracle

Database Express Edition:

• Oracle APEX

• Oracle Developer Tools for Visual Studio

• Oracle REST Data Services (ORDS)

• Oracle SQL Developer

Oracle Database Standard

Edition 2

On-Premises,

OCI*, and

ACEs**

SE2

Oracle Database Standard Edition 2 includes features

necessary to develop workgroup, department-level,

and Web applications.

Oracle Database Enterprise

Edition

On-Premises,

OCI*, and

ACEs**

Oracle Database Enterprise Edition provides

performance, availability, scalability, and security for

developing applications such as high-volume online

transaction processing (OLTP) applications, query-

intensive data warehouses, and demanding Internet

applications.

Oracle Database Enterprise Edition can be enhanced

with the purchase of Oracle Database options and

Oracle management packs.

Oracle Database Enterprise

Edition on Engineered

Systems

On-Premises,

OCI*, and

ACEs**

EE-ES

Oracle Database Enterprise Edition software installed

on an engineered system (Oracle Exadata Database

Machine or Oracle Database Appliance).

Includes all of the components of Oracle Database.

You can further enhance this offering with the

purchase of Oracle Database options and Oracle

management packs.

The licensing policies for EE-ES vary depending on

whether it is installed on Oracle Exadata Database

Machine or Oracle Database Appliance. Be sure to

make note of these differences, which are

documented in the subsequent sections of this guide.

Chapter 1

Oracle Database Offerings

1-2

Table 1-1 (Cont.) Oracle Database Offerings

Oracle Database Offering License

Deployment

Options

Abbreviated Name

Used in this Guide

Description

Oracle Database Personal

Edition

On-Premises

Oracle Database Personal Edition supports single-

user development and deployment environments that

require full compatibility with Oracle Database

Standard Edition 2 and Oracle Database Enterprise

Edition.

Includes all of the components that are included with

Enterprise Edition, as well as all Oracle Database

options, with the exception of the Oracle RAC One

Node and Oracle Real Application Clusters options,

which cannot be used with Personal Edition. Personal

Edition is available on Linux and Windows platforms

only. Oracle management packs cannot be used with

Personal Edition.

Oracle Base Database

Service Standard Edition

OCI*

BaseDB SE

Includes Oracle Database Standard Edition 2

software.

Oracle Base Database

Service Enterprise Edition

OCI*

BaseDB EE

Includes Oracle Database Enterprise Edition

software.

Oracle Base Database

Service Enterprise Edition -

High Performance

OCI*

BaseDB EE-HP

Includes Oracle Base Database Service Enterprise

Edition software plus many Oracle Database options

and Oracle management packs

Oracle Base Database

Service Enterprise Edition -

Extreme Performance

OCI*

BaseDB EE-EP

Includes Oracle Base Database Service Enterprise

Edition software plus all Oracle Database options and

Oracle management packs that are appropriate for

use in the cloud.

Oracle Database Exadata

Cloud Service

Oracle Database Exadata

Cloud@Customer

OCI*

ExaCS/CC This guide uses ExaCS/CC to describe the licensing

policies for both Oracle Database Exadata Cloud

Service and Oracle Database Exadata

Cloud@Customer.

These offerings include Oracle Database Enterprise

Edition software plus all Oracle Database options and

Oracle management packs that are appropriate for

use in Oracle Database Exadata Cloud Service or

Oracle Database Exadata Cloud@Customer.

* OCI: Oracle Cloud Infrastructure

**ACEs: Authorized Cloud Environments

Note:

For the list of Authorized Cloud Environments, see

https://www.oracle.com/

assets/cloud-licensing-070579.pdf

. All other public clouds and environments that

are in any way considered an extension of non-Authorized Cloud Environments, such

as cloud management, cloud billing, cloud support, cloud automation, cloud images,

or cloud monitoring software, are not Authorized Cloud Environments.

Chapter 1

Oracle Database Offerings

1-3

1.3 Permitted Features, Options, and Management Packs by

Oracle Database Offering

The tables in this section list Oracle Database features, Oracle Database options, and Oracle

management packs, and their availability for each Oracle Database offering. The

value in a

column means that the feature, option, or pack is available for a particular offering;

means

that it is unavailable;

N/A

means that it is not applicable. These tables can help you understand

the difference between Oracle Database offerings to determine which one is right for you.

The tables are organized into the following functional categories:

• Autonomous - Table 1-2

• Consolidation - Table 1-3

• Development Platform - Table 1-4

• High Availability - Table 1-5

• Integration - Table 1-6

• Manageability - Table 1-7

• Networking - Table 1-8

• Performance - Table 1-9

• Scalability - Table 1-10

• Security - Table 1-11

• Snapshots and Cloning - Table 1-12

• Spatial and Graph Data - Table 1-13

• VLDB, Data Warehousing, and Business Intelligence - Table 1-14

Table 1-2 Autonomous

Feature / Option /

Pack

XE SE2 EE EE-

Base

EE-HP

Base

EE-EP

ExaCS/

Notes

Automatic

Materialized Views

N N N Y N N N N Y

EE-ES: Available on Exadata.

Not available on Oracle

Database Appliance.

Automatic

Temporary

Tablespace Shrink

N N Y Y Y Y Y Y Y

CLOUD: Only available in OCI.

Automatic Undo

Tablespace Shrink

N N Y Y Y Y Y Y Y

CLOUD: Only available in OCI.

Automatic Zone

Maps

N N N Y N N N N Y

EE-ES: Available on Exadata

and requires the Oracle

Partitioning option. Not

available on Oracle Database

Appliance.

Cache Fusion

Hardening

N N N Y N N N N Y

EE-ES: Available on Exadata.

Not available on Oracle

Database Appliance.

Chapter 1

Permitted Features, Options, and Management Packs by Oracle Database Offering

1-4

Table 1-3 Consolidation

Feature / Option /

Pack

XE SE2 EE EE-

Base

EE-HP

Base

EE-EP

ExaCS/

Notes

Oracle Multitenant -

# of PDBs

252 3 252 4096 3 3 4096 4096 4096 The number value in each

column indicates the

maximum number of

pluggable databases (PDBs)

that can be created for each

offering.

• For all offerings, if you

are not licensed for

Oracle Multitenant, then

you may have up to 3

user-created PDBs in a

given container

database at any time.

•

XE: Included option;

you are licensed to

create up to 252 PDBs,

however, the actual

number of PDBs you

can create might be

lower due to XE

resource limits.

•

EE: Extra cost option; if

you are licensed for

Oracle Multitenant, then

you can create up to

252 PDBs.

•

EE-ES: Extra cost

option; if you are

licensed for Oracle

Multitenant, then you

can create up to 4096

PDBs.

•

BaseDB EE-HP,

BaseDB EE-EP, and

ExaCS/CC: License

included option: You

can create up to 4096

PDBs. BYOL option:

Limit is 3 PDBs, unless

you purchase the

Oracle Multitenant

option.

Authorized Cloud

Environments: Use is

limited to three pluggable

databases per container

database.

CDB Fleet

Management

N N N Y N Y Y Y Y

PDB Snapshot

Carousel

N N N Y N Y Y Y Y

Chapter 1

Permitted Features, Options, and Management Packs by Oracle Database Offering

1-5

Table 1-3 (Cont.) Consolidation

Feature / Option /

Pack

XE SE2 EE EE-

Base

EE-HP

Base

EE-EP

ExaCS/

Notes

Refreshable PDB

switchover

N N N Y Y Y Y Y Y

Table 1-4 Development Platform

Feature / Option /

Pack

XE SE2 EE EE-

Base

EE-HP

Base

EE-EP

ExaCS/

Notes

SQLJ Y Y Y Y Y Y Y Y Y Requires Oracle Programmer

Oracle Developer

Tools for Visual

Studio

Y Y Y N/A N/A N/A N/A N/A N/A Windows only

Microsoft Distributed

Transaction

Coordinator support

Y Y Y N/A N/A N/A N/A N/A N/A Windows only

Native .NET Data

Provider—ODP.NET

Y Y Y N/A N/A N/A N/A N/A N/A Windows only

.NET Stored

Procedures

Y Y Y N/A N/A N/A N/A N/A N/A Windows only

Table 1-5 High Availability

Feature / Option /

Pack

XE SE2 EE EE-

Base

EE-HP

Base

EE-EP

ExaCS/

Notes

Application

Continuity

N N Y Y N N N Y Y

EE and EE-ES: Requires the

Oracle Active Data Guard

option, the Oracle RAC One

Node option, or the Oracle

Real Application Clusters

option

Chapter 1

Permitted Features, Options, and Management Packs by Oracle Database Offering

1-6

Table 1-5 (Cont.) High Availability

Feature / Option /

Pack

XE SE2 EE EE-

Base

EE-HP

Base

EE-EP

ExaCS/

Notes

Oracle Sharding N N Y Y N Y Y Y Y

EE and EE-ES: No limit on the

number of either primary

shards or standby shards if

every shard has an Oracle

Active Data Guard, Oracle

GoldenGate, or Oracle RAC

license. Without an Oracle

Active Data Guard, Oracle

GoldenGate, or Oracle RAC

license, use is limited to three

primary shards, with basic

Data Guard standbys.

BaseDB EE, BaseDB EE-HP,

and Authorized Cloud

Environments: Use is limited

to three primary shards; there

is no limit on the number of

standby shards.

BaseDB EE-EP and

ExaCS/CC: No limit on the

number of either primary

shards or standby shards.

Oracle Fail Safe N Y Y N/A N/A N/A N/A N/A N/A Windows only

Oracle RAC One

Node

N N Y Y N N N N N

EE and EE-ES: Extra cost

option

Standard Edition

High Availability

N Y N N N N N N N

Enterprise Edition

High Availability

N N N Y N N N N N

EE-ES: Available on Oracle

Database Appliance. Not

available on Exadata.

Oracle Data Guard—

Redo Apply

N N Y Y N Y Y Y Y

Oracle Data Guard—

Far Sync Standby

N N Y Y N N N Y Y

EE and EE-ES: Requires the

Oracle Active Data Guard

option

Oracle Data Guard—

SQL Apply

N N Y Y N Y Y Y Y

Oracle Data Guard—

Snapshot Standby

N N Y Y N Y Y Y Y

Oracle Data Guard—

Real-Time

Cascading Standbys

N N Y Y N N N Y Y

EE and EE-ES: Requires the

Oracle Active Data Guard

option

Oracle Data Guard—

Automatic Correction

of Non-logged

Blocks at a Data

Guard Standby

Database

N N N Y N N N Y Y

EE-ES: Requires the Oracle

Active Data Guard option

Chapter 1

Permitted Features, Options, and Management Packs by Oracle Database Offering

1-7

Table 1-5 (Cont.) High Availability

Feature / Option /

Pack

XE SE2 EE EE-

Base

EE-HP

Base

EE-EP

ExaCS/

Notes

Oracle Active Data

Guard

N N Y Y N N N Y Y

EE and EE-ES: Extra cost

option

CLOUD: Active Data Guard

DML Redirection is only

available in OCI.

Rolling Upgrades—

Patch Set, Database,

and Operating

System

N N Y Y N Y Y Y Y

Rolling Upgrade

Using Active Data

Guard

N N Y Y N N N Y Y

EE and EE-ES: Requires the

Oracle Active Data Guard

option

Online index rebuild Y N Y Y N Y Y Y Y

Online table

organization

Y N Y Y N Y Y Y Y

ALTER

TABLE

...

MOVE

ONLINE

operations

Online table

redefinition

Y N Y Y N Y Y Y Y Using the

DBMS_REDEFINITION

package

Duplexed backup

sets

N N Y Y N Y Y Y Y

Block change

tracking for fast

incremental backup

N N Y Y N Y Y Y Y

Unused block

compression in

backups

N N Y Y N Y Y Y Y

Block-level media

recovery

N N Y Y N Y Y Y Y

Lost Write Protection N N Y Y N Y Y Y Y

Automatic Block

Repair

N N Y Y N N N Y Y

EE and EE-ES: Requires the

Oracle Active Data Guard

option

Parallel backup and

recovery

N N Y Y N Y Y Y Y

Tablespace point-in-

time recovery

N N Y Y N Y Y Y Y

Trial recovery Y N Y Y N Y Y Y Y

Fast-start fault

recovery

Y N Y Y N Y Y Y Y

Flashback Table Y N Y Y N Y Y Y Y

Flashback Database Y N Y Y N Y Y Y Y

Flashback

Transaction

N N Y Y N Y Y Y Y

Flashback

Transaction Query

N N Y Y N Y Y Y Y

Chapter 1

Permitted Features, Options, and Management Packs by Oracle Database Offering

1-8

Table 1-5 (Cont.) High Availability

Feature / Option /

Pack

XE SE2 EE EE-

Base

EE-HP

Base

EE-EP

ExaCS/

Notes

Optimization for

Flashback Time

Travel

(formerly

Optimization for

Flashback Data

Archive)

N N Y Y N N Y Y Y Basic Flashback Time Travel is

in all offerings

EE and EE-ES: Optimization

for Flashback Time Travel

requires the Oracle Advanced

Compression option

Online Datafile Move N N Y Y N Y Y Y Y

Transaction Guard N N Y Y N Y Y Y Y

Cross-platform

Backup and

Recovery

Y N Y Y N Y Y Y Y

Global Data

Services

N N Y Y N N N Y Y

EE and EE-ES: Requires the

Oracle Active Data Guard

option

Recovering tables

and table partitions

from RMAN backups

N N Y Y N Y Y Y Y

Table 1-6 Integration

Feature / Option /

Pack

XE SE2 EE EE-

Base

EE-HP

Base

EE-EP

ExaCS/

Notes

Database Gateways N Y Y Y Y Y Y Y Y Includes Database Gateway

for ODBC

All other Database Gateway

products require a separate

product license

Messaging Gateway N N Y Y N Y Y Y Y

AQ Sharded Queues Y Y Y Y Y Y Y Y Y Includes a restricted use

license for Oracle Partitioning.

Refer to AQ Sharded Queues

in "Restricted Use Licenses"

for more information.

Transactional Event

Queues (TEQ)

Y Y Y Y Y Y Y Y Y Includes a restricted use

license for Oracle Partitioning.

Refer to Transactional Event

Queues in "Restricted Use

Licenses" for more information.

Chapter 1

Permitted Features, Options, and Management Packs by Oracle Database Offering

1-9

Table 1-7 Manageability

Feature / Option /

Pack

XE SE2 EE EE-

Base

EE-HP

Base

EE-EP

ExaCS/

Notes

Oracle Cloud

Management Pack

for Oracle Database

N N Y Y N N Y Y Y

EE and EE-ES: Extra cost

option

Oracle Data Masking

and Subsetting Pack

N N Y Y N Y Y Y Y

EE and EE-ES: Extra cost

option

Oracle Database

Lifecycle

Management Pack

for Oracle Database

N N Y Y N N Y Y Y

EE and EE-ES: Extra cost

option

Oracle Diagnostics

Pack

N N Y Y N Y Y Y Y

EE and EE-ES: Extra cost

option

Oracle Tuning Pack N N Y Y N Y Y Y Y

EE and EE-ES: Extra cost

option, also requires Oracle

Diagnostics Pack

Oracle Real

Application Testing

N N Y Y N Y Y Y Y

EE and EE-ES: Extra cost

option

Database Resource

Manager

N N Y Y N Y Y Y Y

I/O Resource

Management

N N N Y N N N N Y

Instance Caging N Y Y Y Y Y Y Y Y

Chapter 1

Permitted Features, Options, and Management Packs by Oracle Database Offering

1-10

Table 1-7 (Cont.) Manageability

Feature / Option /

Pack

XE SE2 EE EE-

Base

EE-HP

Base

EE-EP

ExaCS/

Notes

SQL Plan

Management

N Y Y Y Y Y Y Y Y SQL Plan Management does

not require a license for Oracle

Diagnostics Pack or Oracle

Tuning Pack

SE2 and BaseDB SE

Summary: Only one SQL plan

baseline per SQL statement is

allowed and SQL plan

evolution is disabled.

SE2 and BaseDB SE Details:

1. SQL plan baselines can

be created or captured

using the following

methods:

• Auto capture

(

OPTIMIZER_CAPTUR

E_SQL_PLAN_BASELI

NE=TRUE

)

• Manual loading from

the cursor cache

(

DBMS_SPM.LOAD_PL

ANS_FROM

CURSOR_CACHE

)

• Migration from stored

outlines

(

DBMS_SPM.MIGRATE

_STORED_OUTLINE

)

• Import using

DBMS_SPM.UNPACK_S

TGTAB_BASELINE

2. All capture and creation

methods store only one

SQL plan baseline per

SQL statement.

3. SQL plan baselines can

be exported and imported

using

DBMS_SPM.CREATE_STGT

AB_BASELINE

DBMS_SPM.PACK_STGTAB

_BASELINE

, and

DBMS_SPM.UNPACK_STGT

AB_BASELINE

4. Unused SQL plan

baselines are not auto-

purged.

5. Alternative SQL execution

plans for SQL statements

Chapter 1

Permitted Features, Options, and Management Packs by Oracle Database Offering

1-11

Table 1-7 (Cont.) Manageability

Feature / Option /

Pack

XE SE2 EE EE-

Base

EE-HP

Base

EE-EP

ExaCS/

Notes

are not added to the SQL

plan history.

6. SQL plan baselines can

be altered and dropped

(

DBMS_SPM.ALTER_SQL_P

LAN_BASELINE

and

DBMS_SPM.DROP_SQL_PL

AN_BASELINE

7. The following

DBMS_SPM

functions and procedures

are not allowed:

CONFIGURE

LOAD_PLANS_FROM_AWR

LOAD_PLANS_FROM_SQLS

, and all functions and

procedures associated

with SQL plan evolution.

Automatic SQL Plan

Management

N N N Y N N N N Y

EE-ES: Available on Exadata.

Not available on Oracle

Database Appliance.

SQL Tuning Sets N N Y Y N Y Y Y Y

EE and EE-ES: SQL Tuning

Sets can also be accessed by

way of database server APIs

and command-line interfaces.

Usage of any subprograms in

the

DBMS_SQLSET

package to

manage SQL Tuning Sets is

part of the EE and EE-ES

offerings. In addition, the

following subprograms, part of

the

DBMS_SQLTUNE

package,

provide an older interface to

manage SQL Tuning Sets and

are also part of the EE and

EE-ES offerings:

ADD_SQLSET_REFERENCE

CAPTURE_CURSOR_CACHE_SQL

SET

CREATE_SQLSET

CREATE_STGTAB_SQLSET

DELETE_SQLSET

DROP_SQLSET

LOAD_SQLSET

PACK_STGTAB_SQLSET

REMOVE_SQLSET_REFERENCE

SELECT_CURSOR_CACHE

SELECT_SQLSET

SELECT_WORKLOAD_REPOSITO

UNPACK_STGTAB_SQLSET

UPDATE_SQLSET

Chapter 1

Permitted Features, Options, and Management Packs by Oracle Database Offering

1-12

Table 1-7 (Cont.) Manageability

Feature / Option /

Pack

XE SE2 EE EE-

Base

EE-HP

Base

EE-EP

ExaCS/

Notes

Oracle Fleet

Patching and

Provisioning

(formerly Rapid

Home Provisioning)

N N Y Y N/A N/A N/A N/A N/A

EE and EE-ES: When

deployed across multiple

clusters, each FPP-managed

target must be licensed for one

of the following: Oracle

Database Lifecycle

Management Pack, Oracle

RAC, or Oracle RAC One

Node

Automatic Index

Optimization

Y N Y Y Y Y Y Y Y

EE and EE-ES: Requires the

Oracle Advanced Compression

option

Database Resident

Connection Pooling

Per PDB for Tenancy

Management

Y N Y Y N Y Y Y Y

CLOUD: Only available in OCI.

Reverse Connection

Support Using

CMAN Tunnels

N N N Y N N N N Y

EE-ES: Available on Exadata.

Not available on Oracle

Database Appliance.

GoldenGate per-

PDB Change

Capture for

Multitenant

Database

N N Y Y N Y Y Y Y

CLOUD: Only available in OCI.

Table 1-8 Networking

Feature / Option /

Pack

XE SE2 EE EE-

Base

EE-HP

Base

EE-EP

ExaCS/

Notes

RDMA fabric N N N Y N N N N Y

EE-ES: Available on Exadata.

Not available on Oracle

Database Appliance.

Oracle Connection

Manager

N N Y Y N Y Y Y Y Available via a custom install of

the Oracle Database client,

usually installed on a separate

machine or compute instance

Network

Compression

Y N Y Y N N Y Y Y

EE and EE-ES: Requires the

Oracle Advanced Compression

option

Chapter 1

Permitted Features, Options, and Management Packs by Oracle Database Offering

1-13

Table 1-9 Performance

Feature / Option /

Pack

XE SE2 EE EE-

Base

EE-HP

Base

EE-EP

ExaCS/

Notes

Automatic Indexing N N N Y N N N N Y

EE-ES: Available on Exadata.

Not available on Oracle

Database Appliance.

SQL Quarantine N N N Y N N N N Y

EE-ES: Available on Exadata.

Not available on Oracle

Database Appliance.

Real-Time Statistics N N N Y N N N N Y

EE-ES: Available on Exadata.

Not available on Oracle

Database Appliance.

High-Frequency

Automatic Optimizer

Statistics Collection

N N N Y N N N N Y

EE-ES: Available on Exadata.

Not available on Oracle

Database Appliance.

Client Side Query

Cache

Y N Y Y N Y Y Y Y

Query Results

Cache

Y N Y Y N Y Y Y Y

PL/SQL Function

Result Cache

Y N Y Y N Y Y Y Y

Oracle TimesTen

Application-Tier

Database Cache

N N Y Y N N N N N

EE and EE-ES: Extra cost

option

Database Smart

Flash Cache

N N Y Y N/A N/A N/A N/A N/A

EE: Solaris and Oracle Linux

only

EE-ES: Available on Oracle

Database Appliance. Not

available on Exadata

Support for Oracle

Exadata Storage

Server Software

N N N Y N N N N Y

EE-ES: Available on Exadata.

Not available on Oracle

Database Appliance.

Adaptive Execution

Plans

Y N Y Y N Y Y Y Y

Concurrent

Execution of

UNION

and

UNION

ALL

Branches

N N Y Y N Y Y Y Y

Oracle Database In-

Memory

Y N Y Y N N N Y Y

EE and EE-ES: Extra cost

option

In-Memory Column

Cache on Storage

Servers

N N N Y N N N N Y

EE-ES: Available on Exadata

and requires the Oracle

Database In-Memory option.

Not available on Oracle

Database Appliance.

Requires Exadata or

Supercluster

Chapter 1

Permitted Features, Options, and Management Packs by Oracle Database Offering

1-14

Table 1-9 (Cont.) Performance

Feature / Option /

Pack

XE SE2 EE EE-

Base

EE-HP

Base

EE-EP

ExaCS/

Notes

In-Memory Column

Store on Active Data

Guard standby

N N N Y N N N N Y

EE-ES: Available on Exadata

and requires the Oracle

Database In-Memory option

and the Oracle Active Data

Guard option. Not available on

Oracle Database Appliance.

Fault Tolerant In-

Memory Column

Store

N N N Y N N N N Y

EE-ES: Available on Exadata

and Oracle Database

Appliance. Requires the Oracle

Database In-Memory option

and the Oracle Real

Application Clusters option.

Requires Exadata,

Supercluster, or Infiniband-

based Oracle Database

Appliance

In-Memory Column

Store support for

External Tables

Y N Y Y N N N Y Y

EE and EE-ES: Requires the

Oracle Database In-Memory

option

In-Memory

Aggregation

Y N Y Y N N N Y Y

EE and EE-ES: Requires the

Oracle Database In-Memory

option

Automatic In-

Memory

Y N Y Y N N N Y Y

EE and EE-ES: Requires the

Oracle Database In-Memory

option

In-Memory Deep

Vectorization

Y N Y Y N N N Y Y

EE and EE-ES: Requires the

Oracle Database In-Memory

option

In-Memory Full Text

Columns

Y N Y Y N N N Y Y

EE and EE-ES: Requires the

Oracle Database In-Memory

option

Chapter 1

Permitted Features, Options, and Management Packs by Oracle Database Offering

1-15

Table 1-9 (Cont.) Performance

Feature / Option /

Pack

XE SE2 EE EE-

Base

EE-HP

Base

EE-EP

ExaCS/

Notes

Database In-Memory

Base Level

Y N Y Y N N N Y Y Allows you to experiment with

Oracle Database In-Memory

features without purchasing

the Oracle Database In-

Memory option. The following

restrictions apply:

• The size of the In-Memory

area (

INMEMORY_SIZE

)

cannot exceed 16 GB for a

CDB. In an Oracle RAC

environment, the size is

limited to 16 GB for each

instance.

• The compression level for

all objects and columns is

automatically and

transparently set to

QUERY

LOW

• The Automatic In-Memory

feature is disabled.

• In-Memory Column Store

feature tracking is tracked

for "In-Memory Base

Level" rather than "In-

Memory Column Store."

• The CellMemory feature is

disabled for Oracle

Exadata.

CLOUD: Only available in OCI.

Text Index Support

for Sharded Tables

(Search Index)

N N Y Y N N N Y Y

EE and EE-ES: Requires the

Oracle Database In-Memory

option

Memoptimized

Rowstore

Y N Y Y N Y Y Y Y

Attribute Clustering Y N Y Y N Y Y Y Y

Zone Maps N N N Y N N N N Y

EE-ES: Available on Exadata

and requires the Oracle

Partitioning option. Not

available on Oracle Database

Appliance.

Buffer Cache RDMA-

Read

N N N Y N N N N Y

EE-ES: Available on Exadata.

Not available on Oracle

Database Appliance.

Persistent Memory

Database

N N Y Y N N N N Y Requires Intel Optane

Persistent Memory

CLOUD: Only available in OCI.

Chapter 1

Permitted Features, Options, and Management Packs by Oracle Database Offering

1-16

Table 1-10 Scalability

Feature / Option /

Pack

XE SE2 EE EE-

Base

EE-HP

Base

EE-EP

ExaCS/

Notes

Oracle Real

Application Clusters

(Oracle RAC)

N N Y Y N N N Y Y

EE and EE-ES: Extra cost

option

Automatic Workload

Management

N N Y Y N N N Y Y

EE and EE-ES: Requires the

Oracle Real Application

Clusters option

Quality of Service

Management

N N Y Y N N N Y Y

EE and EE-ES: Requires the

Oracle RAC One Node option

or the Oracle Real Application

Clusters option

Oracle NoSQL

Database Enterprise

Edition

N N Y Y N/A N/A N/A N/A N/A

Table 1-11 Security

Feature / Option /

Pack

XE SE2 EE EE-

Base

EE-HP

Base

EE-EP

ExaCS/

Notes

Transparent Data

Encryption (TDE) for

Columns

Y N Y Y N N Y Y Y

EE and EE-ES: Requires the

Oracle Advanced Security

option

Transparent Data

Encryption (TDE) for

Tablespaces

Y N Y Y Y Y Y Y Y

XE: TDE online method to

encrypt/rekey/decrypt an

existing tablespace is not

supported

EE and EE-ES: Requires the

Oracle Advanced Security

option

Oracle Advanced

Security

Y N Y Y N N Y Y Y

EE and EE-ES: Extra cost

option

Oracle Database

Vault

Y N Y Y N N Y Y Y

EE and EE-ES: Extra cost

option

Oracle Label

Security

Y N Y Y N N Y Y Y

EE and EE-ES: Extra cost

option

Enterprise User

Security

N N Y Y N Y Y Y Y

EE, EE-ES, BaseDB EE,

BaseDB EE-HP, BaseDB EE-

EP, and ExaCS/CC:

Enterprise User Security is a

feature for directory-based

management of database

users. It requires a

corresponding Oracle Identity

Management Directory

Services Plus to be licensed.

Chapter 1

Permitted Features, Options, and Management Packs by Oracle Database Offering

1-17

Table 1-11 (Cont.) Security

Feature / Option /

Pack

XE SE2 EE EE-

Base

EE-HP

Base

EE-EP

ExaCS/

Notes

Centrally Managed

Users

Y N Y Y N Y Y Y Y

EE, EE-ES, BaseDB EE,

BaseDB EE-HP, BaseDB EE-

EP, and ExaCS/CC: Centrally

Managed Users is a feature for

centrally authenticating and

authorizing database users

with Microsoft Active Directory.

Fine-grained

Auditing

Y N Y Y N Y Y Y Y

Privilege Analysis Y N Y Y N Y Y Y Y

Real Application

Security

Y N Y Y N Y Y Y Y

Redaction Y N Y Y N N Y Y Y

EE and EE-ES: Requires the

Oracle Advanced Security

option

Transparent

Sensitive Data

Protection

Y N Y Y N Y Y Y Y

Virtual Private

Database

Y N Y Y N Y Y Y Y

Keystore for Each

Pluggable Database

N N Y Y N Y Y Y Y

EE and EE-ES: Requires the

Oracle Advanced Security

option

CLOUD: Only available in OCI.

Sharing of TDE

Master Encryption

Key Across Oracle

Processes

N N N N Y Y Y Y Y

CLOUD: Only available in OCI.

Ability to Set the

Default Tablespace

Encryption Algorithm

Y N Y Y N Y Y Y Y

EE and EE-ES: Requires the

Oracle Advanced Security

option

CLOUD: Only available in OCI.

Table 1-12 Snapshots and Cloning

Feature / Option /

Pack

XE SE2 EE EE-

Base

EE-HP

Base

EE-EP

ExaCS/

Notes

Storage Snapshot

Optimization

N N Y Y N/A N/A N/A N/A N/A

EE and EE-ES: Requires the

Oracle Advanced Compression

option

Chapter 1

Permitted Features, Options, and Management Packs by Oracle Database Offering

1-18

Table 1-13 Spatial and Graph Data

Feature / Option /

Pack

XE SE2 EE EE-

Base

EE-HP

Base

EE-EP

ExaCS/

Notes

Oracle Spatial and

Graph

Y Y Y Y Y Y Y Y Y Oracle Spatial and Graph no

longer requires an extra cost

license. See Oracle Database

Insider blog post for more

information.

Property Graph and

RDF Graph

Technologies (RDF/

OWL)

Y Y Y Y Y Y Y Y Y Property Graph and RDF

Graph Technologies (RDF/

OWL) no longer requires an

extra cost license. See Oracle

Database Insider blog post for

more information.

Parallel spatial index

builds

N N Y Y N Y Y Y Y

Partitioned spatial

indexes

Y N Y Y N N Y Y Y

EE and EE-ES: Requires the

Oracle Partitioning option

Table 1-14 VLDB, Data Warehousing, and Business Intelligence

Feature / Option /

Pack

XE SE2 EE EE-

Base

EE-HP

Base

EE-EP

ExaCS/

Notes

Oracle Partitioning Y N Y Y N N Y Y Y

EE and EE-ES: Extra cost

option

Oracle On-Line

Analytical

Processing (OLAP)

N N Y Y N N Y Y Y

EE and EE-ES: Extra cost

option

Oracle Machine

Learning (formerly

Advanced Analytics)

Y Y Y Y Y Y Y Y Y Oracle Machine Learning no

longer requires an extra cost

license. See Oracle Database

Insider blog post for more

information.

Oracle Advanced

Compression

Y N Y Y N N Y Y Y

EE and EE-ES: Extra cost

option

Advanced Index

Compression

Y N Y Y N N Y Y Y

EE and EE-ES: Requires the

Oracle Advanced Compression

option

Prefix Compression

(also called Key

Compression)

Y N Y Y N Y Y Y Y

Hybrid Columnar

Compression

N N Y Y N Y Y Y Y

EE: Requires ZFS, Axiom, or

FS1 storage

Row-Level Locking

for Hybrid Columnar

Compression

N N Y Y N N N N Y

EE: Requires ZFS or FS1

storage, and the Oracle

Advanced Compression option

EE-ES: Requires the Oracle

Advanced Compression option

Chapter 1

Permitted Features, Options, and Management Packs by Oracle Database Offering

1-19

Table 1-14 (Cont.) VLDB, Data Warehousing, and Business Intelligence

Feature / Option /

Pack

XE SE2 EE EE-

Base

EE-HP

Base

EE-EP

ExaCS/

Notes

Exadata Flash

Cache Compression

N N N Y N N N N Y

EE-ES: Available on Exadata

and requires the Oracle

Advanced Compression

option. Not available on Oracle

Database Appliance.

Heat Map N N Y Y N Y Y Y Y

Automatic Data

Optimization

N N Y Y N N Y Y Y

EE and EE-ES: Requires the

Oracle Advanced Compression

option or the Oracle Database

In-Memory option

Basic Table

Compression

Y N Y Y N Y Y Y Y

Deferred Segment

Creation

Y N Y Y N Y Y Y Y

Bitmapped index,

bitmapped join

index, and bitmap

plan conversions

Y N Y Y N Y Y Y Y

Parallel query/DML N N Y Y N Y Y Y Y

Parallel statistics

gathering

N N Y Y N Y Y Y Y

Parallel index build/

scans

N N Y Y N Y Y Y Y

Parallel Data Pump

Export/Import

N N Y Y N Y Y Y Y

In-memory Parallel

Execution

N N Y Y N Y Y Y Y

Parallel Statement

Queuing

N N Y Y N Y Y Y Y

Parallel capture and

apply via XStream

N N Y Y N Y Y Y Y

Transportable

tablespaces,

including cross-

platform and full

transportable export

and import

Y N Y Y N Y Y Y Y Import of transportable

tablespaces is supported from

all offerings that include

Enterprise Edition software

into SE2; this does not include

the use of cross-platform

capabilities.

Summary

management—

Materialized View

Query Rewrite

Y N Y Y N Y Y Y Y

Chapter 1

Permitted Features, Options, and Management Packs by Oracle Database Offering

1-20

1.4 Oracle Database Options and Their Permitted Features

Table 1-15 lists Oracle Database options, the Oracle Database offerings for which each option

is available, and the features that are included with each option. You must be licensed for an

option in order to use any of its features.

Table 1-15 Oracle Database Options and Their Permitted Features

Option Availability Included Features

Oracle Active Data

Guard

Extra cost option: EE,

EE-ES

Included option: PE,

BaseDB EE-EP,

ExaCS/CC

Oracle Active Data Guard includes the following features:

• Physical Standby with Real-time Query

• Fast Incremental Backup on Physical Standby

• Automatic Block Repair

• Active Data Guard Far Sync

• Global Data Services

• Real-Time Cascade

• Application Continuity

• Rolling Upgrade using Active Data Guard

•

Active Data Guard DML Redirection (CLOUD: Active Data Guard

DML Redirection is only available in OCI.)

In an Oracle Data Guard configuration:

• Oracle Active Data Guard must be licensed on any standby

databases with any of the above features in use, as well as the

primary database. If there are additional standby databases in the

Oracle Data Guard configuration that are not using any of the Oracle

Active Data Guard features, those standby databases do not require

an Oracle Active Data Guard license.

Note: For customers who back up standby databases to Zero Data

Loss Recovery Appliance (ZDLRA) and wish to use the Fast

Incremental Backup on Physical Standby or Real-Time Cascade

feature, an Oracle Active Data Guard license is not required. Oracle

Active Data Guard must still be licensed on standby databases, if any

other of the above features are in use.

• The container root (

CDB$Root

) of the standby database may be

opened read-only without requiring an Oracle Active Data Guard

license. An Oracle Active Data Guard license is only required if any

of the pluggable databases in the standby is opened for read.

Chapter 1

Oracle Database Options and Their Permitted Features

1-21

Table 1-15 (Cont.) Oracle Database Options and Their Permitted Features

Option Availability Included Features

Oracle Advanced

Compression

Extra cost option: EE,

EE-ES

Included option: PE,

XE, BaseDB EE-HP,

BaseDB EE-EP,

ExaCS/CC

Oracle Advanced Compression includes the following features:

• Advanced Row Compression

• Advanced LOB Compression

• Advanced LOB Deduplication

• RMAN Backup Compression (

RMAN

DEFAULT

COMPRESS

does not

require the Oracle Advanced Compression option)

• Data Pump Export Data Compression

(

COMPRESSION=METADATA_ONLY

does not require the Oracle

Advanced Compression option)

• Automatic Data Optimization (Not available with XE)

• Data Guard Redo Transport Compression

• Advanced Network Compression

• Optimization for Flashback Time Travel History Tables (Not available

with XE)

• Storage Snapshot Optimization (Not available with XE)

• Online Move Partition (to any compressed format)

• Exadata Flash Cache Compression (This feature can be enabled

only on Exadata storage servers, and all database processors that

access the Exadata storage servers must be licensed for Oracle

Advanced Compression.)

• Advanced Index Compression

• Row-Level Locking for Hybrid Columnar Compression (Requires

Exadata, Supercluster, Oracle Database Appliance, ZFS, or FS1

storage)

Note: The use of Hybrid Columnar Compression without Row-Level

Locking does not require a license for Oracle Advanced

Compression.

Oracle Advanced

Security

Extra cost option: EE,

EE-ES

Included option: PE,

XE, BaseDB EE-HP,

BaseDB EE-EP,

ExaCS/CC

Oracle Advanced Security includes the following features:

• Transparent Data Encryption (TDE) for columns and tablespaces

(including Oracle SecureFiles)

• DataPump Export File encryption

• RMAN backup encryption to disk

• Encrypted Database File System (DBFS)

• Data Redaction of sensitive data returned to applications (Full,

Partial, Regular Expression, and Random techniques)

Oracle Advanced Security includes a restricted use license for certain

Oracle Enterprise Manager features. Refer to Oracle Advanced Security

in "Restricted Use Licenses" for more information.

Note: 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.

Oracle Database In-

Memory

Extra cost option: EE,

EE-ES

Included option: PE,

XE, BaseDB EE-EP,

ExaCS/CC

Oracle Database In-Memory includes the following features:

• In-Memory Column Store

• In-Memory Column Cache on Storage Servers (Requires Exadata or

Supercluster)

• Fault Tolerant In-Memory Column Store (Requires Exadata,

Supercluster, or Infiniband-based Oracle Database Appliance)

• In-Memory Aggregation

• Automatic Data Optimization (Not available with XE)

Chapter 1

Oracle Database Options and Their Permitted Features

1-22

Table 1-15 (Cont.) Oracle Database Options and Their Permitted Features

Option Availability Included Features

Oracle Database Vault

Extra cost option: EE,

EE-ES

Included option: PE,

XE, BaseDB EE-HP,

BaseDB EE-EP,

ExaCS/CC

Oracle Database Vault includes the following features:

• Separation of Duties

• Realms

• Command Rules

• Trusted Paths

In an Oracle Multitenant environment, an Oracle Database Vault license is

required when Oracle Database Vault is enabled in the CDB root,

regardless of whether any PDBs are plugged in to the CDB root. An

Oracle Database Vault license is not required when Oracle Database

Vault is merely installed or configured in the CDB root. The Oracle

Database Vault license applies to the entire CDB; you cannot license

individual PDBs.

When you purchase a license to use Oracle Database Vault on Oracle

Database Enterprise Edition (EE or EE-ES), the licensing metrics for

Oracle Database Vault must match the licensing metrics for Oracle

Database Enterprise Edition.

Oracle Database Vault includes special license rights for Oracle Label

Security. Refer to Oracle Database Vault in "Special License Rights" for

more information.

Oracle Database Vault includes a restricted use license for certain Oracle

Enterprise Manager features. Refer to Oracle Database Vault in

"Restricted Use Licenses" for more information.

Oracle Label Security

Extra cost option: EE,

EE-ES

Included option: PE,

XE, BaseDB EE-HP,

BaseDB EE-EP,

ExaCS/CC

Oracle Label Security includes the following features:

• Label based access control (LBAC)

• Multi-level security (MLS)

• Label factors for Oracle Database Vault (Confidential, Sensitive)

• User label authorizations (Confidential, Sensitive: PII)

• Data labels (Sensitive: PII)

In an Oracle Multitenant environment, an Oracle Label Security license is

required when an Oracle Label Security policy is created in any container.

An Oracle Label Security license is not required when Oracle Label

Security is merely installed or enabled in any container. The Oracle Label

Security license applies to the entire CDB; you cannot license individual

PDBs.

When you purchase a license to use Oracle Label Security on Oracle

Database Enterprise Edition (EE or EE-ES), the licensing metrics for

Oracle Label Security must match the licensing metrics for Oracle

Database Enterprise Edition.

Oracle Label Security includes a restricted use license for certain Oracle

Enterprise Manager features. Refer to Oracle Label Security in

"Restricted Use Licenses" for more information.

Oracle Multitenant

Extra cost option: EE,

EE-ES

Included option: PE,

XE, BaseDB EE-HP,

BaseDB EE-EP,

ExaCS/CC

Oracle Multitenant includes the following features:

•

For EE, PE, and XE, the ability to have up to 252 pluggable

databases per multitenant container database

•

For EE-ES, BaseDB EE-HP, BaseDB EE-EP, and ExaCS/CC, the

ability to have up to 4096 pluggable databases per multitenant

container database

Chapter 1

Oracle Database Options and Their Permitted Features

1-23

Table 1-15 (Cont.) Oracle Database Options and Their Permitted Features

Option Availability Included Features

Oracle On-Line

Analytical Processing

(OLAP)

Extra cost option: EE,

EE-ES

Included option: PE,

BaseDB EE-HP,

BaseDB EE-EP,

ExaCS/CC

Oracle On-Line Analytical Processing (OLAP) 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

Extra cost option: EE,

EE-ES

Included option: PE,

XE, BaseDB EE-HP,

BaseDB EE-EP,

ExaCS/CC

These are some of the features that make use of Oracle Partitioning:

• Table Partitions and Subpartitions

• Global and Local Index Partitions and Subpartitions

• AQ Sharded Queues

•

Zone Maps and Automatic Zone Maps (Available only on EE-ES and

ExaCS/CC; requires Exadata or Supercluster)

Oracle RAC One Node

Extra cost option: EE,

EE-ES

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

• Quality of Service Management

• Application Continuity

• Zero-Downtime Oracle Grid Infrastructure Patching

Oracle Real Application

Clusters (Oracle RAC)

Extra cost option: EE,

EE-ES

Included option:

BaseDB EE-EP,

ExaCS/CC

Oracle Real Application Clusters (Oracle RAC) includes the following

features:

• All of the features included with Oracle RAC One Node

• Real Application Clusters scaling to multiple servers

• Connection Load Balancing

• Fast Connection Failover

• Hot Cluster Failover

Chapter 1

Oracle Database Options and Their Permitted Features

1-24

Table 1-15 (Cont.) Oracle Database Options and Their Permitted Features

Option Availability Included Features

Oracle Real Application

Testing

Extra cost option: EE,

EE-ES

Included option: PE,

BaseDB EE, BaseDB

EE-HP, BaseDB EE-

EP, ExaCS/CC

Oracle Real Application Testing includes the following features:

• Database Replay

• SQL Performance Analyzer (SPA)

• Database Migration Planner

• Database Migration Workbench

Database Replay

• 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.

• Use of Capture and Replay ASH Analytics Reports, Compare Period

ADDM Reports, and Replay Compare Period Reports also requires

an Oracle Diagnostics Pack license.

• An Oracle Real Application Testing license permits you to access

Database Replay functionality through Oracle Enterprise Manager,

as well as through the following database server command-line APIs:

DBMS_WORKLOAD_CAPTURE

package and

DBMS_WORKLOAD_REPLAY

package. The use of the

DBMS_WORKLOAD_REPLAY

COMPARE_PERIOD_REPORT()

function

also requires a license for Oracle Diagnostics Pack.

SQL Performance Analyzer (SPA)

An Oracle Real Application Testing license permits you to access SQL

Performance Analyzer functionality through Oracle Enterprise Manager,

as well as through the following database server command-line API:

DBMS_SQLPA

package, which is part of the Oracle Real Application

Testing option.

Database Migration Planner

• Database Migration Planner was renamed from Database

Consolidation Workbench in Enterprise Manager Cloud Control 13.4.

• Database Migration Planner, introduced in Oracle Enterprise

Manager Cloud Control 13c, provides a data-driven and systematic

approach to consolidation by eliminating guess work and human

errors.

• Use of the consolidation planning feature of Database Migration

Planner requires an Oracle Diagnostics Pack license.

• An Oracle Real Application Testing license permits you to access the

following links on the Database Migration Planner page in Oracle

Enterprise Manager:

– 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:

Chapter 1

Oracle Database Options and Their Permitted Features

1-25

Table 1-15 (Cont.) Oracle Database Options and Their Permitted Features

Option Availability Included Features

– 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-16 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.

Chapter 1

Oracle Management Packs and Their Permitted Features

1-26

Table 1-16 Oracle Management Packs and Their Permitted Features

Management Pack Availability Included Features

Oracle Cloud

Management Pack for

Oracle Database

Extra cost pack: EE,

EE-ES

Included pack:

BaseDB EE-HP,

BaseDB EE-EP,

ExaCS/CC

Features:

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

• 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

Prerequisites:

Oracle Cloud Management Pack for Oracle Database requires Oracle

Database Lifecycle Management Pack for Oracle Database.

Licensed Links:

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

Chapter 1

Oracle Management Packs and Their Permitted Features

1-27

Table 1-16 (Cont.) Oracle Management Packs and Their Permitted Features

Management Pack Availability Included Features

Pluggable Databases. Click Launch, and from Pluggable Database

Creation Options, select Clone an Existing PDB -> Snap Clone.

Licensed APIs:

Use of the following APIs requires a license for Oracle Cloud

Management Pack for Oracle Database:

• Assembly Operations — Any

POST

GET

PUT

DELETE

/em/cloud/

iaas

URI space for Resources Assembly Template and Assembly

Instance

• DBaaS Operations — Any

POST

GET

PUT

DELETE

/em/cloud/

dbaas

URI space

• DBaaS Setup Operations — Any

POST

GET

PUT

DELETE

/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

Chapter 1

Oracle Management Packs and Their Permitted Features

1-28

Table 1-16 (Cont.) Oracle Management Packs and Their Permitted Features

Management Pack Availability Included Features

• 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.

Chapter 1

Oracle Management Packs and Their Permitted Features

1-29

Table 1-16 (Cont.) Oracle Management Packs and Their Permitted Features

Management Pack Availability Included Features

Oracle Data Masking

and Subsetting Pack

Extra cost pack: EE,

EE-ES

Included pack:

BaseDB EE, BaseDB

EE-HP, BaseDB EE-

EP, ExaCS/CC

Features:

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.

Notes:

1. 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.

2. Application Data Modeling was previously called Data Discovery and

Modeling.

Licensed Links:

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:

Chapter 1

Oracle Management Packs and Their Permitted Features

1-30

Table 1-16 (Cont.) Oracle Management Packs and Their Permitted Features

Management Pack Availability Included Features

•

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

Chapter 1

Oracle Management Packs and Their Permitted Features

1-31

Table 1-16 (Cont.) Oracle Management Packs and Their Permitted Features

Management Pack Availability Included Features

Oracle Database

Lifecycle Management

Pack for Oracle

Database

Extra cost pack: EE,

EE-ES

Included pack:

BaseDB EE-HP,

BaseDB EE-EP,

ExaCS/CC

Features:

Oracle Database Lifecycle Management Pack for Oracle Database

includes the following features:

• Client system analyzer

• Compliance Management

• 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

Licensed Parameters:

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

Chapter 1

Oracle Management Packs and Their Permitted Features

1-32

Table 1-16 (Cont.) Oracle Management Packs and Their Permitted Features

Management Pack Availability Included Features

real time into the database alert log under the message group

schema_ddl. The default setting is

FALSE

Licensed Links:

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

Chapter 1

Oracle Management Packs and Their Permitted Features

1-33

Table 1-16 (Cont.) Oracle Management Packs and Their Permitted Features

Management Pack Availability Included Features

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,

Chapter 1

Oracle Management Packs and Their Permitted Features

1-34

Table 1-16 (Cont.) Oracle Management Packs and Their Permitted Features

Management Pack Availability Included Features

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, then Comparison & Drift Management.

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, then Saved. 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:

Chapter 1

Oracle Management Packs and Their Permitted Features

1-35

Table 1-16 (Cont.) Oracle Management Packs and Their Permitted Features

Management Pack Availability Included Features

•

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

Chapter 1

Oracle Management Packs and Their Permitted Features

1-36

Table 1-16 (Cont.) Oracle Management Packs and Their Permitted Features

Management Pack Availability Included Features

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.

Licensed Reports:

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.

Chapter 1

Oracle Management Packs and Their Permitted Features

1-37

Table 1-16 (Cont.) Oracle Management Packs and Their Permitted Features

Management Pack Availability Included Features

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

Chapter 1

Oracle Management Packs and Their Permitted Features

1-38

Table 1-16 (Cont.) Oracle Management Packs and Their Permitted Features

Management Pack Availability Included Features

•

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

Chapter 1

Oracle Management Packs and Their Permitted Features

1-39

Table 1-16 (Cont.) Oracle Management Packs and Their Permitted Features

Management Pack Availability Included Features

•

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

Chapter 1

Oracle Management Packs and Their Permitted Features

1-40

Table 1-16 (Cont.) Oracle Management Packs and Their Permitted Features

Management Pack Availability Included Features

•

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

Chapter 1

Oracle Management Packs and Their Permitted Features

1-41

Table 1-16 (Cont.) Oracle Management Packs and Their Permitted Features

Management Pack Availability Included Features

•

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

Chapter 1

Oracle Management Packs and Their Permitted Features

1-42

Table 1-16 (Cont.) Oracle Management Packs and Their Permitted Features

Management Pack Availability Included Features

•

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

Chapter 1

Oracle Management Packs and Their Permitted Features

1-43

Table 1-16 (Cont.) Oracle Management Packs and Their Permitted Features

Management Pack Availability Included Features

Oracle Diagnostics

Pack

Extra cost pack: EE,

EE-ES

Included pack:

BaseDB EE, BaseDB

EE-HP, BaseDB EE-

EP, ExaCS/CC

Features:

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.

Licensed Links:

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.

Chapter 1

Oracle Management Packs and Their Permitted Features

1-44

Table 1-16 (Cont.) Oracle Management Packs and Their Permitted Features

Management Pack Availability Included Features

– 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';

• 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

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

spawrio

sql

, and

spawrrac

sql

Licensed Repository Views – Monitoring Views:

Chapter 1

Oracle Management Packs and Their Permitted Features

1-45

Table 1-16 (Cont.) Oracle Management Packs and Their Permitted Features

Management Pack Availability Included Features

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.

Chapter 1

Oracle Management Packs and Their Permitted Features

1-46

Table 1-16 (Cont.) Oracle Management Packs and Their Permitted Features

Management Pack Availability Included Features

Oracle Tuning Pack

Extra cost pack: EE,

EE-ES

Included pack:

BaseDB EE, BaseDB

EE-HP, BaseDB EE-

EP, ExaCS/CC

Features:

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.

Prerequisites:

Oracle Tuning Pack requires Oracle Diagnostics Pack.

Licensed Links:

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

Chapter 1

Oracle Management Packs and Their Permitted Features

1-47

Table 1-16 (Cont.) Oracle Management Packs and Their Permitted Features

Management Pack Availability Included Features

•

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-7 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:

1. Use a Web browser to view the My Oracle Support Web site:

https://support.oracle.com

2. Log in to My Oracle Support.

If you are not a My Oracle Support registered user, then click Register and follow the

registration instructions.

3. 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.

Note:

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

understand your license requirements.

Chapter 1

Checking for Feature, Option, and Management Pack Usage

1-48

1.7 Special License Rights

Table 1-17 Special License Rights

Feature / Option Licensing Information

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 Advanced 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.

Chapter 1

Special License Rights

1-49

Table 1-17 (Cont.) Special License Rights

Feature / Option Licensing Information

Oracle Clusterware 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.

Chapter 1

Special License Rights

1-50

Table 1-17 (Cont.) Special License Rights

Feature / Option Licensing Information

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 Oracle9i Database Release

2 or Oracle Database 10g.

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

•

Database Replay: Only the Workload Capture feature is supported, and the

captured workload may only be replayed only on Oracle Database 11g. This

feature can be used only to facilitate upgrades from Oracle 9i Database Release

2 to Oracle Database 11g or higher.

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

•

Database Replay: Only the Workload Capture feature is supported, and the

captured workload may be replayed only on Oracle Database 11g. This feature

can be used only to facilitate upgrades from Oracle Database 10g Release 2 to

Oracle Database 11g.

•

SQL Performance Analyzer: Only the Remote SQL Test Execute and SQL

Capture into SQL Tuning Set features are supported. These features can be used

only to facilitate upgrades from Oracle9i Database Release 2 and Oracle

Database 10g Release 1 to Oracle Database 10g Release 2 or higher. When

upgrading to Oracle Database 10g Release 2 from earlier releases (Oracle 9i

Database or Oracle Database 10g 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.

Chapter 1

Special License Rights

1-51

Table 1-17 (Cont.) Special License Rights

Feature / Option Licensing Information

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

For more information, see Oracle Spatial Developer's Guide and Oracle Spatial and

Graph Property Graph Developer's Guide.

Oracle Wallet 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.

Shard Director 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 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-18 Restricted Use Licenses

Feature / Option Licensing Information

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.

Chapter 1

Restricted Use Licenses

1-52

Table 1-18 (Cont.) Restricted Use Licenses

Feature / Option Licensing Information

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 Oracle APEX, 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.

Chapter 1

Restricted Use Licenses

1-53

Table 1-18 (Cont.) Restricted Use Licenses

Feature / Option Licensing Information

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 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.

Chapter 1

Restricted Use Licenses

1-54

Table 1-18 (Cont.) Restricted Use Licenses

Feature / Option Licensing Information

Oracle Sharding 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.

Transactional Event Queues Restricted use of Oracle Partitioning is allowed on all offerings, free of charge, for the

sole purpose of supporting Transactional Event Queues (TEQ). All other uses of

Oracle Partitioning require a license for the Oracle Partitioning option, where available.

Unified Audit 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.

Chapter 1

Restricted Use Licenses

1-55

Third-Party Notices and/or Licenses

• Third-Party Notices and/or Licenses for Oracle Database

• Third-Party Notices and/or Licenses for Oracle Database Components

• Written Offer for Source Code

2.1 Third-Party Notices and/or Licenses for Oracle Database

2.1.1 Commercial Software Included in Oracle Database

Commercial software products or components distributed in Oracle Database 21c are identified

in the following table along with the applicable licensing information.

Table 2-1 Commercial Software Included in Oracle Database

Provider Component(s) Licensing Information

DataDirect DataDirect Technology The DataDirect component provided with this Oracle Program is

distributed only for use with Oracle Program.

Intel Intel Integrated

Performance Primitives

Redistributables

2020.0.0

For a copy of the license, see Intel Integrated Performance Primitives

Redistributables 2020.0.0 License.

Intel Intel Math Kernel

Library

If developed application is a software development library, then attribution

(as specified in product release notes of Materials) must be in application

documentation or on application website.

RIGHTS RESERVED.

RSA BSAFE Software

(CCME, MES, Crypto

J, Cert J, and SSL J)

4.1.x, 6.1.x, 6.2.x

This product includes code licensed from RSA Data Security.

See Figure 2-1.

Figure 2-1 RSA Secure Logo

2.1.2 Open Source or Other Separately Licensed Software Included in

Oracle Database

Required notices for open source or other separately licensed software products or

components distributed in Oracle Database 21c are identified in the following table along with

2-1

the applicable licensing information. Additional notices and/or licenses may be found in the

included documentation or readme files of the individual third party software.

Table 2-2 Open Source or Other Separately Licensed Software Included in Oracle Database

Provider Component(s) Licensing Information

.NET Foundation

Contributors

.NET Runtime 5.0 For a copy of the license, see .NET Runtime 5.0 License.

.NET Foundation

Contributors

.NET Standard

2.0-200319

The MIT License (MIT)

Permission is hereby granted, free of charge, to any person obtaining a

copy of this software and associated documentation files (the "Software"),

to deal in the Software without restriction, including without limitation the

rights to use, copy, modify, merge, publish, distribute, sublicense, and/or

sell copies of the Software, and to permit persons to whom the Software

is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in

all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF

ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO

THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A

PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT

SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR

ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN

ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,

OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE

OR OTHER DEALINGS IN THE SOFTWARE.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database

2-2

Table 2-2 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Database

Provider Component(s) Licensing Information

Anthony Tuininga cx_Oracle 8.1.0 LICENSE AGREEMENT FOR CX_ORACLE

Redistribution and use in source and binary forms, with or without

modification, are permitted provided that the following conditions are met:

1. Redistributions of source code must retain the above copyright

notice, this list of conditions, and the disclaimer that follows.

2. Redistributions in binary form must reproduce the above copyright

notice, this list of conditions, and the following disclaimer in the

documentation and/or other materials provided with the distribution.

Neither the names of the copyright holders nor the names of any

contributors may be used to endorse or promote products derived

from this software without specific prior written permission.

DISCLAIMER: THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT

HOLDERS AND CONTRIBUTORS *AS IS* AND ANY EXPRESS OR

IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE

IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A

PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE

REGENTS OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,

INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR

CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,

PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF

USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER

CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN

CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE

OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS

SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH

DAMAGE.

Computronix is a registered trademark of Computronix (Canada) Ltd.

Apache

Batik SVG Toolkit 1.14 For a copy of the license, see Batik SVG Toolkit 1.14 License.

Apache Commons CLI 1.4,

1.5.0

Apache Commons CLI

This product includes software developed at

The Apache Software Foundation (http://www.apache.org).

This product is licensed under the Apache 2.0 license. See The Apache

Software License, Version 2.0.

Apache Commons CSV 1.7 Apache Commons CSV

This product includes software developed at

The Apache Software Foundation (http://www.apache.org).

This product is licensed under the Apache 2.0 license. See The Apache

Software License, Version 2.0.

Apache Commons Compress

1.20

For a copy of the license, see Commons Compress 1.20 License.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database

2-3

Table 2-2 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Database

Provider Component(s) Licensing Information

Apache Commons FileUpload

1.4

Apache Commons FileUpload

This product includes software developed at

The Apache Software Foundation (http://www.apache.org/).

This product is licensed under the Apache 2.0 license. See The Apache

Software License, Version 2.0.

Apache Commons IO 2.7 Apache Commons IO

This product includes software developed by

The Apache Software Foundation (http://www.apache.org/).

Apache License

This product is licensed under the Apache 2.0 license. See The Apache

Software License, Version 2.0.

Apache HttpComponents

HttpClient 4.5.13

For a copy of the license, see HttpComponents HttpClient 4.5.13 License.

Apache Log4J 2.13.3 This product is licensed under the Apache 2.0 license. See The Apache

Software License, Version 2.0.

================================

Apache Log4J

This product includes software developed at

The Apache Software Foundation (http://www.apache.org).

ResolverUtil.java

Dumbster SMTP test server

TypeUtil.java

picocli (http://picocli.info)

Apache Lucene 8.5.0 For a copy of the license, see Lucene 8.5.0 License.

Apache Mina SSHD 2.5.1 For a copy of the license, see Mina SSHD 2.5.1 License.

Apache Tomcat 8.5.63 For a copy of the license, see Tomcat 8.5.63 License.

Apache XMLBeans 2.6.0-6 For a copy of the license, see XMLBeans 2.6.0-6 License.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database

2-4

Table 2-2 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Database

Provider Component(s) Licensing Information

Apache XML Graphics

Commons 2.6

This product is licensed under the Apache 2.0 license. See The Apache

Software License, Version 2.0.

Notice File:

Apache XML Graphics Commons

This product includes software developed at

The Apache Software Foundation (http://www.apache.org/).

----------------------------------------------------------------

Fourth Party Dependency

1. commons IO 2.6

commons-logging-1.2.jar

Both are Apache 2 License

Notice File

Apache Jakarta Commons IO

This product includes software developed by

The Apache Software Foundation (http://www.apache.org/).

This product includes software developed by

The Apache Software Foundation (http://www.apache.org/).

Apache Xerces2 Java 2.12.1 For a copy of the license, see Xerces2 Java 2.12.1 License.

Apple Computer Apple MDNS (Bonjour)

544-1

Licensed under the Apache License, Version 2.0 (the "License")

To accommodate license compatibility with the widest possible range of

client code licenses, the shared library code, which is linked at runtime

into the same address space as the client using it, is licensed under the

terms of the "Three-Clause BSD License".

The Linux Name Service Switch code, contributed by National ICT

Australia Ltd (NICTA) is licensed under the terms of the NICTA Public

Software Licence (which is substantially similar to the "Three-Clause BSD

License", with some additional language pertaining to Australian law).

This product is licensed under the Apache 2.0 license. See The Apache

Software License, Version 2.0.

CPAN DBD-Oracle 1.80 For a copy of the license, see DBD-Oracle 1.80 License.

Licensed under the Apache License, Version 2.0 (the "License"); you may

not use this file except in compliance with the License. You may obtain a

copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software

distributed under the License is distributed on an "AS IS" BASIS,

WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either

express or implied. See the License for the specific language governing

permissions and limitations under the License.

Eclipse Foundation EclipseLink 2.7.7 For a copy of the license, see EclipseLink 2.7.7 License.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database

2-5

Table 2-2 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Database

Provider Component(s) Licensing Information

Eclipse Foundation Jakarta Annotations

API 1.3.5

For a copy of the license, see Jakarta Annotations API 1.3.5 License.

Eclipse Foundation Jakarta Bean

Validation API 2.0.2

Jakarta Bean Validation API (jakarta.validation:jakarta.validation-api)

--------------------------------------------

This content is produced and maintained by the Eclipse Jakarta Bean

Validation project.

* Project home: https://projects.eclipse.org/projects/ee4j.bean-validation

## Trademarks

Jakarta Bean Validation is a trademark of the Eclipse Foundation.

## Copyright

All content is the property of the respective authors or their employers. For

more information regarding authorship of content, please consult the

listed source code repository logs.

## Declared Project Licenses

This program and the accompanying materials are made available under

the terms of the Apache License, Version 2.0 which is available at https://

www.apache.org/licenses/LICENSE-2.0.

SPDX-License-Identifier: Apache-2.0

## Source Code

The project maintains the following source code repositories:

* [The API repository](https://github.com/eclipse-ee4j/beanvalidation-api)

--------------------------------------------

This product is licensed under the Apache 2.0 license. See The Apache

Software License, Version 2.0.

--------------------------------------------

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database

2-6

Table 2-2 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Database

Provider Component(s) Licensing Information

Eclipse Foundation Jakarta Dependency

Injection 2.0.0

injection-api 2.0

###############################

# Notices for Eclipse Jakarta Dependency Injection

This content is produced and maintained by the Eclipse Jakarta

Dependency Injection project.

* Project home: https://projects.eclipse.org/projects/cdi.batch

## Trademarks

Jakarta Dependency Injection is a trademark of the Eclipse Foundation.

## Copyright

All content is the property of the respective authors or their employers. For

more information regarding authorship of content, please consult the

listed source code repository logs.

## Declared Project Licenses

This program and the accompanying materials are made available under

the terms of the Apache License, Version 2.0 which is available at https://

www.apache.org/licenses/LICENSE-2.0.

SPDX-License-Identifier: Apache-2.0

## Source Code

The project maintains the following source code repositories:

https://github.com/eclipse-ee4j/injection-api

https://github.com/eclipse-ee4j/injection-spec

https://github.com/eclipse-ee4j/injection-tck

## Third-party Content

This project leverages the following third party content.

None

## Cryptography

None

################################

This product is licensed under the Apache 2.0 license. See The Apache

Software License, Version 2.0.

Eclipse Foundation

Jakarta Json

Processing API

(JSON-P) 1.1.6

For a copy of the license, see JSONP 1.1.6 License.

Eclipse Foundation Jakarta Persistence

API (JPA API) 2.2.3

For a copy of the license, see Jakarta Persistence API (JPA API) 2.2.3

License.

Eclipse Foundation Jakarta Restful Web

Services JAX-RS API

2.1.6

For a copy of the license, see Jakarta Restful Web Services JAX-RS API

2.1.6 License.

Eclipse Foundation jersey-client 2.32 For a copy of the license, see jersey-client 2.32 License.

Eclipse Foundation jersey-common 2.32 For a copy of the license, see jersey-common 2.32 License.

Eclipse Foundation jersey-container-servlet

2.32

For a copy of the license, see jersey-container-servlet 2.32 License.

Eclipse Foundation jersey-container-

servlet-core 2.32

For a copy of the license, see jersey-container-servlet-core 2.32 License.

Eclipse Foundation jersey-entity-filtering

2.32

For a copy of the license, see jersey-entity-filtering 2.32 License.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database

2-7

Table 2-2 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Database

Provider Component(s) Licensing Information

Eclipse Foundation jersey-hk2 2.31 For a copy of the license, see jersey-hk2 2.31 License.

Eclipse Foundation jersey-hk2 2.32 For a copy of the license, see jersey-hk2 2.32 License.

Eclipse Foundation jersey-media-jaxb 2.32 For a copy of the license, see jersey-media-jaxb 2.32 License.

Eclipse Foundation jersey-media-json-

jackson 2.32

For a copy of the license, see jersey-media-json-jackson 2.32 License.

Eclipse Foundation jersey-media-multipart

2.32

For a copy of the license, see jersey-media-multipart 2.32 License.

Eclipse Foundation jersey-server 2.32 For a copy of the license, see jersey-server 2.32 License.

Eclipse Foundation osgi-resource-locator

1.0.3

For a copy of the license, see osgi-resource-locator 1.0.3 License.

Clark Cooper

Permission is hereby granted, free of charge, to any person obtaining a

copy of this software and associated documentation files (the "Software"),

to deal in the Software without restriction, including without limitation the

rights to use, copy, modify, merge, publish, distribute, sublicense, and/or

sell copies of the Software, and to permit persons to whom the Software

is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in

all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF

ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO

THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A

PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT

SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR

ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN

ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,

OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE

OR OTHER DEALINGS IN THE SOFTWARE.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database

2-8

Table 2-2 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Database

Provider Component(s) Licensing Information

Facebook, Inc zstd 1.4.9 Zstandard lib files are dual-licensed under the BSD license and GPLv2.

Headers in source files clarify:

* This source code is licensed under both the BSD-style license (found in

the

* LICENSE file in the root directory of this source tree) and the GPLv2

(found

* in the COPYING file in the root directory of this source tree).

Oracle has elected to receive the materials under the BSD License.

BSD License

For Zstandard software

Redistribution and use in source and binary forms, with or without

modification, are permitted provided that the following conditions are met:

• Redistributions of source code must retain the above copyright

notice, this list of conditions and the following disclaimer.

• Redistributions in binary form must reproduce the above copyright

notice, this list of conditions and the following disclaimer in the

documentation and/or other materials provided with the distribution.

• Neither the name Facebook nor the names of its contributors may be

used to endorse or promote products derived from this software

without specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND

CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED

WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED

WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A

PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE

DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR

CONSEQUENTIAL DAMAGES(INCLUDING, BUT NOT LIMITED TO,

PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF

USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER

CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN

CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE

OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS

SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH

DAMAGE.

FasterXML, LLC

jackson-annotations

2.11.2

Jackson Annotations

LICENSE: Apache 2.0

This product is licensed under the Apache 2.0 license. See The Apache

Software License, Version 2.0.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database

2-9

Table 2-2 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Database

Provider Component(s) Licensing Information

FasterXML, LLC jackson-core 2.11.2 Jackson Core

This copy of Jackson JSON processor streaming parser/generator is

licensed under the Apache (Software) License, version 2.0 ("the

License"). See the License for details about distribution rights, and the

specific rights regarding derivate works.

You may obtain a copy of the License at:

http://www.apache.org/licenses/LICENSE-2.0

NOTICE FILE:

===============

# Jackson JSON processor

Jackson is a high-performance, Free/Open Source JSON processing

library. It was originally written by Tatu Saloranta ([email protected]),

and has been in development since 2007. It is currently developed by a

community of developers, as well as supported commercially by

FasterXML.com.

## Licensing

Jackson core and extension components may licensed under different

licenses. To find the details that apply to this artifact see the

accompanying LICENSE file. For more information, including possible

other licensing options, contact FasterXML.com (http://fasterxml.com).

## Credits

A list of contributors may be found from CREDITS file, which is included in

some artifacts (usually source distributions); but is always available from

the source code management (SCM) system project uses.

===============

From the LICENSE file:

This product is licensed under the Apache 2.0 license. See The Apache

Software License, Version 2.0.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database

2-10

Table 2-2 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Database

Provider Component(s) Licensing Information

FasterXML, LLC jackson-databind

2.11.2

TOP LEVEL COMPONENT NAMES: com.fasterxml.jackson.core:jackson-

databind

----------------------------------------------------------------------

This copy of Jackson JSON processor databind module is licensed under

the Apache (Software) License, version 2.0 ("the License"). See the

License for details about distribution rights, and the specific rights

regarding derivate works.

You may obtain a copy of the License at:

http://www.apache.org/licenses/LICENSE-2.0

NOTICE FILE:

===============

# Jackson JSON processor

Jackson is a high-performance, Free/Open Source JSON processing

library. It was originally written by Tatu Saloranta ([email protected]),

and has been in development since 2007. It is currently developed by a

community of developers, as well as supported commercially by

FasterXML.com.

## Licensing

Jackson core and extension components may be licensed under different

licenses. To find the details that apply to this artifact see the

accompanying LICENSE file. For more information, including possible

other licensing options, contact FasterXML.com (http://fasterxml.com).

## Credits

A list of contributors may be found from CREDITS file, which is included in

some artifacts (usually source distributions); but is always available from

the source code management (SCM) system project uses.

===============

This product is licensed under the Apache 2.0 license. See The Apache

Software License, Version 2.0.

=====End of Apache License 2.0 of top level component=====

FOURTH-PARTY DEPENDENCY

----------------jackson-core 2.11.2 -----------------------

[email protected]

LICENSE: Apache 2.0

-----------------jackson-annotations 2.11.2 -----------------------

[email protected]

LICENSE: Apache 2.0

FasterXML, LLC

jackson-jaxrs-base

2.11.2

For a copy of the license, see jackson-jaxrs-base 2.11.2 License.

FasterXML, LLC jackson-jaxrs-json-

provider 2.11.2

For a copy of the license, see jackson-jaxrs-json-provider 2.11.2 License.

FasterXML, LLC jackson-modules-base

2.11.2

For a copy of the license, see jackson-modules-base 2.11.2 License.

Geonames.org GeoNames Data

2020-08

For a copy of the license, see GeoNames Data 2020-08 License.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database

2-11

Table 2-2 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Database

Provider Component(s) Licensing Information

Gisle Aas IO::String 1.08 For a copy of the license, see IO::String 1.08 License.

GlassFish aopalliance-

repackaged 2.6.1

For a copy of the license, see aopalliance-repackaged 2.6.1 License.

GlassFish hk2 2.6.1 For a copy of the license, see hk2 2.6.1 License.

Google GoogleMaps API Code

Samples

Portions of this code include modifications based on work created and

shared by Google and used according to terms described in the Apache

2.0 license. See https://developers.google.com/maps/documentation/

javascript/examples/.

Google Guava 30.1 For a copy of the license, see Guava 30.1 License.

Google Guice 4.2.3 For a copy of the license, see Guice 4.2.3 License.

Google Protocol Buffers (aka

Google protobuf)

3.13.0

From the LICENSE file in the download packages

Redistribution and use in source and binary forms, with or without

modification, are permitted provided that the following conditions are met:

• Redistributions of source code must retain the above copyright

notice, this list of conditions and the following disclaimer.

• Redistributions in binary form must reproduce the above copyright

notice, this list of conditions and the following disclaimer in the

documentation and/or other materials provided with the distribution.

• Neither the name of Google Inc. nor the names of its contributors

may be used to endorse or promote products derived from this

software without specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND

CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED

WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED

WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A

PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE

DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR

CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,

PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF

USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER

CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN

CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE

OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS

SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH

DAMAGE.

Code generated by the Protocol Buffer compiler is owned by the owner of

the input file used when generating it. This code is not standalone and

requires a support library to be linked with it. This support library is itself

covered by the above license.

Grant McLean

XML::Simple 2.25 For a copy of the license, see XML::Simple 2.25 License.

Infozip zip 3.0 For a copy of the license, see zip 3.0 License.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database

2-12

Table 2-2 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Database

Provider Component(s) Licensing Information

Intel Corporation Storage Performance

Development Kit 21.01

BSD LICENSE

Redistribution and use in source and binary forms, with or without

modification, are permitted provided that the following conditions are met:

• Redistributions of source code must retain the above copyright

notice, this list of conditions and the following disclaimer.

• Redistributions in binary form must reproduce the above copyright

notice, this list of conditions and the following disclaimer in the

documentation and/or other materials provided with the distribution.

• Neither the name of Intel Corporation nor the names of its

contributors may be used to endorse or promote products derived

from this software without specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND

CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED

WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED

WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A

PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE

DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR

CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,

PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF

USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER

CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN

CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE

OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS

SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH

DAMAGE.

JS Foundation and

other contributors

jQuery 3.5.1 For a copy of the license, see jQuery 3.5.1 License.

Jean-loup Gailly and

Mark Adler

Zlib Data Compression

Library 1.2.11

/* zlib.h -- interface of the 'zlib' general purpose compression library

version 1.2.11, January 15th, 2017

This software is provided 'as-is', without any express or implied warranty.

In no event will the authors be held liable for any damages arising from

the use of this software.

Permission is granted to anyone to use this software for any purpose,

including commercial applications, and to alter it and redistribute it freely,

subject to the following restrictions:

1. The origin of this software must not be misrepresented; you must not

claim that you wrote the original software. If you use this software in a

product, an acknowledgment in the product documentation would be

appreciated but is not required.

Altered source versions must be plainly marked as such, and must

not be misrepresented as being the original software.

This notice may not be removed or altered from any source

distribution.

Jean-loup Gailly Mark Adler

[email protected] [email protected]

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database

2-13

Table 2-2 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Database

Provider Component(s) Licensing Information

Julian R Seward bzip2 1.0.8 This program, "bzip2", the associated library "libbzip2", and all

reserved.

Redistribution and use in source and binary forms, with or without

modification, are permitted provided that the following conditions are met:

1. Redistributions of source code must retain the above copyright

notice, this list of conditions and the following disclaimer.

2. The origin of this software must not be misrepresented; you must not

claim that you wrote the original software. If you use this software in a

product, an acknowledgment in the product documentation would be

appreciated but is not required.

Altered source versions must be plainly marked as such, and must

not be misrepresented as being the original software.

The name of the author may not be used to endorse or promote

products derived from this software without specific prior written

permission.

THIS SOFTWARE IS PROVIDED BY THE AUTHOR ''AS IS'' AND ANY

EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT

LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY

AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN

NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY DIRECT,

INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR

CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,

PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF

USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER

CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN

CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE

OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS

SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH

DAMAGE.

Julian Seward, jsew[email protected]

bzip2/libbzip2 version 1.0.8 of 13 July 2019

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database

2-14

Table 2-2 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Database

Provider Component(s) Licensing Information

Kernel.org rdma-core 20.2-1

reserved.

* This software is available to you under a choice of one of

two

* licenses. You may choose to be licensed under the terms

of the GNU

* General Public License (GPL) Version 2, available from the

file

* COPYING in the main directory of this source tree, or the

* OpenIB.org BSD license below:

* Redistribution and use in source and binary forms,

with or

* without modification, are permitted provided that the

following

* conditions are met:

* - Redistributions of source code must retain the above

* copyright notice, this list of conditions and the

following

* disclaimer.

* - Redistributions in binary form must reproduce the

above

* copyright notice, this list of conditions and the

following

* disclaimer in the documentation and/or other

materials

* provided with the distribution.

* THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY

KIND,

* EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE

WARRANTIES OF

* MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND

* NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR

* BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY,

WHETHER IN AN

* ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT

OF OR IN

* CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS

IN THE

* SOFTWARE.

Larry Wall and Clark

Cooper

XML::Parser 2.46 For a copy of the license, see XML::Parser 2.46 License.

Lincoln A. Baxter Sys::SigAction 0.21 For a copy of the license, see Sys::SigAction 0.21 License.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database

2-15

Table 2-2 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Database

Provider Component(s) Licensing Information

Makamaka

Hannyaharamitu

perl-JSON 4.03 A copy of the Standard Version of Perl modules in this product is available

at https://www.oracle.com/downloads/opensource.html or by following the

directions on that page.

This library is free software; you can redistribute it and/or modify it under

the same terms as Perl itself.

----------------------------

Perl is free software; you can redistribute it and/or modify it under the

terms of either:

a) the GNU General Public License as published by the Free Software

Foundation; either version 1, or (at your option) any later version, or

b) the "Artistic License"

Oracle elects to receive the software under the Artistic License.

For a copy of the license, see Artistic License.

Mapbox mapbox-gl-js 1.8.0 For a copy of the license, see mapbox-gl-js 1.8.0 License.

Marijn Haverbeke CodeMirror 5.58.2 MIT License

Permission is hereby granted, free of charge, to any person obtaining a

copy of this software and associated documentation files (the "Software"),

to deal in the Software without restriction, including without limitation the

rights to use, copy, modify, merge, publish, distribute, sublicense, and/or

sell copies of the Software, and to permit persons to whom the Software

is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in

all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF

ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO

THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A

PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT

SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR

ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN

ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,

OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE

OR OTHER DEALINGS IN THE SOFTWARE.

Massachusetts Institute

of Technology

Kerberos 1.18.3 For a copy of the license, see Kerberos 1.18.3 License.

Microsoft Entity Framework

Source Code

20210507

This product is licensed under the Apache 2.0 license. See The Apache

Software License, Version 2.0.

Miklos Szeredi libfuse 2.9.4-1.0.4 For a copy of the license, see libfuse 2.9.4-1.0.4 License.

Ned Konz Archive::Zip 1.68 For a copy of the license, see Archive::Zip 1.68 License.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database

2-16

Table 2-2 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Database

Provider Component(s) Licensing Information

Tuputcyn Permission is hereby granted, free of charge, to any person

obtaining a copy of this software and associated documentation files (the

"Software"), to deal in the Software without restriction, including without

limitation the rights to use, copy, modify, merge, publish, distribute,

sublicense, and/or sell copies of the Software, and to permit persons to

whom the Software is furnished to do so, subject to the following

conditions: The above copyright notice and this permission notice shall be

included in all copies or substantial portions of the Software. THE

SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY

KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE

WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR

PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE

AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM,

DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF

CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN

CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER

DEALINGS IN THE SOFTWARE. Updated: Pako 1.0.10 is Distributed

under MIT AND ZLib licenses Adding copyright notice for ZLIB - /lib/zlib

content http://zlib.net/zlib_license.html /* zlib.h -- interface of the 'zlib'

general purpose compression library version 1.2.11, January 15th, 2017

provided 'as-is', without any express or implied warranty. In no event will

the authors be held liable for any damages arising from the use of this

software. Permission is granted to anyone to use this software for any

purpose, including commercial applications, and to alter it and redistribute

it freely, subject to the following restrictions: 1. The origin of this software

must not be misrepresented; you must not claim that you wrote the

original software. If you use this software in a product, an

acknowledgment in the product documentation would be appreciated but

is not required. 2. Altered source versions must be plainly marked as

such, and must not be misrepresented as being the original software. 3.

This notice may not be removed or altered from any source distribution.

Jean-loup Gailly Mark Adler [email protected] [email protected]

NumPy Developers

NumPy 1.18.1 For a copy of the license, see NumPy 1.18.1 License.

Open Source

Geospatial Foundation

Geospatial Data

Abstraction Library/

OpenGIS Simple

Features Reference

Implementation (GDAL/

OGR) 3.3.0

For a copy of the license, see Geospatial Data Abstraction Library/

OpenGIS Simple Features Reference Implementation (GDAL/OGR) 3.3.0

License.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database

2-17

Table 2-2 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Database

Provider Component(s) Licensing Information

Open Web Application

Security Project

(OWASP)

OWASP Java Encoder

Project 1.2.3

************************************************************

********* Copied from LT Public License & Copyright Notices *********

Redistribution and use in source and binary forms, with or without

modification, are permitted provided that the following conditions are met:

• Redistributions of source code must retain the above copyright

notice, this list of conditions and the following disclaimer.

• Redistributions in binary form must reproduce the above copyright

notice, this list of conditions and the following disclaimer in the

documentation and/or other materials provided with the distribution.

• Neither the name of OWASP nor the names of its contributors may be

used to endorse or promote products derived from this software

without specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND

CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED

WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED

WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A

PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE

DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR

CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,

PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF

USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER

CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN

CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE

OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS

SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH

DAMAGE.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database

2-18

Table 2-2 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Database

Provider Component(s) Licensing Information

OpenBLAS Project OpenBLAS 0.3.10 https://github.com/xianyi/OpenBLAS/blob/develop/LICENSE

Redistribution and use in source and binary forms, with or without

modification, are permitted provided that the following conditions are met:

1. Redistributions of source code must retain the above copyright

notice, this list of conditions and the following disclaimer.

2. Redistributions in binary form must reproduce the above copyright

notice, this list of conditions and the following disclaimer in the

documentation and/or other materials provided with the distribution.

Neither the name of the OpenBLAS project nor the names of its

contributors may be used to endorse or promote products derived

from this software without specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND

CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED

WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED

WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A

PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE

DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR

CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,

PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF

USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER

CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN

CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE

OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS

SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH

DAMAGE.

OpenJPEG

OpenJPEG 2.3.1 For a copy of the license, see OpenJPEG 2.3.1 License.

Oracle JavaScript Extension

Toolkit (JET) 8.3.0

For a copy of the license, see JavaScript Extension Toolkit (JET) 8.3.0

License.

Oracle JavaScript Extension

Toolkit (JET) 10.1.0

For a copy of the license, see JavaScript Extension Toolkit (JET) 10.1.0

License.

Python Software

Foundation

Python 3.9.5 For a copy of the license, see Python 3.9.5 License.

QOS.ch Simple Logging

Facade for Java

(SLF4J) 1.7.30

For a copy of the license, see Simple Logging Facade for Java (SLF4J)

1.7.30 License.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database

2-19

Table 2-2 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Database

Provider Component(s) Licensing Information

Shigeru Chiba Javassist 3.27.0-GA Oracle has elected to receive this code under the terms of the Apache 2.0

license.

The Initial Developer of the Original Code is Shigeru Chiba. Portions

Rights Reserved.

Contributor(s): __Bill Burke, Jason T. Greene______________.

Javassist (JAVA programming ASSISTant) makes Java bytecode

manipulation simple. It is a class library for editing bytecodes in Java; it

enables Java programs to define a new class at runtime and to modify a

class file when the JVM loads it. Unlike other similar bytecode editors,

Javassist provides two levels of API: source level and bytecode level. If

the users use the source- level API, they can edit a class file without

knowledge of the specifications of the Java bytecode. The whole API is

designed with only the vocabulary of the Java language. You can even

specify inserted bytecode in the form of source text; Javassist compiles it

on the fly. On the other hand, the bytecode-level API allows the users to

directly edit a class file as other editors.

This software is distributed under the Mozilla Public License Version 1.1,

the GNU Lesser General Public License Version 2.1 or later, or the

Apache License Version 2.0.

---

This product is licensed under the Apache 2.0 license. See The Apache

Software License, Version 2.0.

Terence Parr

Antlr 3.5.2 For a copy of the license, see Antlr 3.5.2 License.

Terracotta Quartz Job Scheduler

2.3.2

For a copy of the license, see Quartz Job Scheduler 2.3.2 License.

The Perl Foundation perl 5.32.0 For a copy of the license, see perl 5.32.0 License.

Uri Guttman File::Slurp 9999.32 For a copy of the license, see File::Slurp 9999.32 License.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database

2-20

Table 2-2 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Database

Provider Component(s) Licensing Information

Various Open Source

Licensors

reserved.

$COPYRIGHT$

Additional copyrights may follow

$HEADER$

Redistribution and use in source and binary forms, with or without

modification, are permitted provided that the following conditions are met:

• Redistributions of source code must retain the above copyright

notice, this list of conditions and the following disclaimer.

• Redistributions in binary form must reproduce the above copyright

notice, this list of conditions and the following disclaimer listed in this

license in the documentation and/or other materials provided with the

distribution.

• Neither the name of the copyright holders nor the names of its

contributors may be used to endorse or promote products derived

from this software without specific prior written permission.

The copyright holders provide no reassurances that the source code

provided does not infringe any patent, copyright, or any other intellectual

property rights of third parties. The copyright holders disclaim any liability

to any recipient for claims brought against recipient by any third party for

infringement of that parties intellectual property rights.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND

CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED

WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED

WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A

PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE

DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR

CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,

PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF

USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER

CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN

CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE

OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS

SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH

DAMAGE.

W3C

DOM (Dom Level 3

core specification,

Version 1.0)

For a copy of the license, see DOM (Dom Level 3 core specification,

Version 1.0) License.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database

2-21

Table 2-2 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Database

Provider Component(s) Licensing Information

Yann Collet LZ4 1.9.2 LICENSE File

LZ4 Library

Redistribution and use in source and binary forms, with or without

modification, are permitted provided that the following conditions are met:

• Redistributions of source code must retain the above copyright

notice, this list of conditions and the following disclaimer.

• Redistributions in binary form must reproduce the above copyright

notice, this list of conditions and the following disclaimer in the

documentation and/or other materials provided with the distribution.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND

CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED

WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED

WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A

PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE

DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR

CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,

PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF

USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER

CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN

CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE

OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS

SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH

DAMAGE.

--------------------------------------------------

edenhill

librdkafka 1.2.2 For a copy of the license, see librdkafka 1.2.2 License.

perl.org DBI 1.643 For a copy of the license, see DBI 1.643 License.

scipy.org SciPy 1.6.0 For a copy of the license, see SciPy 1.6.0 License.

2.2 Third-Party Notices and/or Licenses for Oracle Database

Components

2.2.1 Open Source or Other Separately Licensed Software Included in

Oracle Database Components

Required notices for open source or other separately licensed software products or

components distributed in Oracle Database 21c components are identified in the following

tables along with the applicable licensing information. Additional notices and/or licenses may

be found in the included documentation or readme files of the individual third party software.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database Components

2-22

Table 2-3 Open Source or Other Separately Licensed Software Included in Oracle Autonomous Health

Framework 20.4

Provider Component(s) Licensing Information

Anthony Tuininga cx_Oracle 7.2.3 LICENSE AGREEMENT FOR CX_ORACLE

Redistribution and use in source and binary forms, with or without

modification, are permitted provided that the following conditions are met:

• Redistributions of source code must retain the above copyright

notice, this list of conditions, and the disclaimer that follows.

• Redistributions in binary form must reproduce the above copyright

notice, this list of conditions, and the following disclaimer in the

documentation and/or other materials provided with the distribution.

• Neither the names of the copyright holders nor the names of any

contributors may be used to endorse or promote products derived

from this software without specific prior written permission.

DISCLAIMER: THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT

HOLDERS AND CONTRIBUTORS *AS IS* AND ANY EXPRESS OR

IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE

IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A

PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE

REGENTS OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,

INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR

CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,

PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF

USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER

CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN

CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE

OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS

SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH

DAMAGE.

Apache

Commons IO

2.6-335808a

Apache Commons IO

This product includes software developed at

The Apache Software Foundation (http://www.apache.org/).

This product is licensed under the Apache 2.0 license. See The Apache

Software License, Version 2.0.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database Components

2-23

Table 2-3 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Autonomous

Health Framework 20.4

Provider Component(s) Licensing Information

Apache Log4J 2.13.3 Apache License

This product is licensed under the Apache 2.0 license. See The Apache

Software License, Version 2.0.

================================

Apache Log4j

This product includes software developed at

The Apache Software Foundation (http://www.apache.org/).

ResolverUtil.java

Dumbster SMTP test server

TypeUtil.java

picocli (http://picocli.info)

Apache Lucene 8.1.1 For a copy of the license, see Lucene 8.1.1 License.

Permission is hereby granted, free of charge, to any person obtaining a

copy of this software and associated documentation files (the "Software"),

to deal in the Software without restriction, including without limitation the

rights to use, copy, modify, merge, publish, distribute, sublicense, and/or

sell copies of the Software, and to permit persons to whom the Software

is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in

all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF

ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO

THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A

PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT

SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR

ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN

ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,

OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE

OR OTHER DEALINGS IN THE SOFTWARE.

FasterXML, LLC jackson-annotations

2.11.3

Jackson Annotations

LICENSE: Apache 2.0

This product is licensed under the Apache 2.0 license. See The Apache

Software License, Version 2.0.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database Components

2-24

Table 2-3 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Autonomous

Health Framework 20.4

Provider Component(s) Licensing Information

FasterXML, LLC jackson-core 2.11.3 Jackson Core

This copy of Jackson JSON processor streaming parser/generator is

licensed under the Apache (Software) License, version 2.0 ("the

License"). See the License for details about distribution rights, and the

specific rights regarding derivate works.

You may obtain a copy of the License at:

http://www.apache.org/licenses/LICENSE-2.0

NOTICE FILE:

===============

# Jackson JSON processor

Jackson is a high-performance, Free/Open Source JSON processing

library. It was originally written by Tatu Saloranta ([email protected]),

and has been in development since 2007. It is currently developed by a

community of developers, as well as supported commercially by

FasterXML.com.

## Licensing

Jackson core and extension components may licensed under different

licenses. To find the details that apply to this artifact see the

accompanying LICENSE file. For more information, including possible

other licensing options, contact FasterXML.com (http://fasterxml.com).

## Credits

A list of contributors may be found from CREDITS file, which is included in

some artifacts (usually source distributions); but is always available from

the source code management (SCM) system project uses.

===============

From the LICENSE file:

This product is licensed under the Apache 2.0 license. See The Apache

Software License, Version 2.0.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database Components

2-25

Table 2-3 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Autonomous

Health Framework 20.4

Provider Component(s) Licensing Information

FasterXML, LLC jackson-databind

2.11.3

TOP LEVEL COMPONENT NAMES: com.fasterxml.jackson.core:jackson-

databind

----------------------------------------------------------------------

This copy of Jackson JSON processor databind module is licensed under

the Apache (Software) License, version 2.0 ("the License"). See the

License for details about distribution rights, and the specific rights

regarding derivate works.

You may obtain a copy of the License at:

http://www.apache.org/licenses/LICENSE-2.0

NOTICE FILE:

===============

# Jackson JSON processor

Jackson is a high-performance, Free/Open Source JSON processing

library. It was originally written by Tatu Saloranta ([email protected]),

and has been in development since 2007.

It is currently developed by a community of developers, as well as

supported commercially by FasterXML.com.

## Licensing

Jackson core and extension components may be licensed under different

licenses. To find the details that apply to this artifact see the

accompanying LICENSE file.

For more information, including possible other licensing options, contact

FasterXML.com (http://fasterxml.com).

## Credits

A list of contributors may be found from CREDITS file, which is included in

some artifacts (usually source distributions); but is always available from

the source code management (SCM) system project uses.

===============

This product is licensed under the Apache 2.0 license. See The Apache

Software License, Version 2.0

======End of Apache License 2.0 of top level component======

FOURTH-PARTY DEPENDENCY

----------------jackson-core 2.11.2 -----------------------

[email protected]

LICENSE: Apache 2.0

-----------------jackson-annotations 2.11.2 -----------------------

[email protected]

LICENSE: Apache 2.0

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database Components

2-26

Table 2-3 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Autonomous

Health Framework 20.4

Provider Component(s) Licensing Information

Giampaolo Rodola psutils 5.7.2 psutil is distributed under BSD license reproduced below.

Redistribution and use in source and binary forms, with or without

modification, are permitted provided that the following conditions are met:

• Redistributions of source code must retain the above copyright

notice, this list of conditions and the following disclaimer.

• Redistributions in binary form must reproduce the above copyright

notice, this list of conditions and the following disclaimer in the

documentation and/or other materials provided with the distribution.

• Neither the name of the psutil authors nor the names of its

contributors may be used to endorse or promote products derived

from this software without specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND

CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED

WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED

WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A

PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE

DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR

CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,

PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF

USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER

CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN

CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE

OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS

SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH

DAMAGE.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database Components

2-27

Table 2-3 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Autonomous

Health Framework 20.4

Provider Component(s) Licensing Information

Noah Spurrier Pexpect 4.8.0 pexpect 4.7.0

ISC LICENSE

This license is approved by the OSI and FSF as GPL-compatible.

http://opensource.org/licenses/isc-license.txt

Permission to use, copy, modify, and/or distribute this software for any

purpose with or without fee is hereby granted, provided that the above

THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR

DISCLAIMS ALL WARRANTIES WITH REGARD TO THIS SOFTWARE

INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY AND

FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY

SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR

ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE,

DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT,

NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR

IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS

SOFTWARE.

**********************

4P Dependencies:

**********************

ptyprocess>=0.5

Ptyprocess is under the ISC license, as code derived from Pexpect.

http://opensource.org/licenses/ISC

PERMISSION TO USE, COPY, MODIFY, AND/OR DISTRIBUTE THIS

SOFTWARE FOR ANY PURPOSE WITH OR WITHOUT FEE IS

HEREBY GRANTED, PROVIDED THAT THE ABOVE COPYRIGHT

NOTICE AND THIS PERMISSION NOTICE APPEAR IN ALL COPIES.

THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR

DISCLAIMS ALL WARRANTIES WITH REGARD TO THIS SOFTWARE

INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY AND

FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY

SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR

ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE,

DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT,

NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR

IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS

SOFTWARE.

NumPy Developers

NumPy 1.18.1 For a copy of the license, see NumPy 1.18.1 License.

Python Software

Foundation

Python 3.8.6 For a copy of the license, see Python 3.8.6 License.

Python Software

Foundation

python-dateutil 2.8.1 For a copy of the license, see python-dateutil 2.8.1 License.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database Components

2-28

Table 2-3 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Autonomous

Health Framework 20.4

Provider Component(s) Licensing Information

Stuart Bishop pytz 2019.3 Main license:

https://github.com/stub42/pytz/blob/master/src/LICENSE.txt

Permission is hereby granted, free of charge, to any person obtaining a

copy of this software and associated documentation files (the "Software"),

to deal in the Software without restriction, including without limitation the

rights to use, copy, modify, merge, publish, distribute, sublicense, and/or

sell copies of the Software, and to permit persons to whom the Software

is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in

all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF

ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO

THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A

PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT

SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR

ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN

ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,

OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE

OR OTHER DEALINGS IN THE SOFTWARE.

---

There is a 2nd license file under the tz folder:

https://github.com/stub42/pytz/blob/master/tz/LICENSE

Unless specified below, all files in the tz code and data (including this

LICENSE file) are in the public domain.

If the files date.c, newstrftime.3, and strftime.c are present, they contain

material derived from BSD and use the BSD 3-clause license.

The PyData

Development Team

Pandas 1.1.3 For a copy of the license, see Pandas 1.1.3 License.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database Components

2-29

Table 2-3 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Autonomous

Health Framework 20.4

Provider Component(s) Licensing Information

joblib Developers joblib 0.17.0 BSD 3-Clause License

Redistribution and use in source and binary forms, with or without

modification, are permitted provided that the following conditions are met:

• Redistributions of source code must retain the above copyright

notice, this list of conditions and the following disclaimer.

• Redistributions in binary form must reproduce the above copyright

notice, this list of conditions and the following disclaimer in the

documentation and/or other materials provided with the distribution.

• Neither the name of the copyright holder nor the names of its

contributors may be used to endorse or promote products derived

from this software without specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND

CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED

WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED

WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A

PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE

DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR

CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,

PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF

USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER

CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN

CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE

OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS

SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH

DAMAGE.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database Components

2-30

Table 2-3 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Autonomous

Health Framework 20.4

Provider Component(s) Licensing Information

scikit-learn developers scikit-learn 0.24.0 New BSD License

Redistribution and use in source and binary forms, with or without

modification, are permitted provided that the following conditions are met:

a. Redistributions of source code must retain the above copyright notice,

this list of conditions and the following disclaimer.

b. Redistributions in binary form must reproduce the above copyright

notice, this list of conditions and the following disclaimer in the

documentation and/or other materials provided with the distribution.

c. Neither the name of the Scikit-learn Developers nor the names of its

contributors may be used to endorse or promote products derived from

this software without specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND

CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED

WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED

WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A

PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE

REGENTS OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,

INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR

CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,

PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF

USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER

CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN

CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE

OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS

SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH

DAMAGE.

scipy.org

SciPy 1.4.1 For a copy of the license, see SciPy 1.4.1 License.

Table 2-4 Open Source or Other Separately Licensed Software Included in Oracle OPatch 12.2

Provider Component(s) Licensing Information

Apache Commons Compress

1.20

For a copy of the license, see Commons Compress 1.20 License.

FasterXML, LLC jackson-annotations

2.12.1

Jackson Annotations

LICENSE: Apache 2.0

This product is licensed under the Apache 2.0 license. See The Apache

Software License, Version 2.0.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database Components

2-31

Table 2-4 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle OPatch 12.2

Provider Component(s) Licensing Information

FasterXML, LLC jackson-core 2.12.1 jackson-core 2.10.2

Notice file : https://github.com/FasterXML/jackson-core/blob/jackson-

core-2.10.2/src/main/resources/META-INF/NOTICE

# Jackson JSON processor

Jackson is a high-performance, Free/Open Source JSON processing

library. It was originally written by Tatu Saloranta ([email protected]),

and has been in development since 2007.

It is currently developed by a community of developers, as well as

supported commercially by FasterXML.com.

## Licensing

Jackson core and extension components may licensed under different

licenses. To find the details that apply to this artifact see the

accompanying LICENSE file. For more information, including possible

other licensing options, contact FasterXML.com (http://fasterxml.com).

## Credits

A list of contributors may be found from CREDITS file, which is included in

some artifacts (usually source distributions); but is always available from

the source code management (SCM) system project uses.

LICENSE: Apache 2.0

This product is licensed under the Apache 2.0 license. See The Apache

Software License, Version 2.0.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database Components

2-32

Table 2-4 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle OPatch 12.2

Provider Component(s) Licensing Information

FasterXML, LLC jackson-databind

2.12.1

TOP LEVEL COMPONENT NAMES: com.fasterxml.jackson.core:jackson-

databind

----------------------------------------------------------------------

This copy of Jackson JSON processor databind module is licensed under

the Apache (Software) License, version 2.0 ("the License"). See the

License for details about distribution rights, and the specific rights

regarding derivate works.

You may obtain a copy of the License at:

http://www.apache.org/licenses/LICENSE-2.0

NOTICE FILE:

===============

# Jackson JSON processor

Jackson is a high-performance, Free/Open Source JSON processing

library. It was originally written by Tatu Saloranta ([email protected]),

and has been in development since 2007.

It is currently developed by a community of developers, as well as

supported commercially by FasterXML.com.

## Licensing

Jackson core and extension components may be licensed under different

licenses. To find the details that apply to this artifact see the

accompanying LICENSE file. For more information, including possible

other licensing options, contact FasterXML.com (http://fasterxml.com).

## Credits

A list of contributors may be found from CREDITS file, which is included in

some artifacts (usually source distributions); but is always available from

the source code management (SCM) system project uses.

===============

This product is licensed under the Apache 2.0 license. See The Apache

Software License, Version 2.0.

======End of Apache License 2.0 of top level component======

FOURTH-PARTY DEPENDENCY

----------------jackson-core -----------------------

[email protected]

LICENSE: Apache 2.0

-----------------jackson-annotations -----------------------

[email protected]

LICENSE: Apache 2.0

FasterXML, LLC

jackson-module-jaxb-

annotations 2.12.1

For a copy of the license, see jackson-module-jaxb-annotations 2.12.1

License.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database Components

2-33

Table 2-5 Open Source or Other Separately Licensed Software Included in Oracle Outside In

Technology 8.5.5

Provider Component(s) Licensing Information

Alexander L. Roshal UnRAR 5.8.4 For a copy of the license, see UnRAR 5.8.4 License.

Expat maintainers Expat 2.2.9 ************************************************************

********* Copied from LT Public License & Copyright Notices *********

Clark Cooper

Permission is hereby granted, free of charge, to any person obtaining a

copy of this software and associated documentation files (the "Software"),

to deal in the Software without restriction, including without limitation the

rights to use, copy, modify, merge, publish, distribute, sublicense, and/or

sell copies of the Software, and to permit persons to whom the Software

is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in

all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF

ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO

THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A

PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT

SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR

ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN

ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,

OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE

OR OTHER DEALINGS IN THE SOFTWARE.

Freetype.org Freetype 2.10.0 For a copy of the license, see Freetype 2.10.0 License.

Chapter 2

Third-Party Notices and/or Licenses for Oracle Database Components

2-34

Table 2-5 (Cont.) Open Source or Other Separately Licensed Software Included in Oracle Outside In

Technology 8.5.5

Provider Component(s) Licensing Information

Google Protocol Buffers (aka

Google protobuf) 2.5.0

New BSD License from http://code.google.com/p/protobuf/