Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Multitenant Administrator’s Guide
-
Part I Multitenant Architecture
-
1
Introduction to the Multitenant Architecture
- 1.1 About the Multitenant Architecture
- 1.2 Benefits of the Multitenant Architecture
- 1.3 Path to Database Consolidation
- 1.4 Multitenant Environment Documentation Roadmap
-
2
Overview of the Multitenant Architecture
- 2.1 Overview of Containers in a CDB
-
2.2
Overview of Commonality in the CDB
- 2.2.1 About Commonality in a CDB
- 2.2.2 Overview of Common and Local Users in a CDB
- 2.2.3 Overview of Common and Local Roles in a CDB
- 2.2.4 Overview of Privilege and Role Grants in a CDB
- 2.2.5 Overview of Common and Local Objects in a CDB
- 2.2.6 Overview of Common Audit Configurations
- 2.2.7 Overview of PDB Lockdown Profiles
- 2.3 Overview of Applications in an Application Container
- 2.4 Overview of Services in a CDB
- 2.5 Overview of Tablespaces and Database Files in a CDB
- 2.6 Overview of Availability in a CDB
- 2.7 Overview of Oracle Resource Manager in a CDB
-
1
Introduction to the Multitenant Architecture
-
Part II Creating and Configuring a Multitenant Environment
- 3 Overview of Configuring and Managing a Multitenant Environment
-
4
Creating and Configuring a CDB
- 4.1 About Creating a CDB
- 4.2 Planning for CDB Creation
-
4.3
Creating a CDB
- 4.3.1 About CDB Creation with DBCA
- 4.3.2 About CDB Creation with SQL Statements
- 4.3.3 Creating a CDB with the CREATE DATABASE Statement
- 4.3.4 Creating a CDB with the CREATE DATABASE Statement: Examples
- 4.4 Configuring EM Express for a CDB
- 4.5 After Creating a CDB
-
Part III Creating and Removing PDBs and Application Containers
- 5 Overview of PDB Creation
- 6 Creating a PDB from Scratch
-
7
Cloning a PDB or Non-CDB
- 7.1 About Cloning a PDB
- 7.2 Cloning a Local PDB
-
7.3
Cloning a Local PDB: Examples
- 7.3.1 Cloning a Local PDB Using No Clauses: Example
- 7.3.2 Cloning a Local PDB Using DBCA: Example
- 7.3.3 Cloning a Local PDB with the PATH_PREFIX Clause: Example
- 7.3.4 Cloning a Local PDB Using the STORAGE Clause: Example
- 7.3.5 Cloning a Local PDB with the NO DATA Clause: Example
- 7.3.6 Creating a Point-in-Time Clone of a PDB Snapshot: Example
- 7.3.7 Creating a Snapshot Copy PDB: Example
- 7.4 Cloning a Remote PDB or Non-CDB
- 7.5 Cloning a Remote PDB or Non-CDB: Examples
- 7.6 After Cloning a PDB
- 7.7 Materializing a Snapshot Copy PDB
- 8 Relocating a PDB
- 9 Plugging In an Unplugged PDB
- 10 Creating a PDB as a Proxy PDB
- 11 Removing a PDB
-
12
Creating and Removing Application Containers and Seeds
- 12.1 Creating and Removing Application Containers
- 12.2 Creating and Removing Application Seeds
- 12.3 Creating an Application PDB
-
Part IV Administering a Multitenant Environment
-
13
Administering a CDB
-
13.1
About CDB Administration
- 13.1.1 About the Current Container
- 13.1.2 About Administrative Tasks in a CDB
- 13.1.3 About Using Manageability Features in a CDB
- 13.1.4 About Managing Tablespaces in a CDB
- 13.1.5 About Managing Database Objects in a CDB
- 13.1.6 About Flashing Back a PDB
- 13.1.7 About Restricting PDB Users for Enhanced Security
- 13.1.8 Overview of Oracle Multitenant with Oracle RAC
- 13.2 Accessing Containers in a CDB
- 13.3 Modifying a CDB at the System Level
-
13.4
Modifying Containers When Connected to the CDB Root
- 13.4.1 About Container Modification When Connected to CDB Root
- 13.4.2 Modifying an Entire CDB Using ALTER DATABASE
- 13.4.3 Setting the Undo Mode in a CDB Using ALTER DATABASE
- 13.4.4 Modifying the CDB Root Using ALTER DATABASE
-
13.4.5
Modifying the Open Mode of One or More PDBs
- 13.4.5.1 About the Open Mode of a PDB
- 13.4.5.2 Modifying the Open Mode of PDBs with ALTER PLUGGABLE DATABASE
- 13.4.5.3 Modifying the Open Mode of PDBs with the SQL*Plus STARTUP Command
- 13.4.5.4 Preserving or Discarding the Open Mode of PDBs When the CDB Restarts
- 13.4.5.5 Starting and Stopping PDBs in Oracle RAC
- 13.5 Executing SQL in Multiple Containers
- 13.6 Shutting Down a CDB Instance
-
13.1
About CDB Administration
- 14 Administering a CDB Fleet
-
15
Administering PDBs
- 15.1 About PDB Administration
- 15.2 Managing Connections to a PDB
- 15.3 Modifying a PDB at the System Level
- 15.4 Modifying a PDB at the Database Level
- 15.5 Starting Up and Shutting Down a PDB
- 16 Administering a PDB Snapshot Carousel
-
17
Administering Application Containers
- 17.1 About Application Container Administration
- 17.2 About Modifying an Application Root
-
17.3
Managing Applications in an Application Container
- 17.3.1 About Managing Applications in an Application Container
- 17.3.2 Installing Applications in an Application Container
- 17.3.3 Upgrading Applications in an Application Container
- 17.3.4 Patching Applications in an Application Container
- 17.3.5 Migrating an Existing Application to an Application Container
- 17.3.6 Synchronizing Applications in an Application PDB
- 17.3.7 Synchronizing an Application Root Replica with a Proxy PDB
- 17.3.8 Setting the Compatibility Version of an Application
- 17.3.9 Performing Bulk Inserts During Application Install, Upgrade, and Patch Operations
- 17.3.10 Uninstalling Applications from an Application Container
- 17.4 Managing Application Common Objects
- 17.5 Issuing DML Statements on Containers in an Application Container
- 17.6 Partitioning by PDB with Container Maps
-
18
Managing Security for a Multitenant Environment
-
18.1
Managing Security for a Multitenant Environment
-
18.1.1
Managing Commonly and Locally Granted Privileges
- 18.1.1.1 How the Oracle Multitenant Option Affects Privileges
- 18.1.1.2 About Commonly and Locally Granted Privileges
- 18.1.1.3 How Commonly Granted System Privileges Work
- 18.1.1.4 How Commonly Granted Object Privileges Work
- 18.1.1.5 Granting or Revoking Privileges to Access a PDB
- 18.1.1.6 Example: Granting a Privilege in a Multitenant Environment
- 18.1.1.7 Enabling Common Users to View CONTAINER_DATA Object Information
-
18.1.2
Managing Common Roles and Local Roles
- 18.1.2.1 About Common Roles and Local Roles
- 18.1.2.2 How Common Roles Work
- 18.1.2.3 How the PUBLIC Role Works in a Multitenant Environment
- 18.1.2.4 Privileges Required to Create, Modify, or Drop a Common Role
- 18.1.2.5 Rules for Creating Common Roles
- 18.1.2.6 Creating a Common Role
- 18.1.2.7 Rules for Creating Local Roles
- 18.1.2.8 Creating a Local Role
- 18.1.2.9 Role Grants and Revokes for Common Users and Local Users
- 18.1.3 Restricting Operations on PDBs Using PDB Lockdown Profiles
-
18.1.1
Managing Commonly and Locally Granted Privileges
- 18.2 Using Application Contexts in a Multitenant Environment
- 18.3 Using Oracle Virtual Private Database in a Multitenant Environment
- 18.4 Using Transport Layer Security in a Multitenant Environment
- 18.5 Oracle Data Redaction in a Multitenant Environment
-
18.6
Auditing in a Multitenant Environment
- 18.6.1 About Auditing in a Multitenant Environment
- 18.6.2 Example: Auditing the DBA Role in a Multitenant Environment
-
18.6.3
Unified Audit Policies or AUDIT Settings in a Multitenant Environment
- 18.6.3.1
- 18.6.3.2 Traditional Auditing in a Multitenant Environment
- 18.6.3.3 Configuring a Local Unified Audit Policy or Common Unified Audit Policy
- 18.6.3.4 Example: Local Unified Audit Policy
- 18.6.3.5 Example: CDB Common Unified Audit Policy
- 18.6.3.6 Example: Application Common Unified Audit Policy
- 18.6.3.7 How Local or Common Audit Policies or Settings Appear in the Audit Trail
- 18.6.4 Fine-Grained Auditing in a Multitenant Environment
-
18.1
Managing Security for a Multitenant Environment
-
19
Monitoring CDBs and PDBs
- 19.1 About CDB and Container Information in Views
- 19.2 Determining Whether a Database Is a CDB
- 19.3 Viewing Information About the Containers in a CDB
- 19.4 Viewing Information About PDBs
- 19.5 Viewing the Open Mode of Each PDB
- 19.6 Querying Container Data Objects
- 19.7 Querying Across Containers with the CONTAINERS Clause
- 19.8 Determining the Current Container ID or Name
- 19.9 Listing the Modifiable Initialization Parameters in PDBs
- 19.10 Viewing the History of PDBs
-
19.11
Viewing Information About Applications in Application Containers
- 19.11.1 Viewing Information About Applications
- 19.11.2 Viewing Information About Application Status
- 19.11.3 Viewing Information About Application Statements
- 19.11.4 Viewing Information About Application Versions
- 19.11.5 Viewing Information About Application Patches
- 19.11.6 Viewing Information About Application Errors
- 19.11.7 Listing the Shared Database Objects in an Application Container
- 19.11.8 Listing the Extended Data-Linked Objects in an Application Container
-
13
Administering a CDB
-
Part V Using Oracle Features in a Multitenant Environment
- 20 Backing Up and Recovering CDBs and PDBs
-
21
Using Oracle Resource Manager for PDBs
- 21.1 Overview of Oracle Resource Manager in a Multitenant Environment
-
21.2
Managing CDB Resource Plans
- 21.2.1 About CDB Resource Plans
- 21.2.2 Creating a CDB Resource Plan for Managing PDBs
- 21.2.3 Creating a CDB Resource Plan for Managing PDBs: Scenario
- 21.2.4 Creating a CDB Resource Plan with PDB Performance Profiles
- 21.2.5 Creating a CDB Resource Plan for PDB Performance Profiles: Scenario
- 21.2.6 Enabling a CDB Resource Plan
-
21.2.7
Modifying a CDB Resource Plan
- 21.2.7.1 Updating a CDB Resource Plan
- 21.2.7.2 Managing CDB Resource Plan Directives for a PDB
- 21.2.7.3 Managing CDB Resource Plan Directives for a PDB Performance Profile
- 21.2.7.4 Updating the Default Directive for PDBs in a CDB Resource Plan
- 21.2.7.5 Updating the Default Directive for Maintenance Tasks in a CDB Resource Plan
- 21.2.7.6 Deleting a CDB Resource Plan
- 21.2.8 Disabling a CDB Resource Plan
- 21.2.9 Viewing Information About Plans and Directives in a CDB
- 21.3 Managing PDB Resource Plans
- 21.4 Monitoring PDBs Managed by Oracle Database Resource Manager
- 22 Using Oracle Scheduler with a CDB
-
23
Using Oracle Database Vault with a CDB
- 23.1 About Oracle Database Vault
- 23.2 How Oracle Database Vault Works in a Multitenant Environment
- 23.3 Manually Installing Oracle Database Vault in a Multitenant Environment
- 23.4 Verifying That Database Vault Is Configured and Enabled
- 23.5 Registering Database Vault with Common Users to Manage the CDB Root
- 23.6 Registering Database Vault Common Users to Manage Specific PDBs
- 23.7 Creating Common Database Vault Accounts for a Plugged in Database Vault PDB
- 23.8 Realms in a Multitenant Environment
- 23.9 Realm Authorizations in a Multitenant Environment
- 23.10 Rule Sets and Rules in a Multitenant Environment
- 23.11 Command Rules in a Multitenant Environment
- 23.12 Oracle Database Vault Policies in a Multitenant Environment
- 23.13 Converting a Standalone Oracle Database to a PDB and Plugging It into a CDB
- 24 Using XStream with a CDB
-
Part VI Administering a Multitenant Environment with Cloud Control
- 25 Logging into a Multitenant Environment in Enterprise Manager
-
26
Creating and Removing PDBs with Cloud Control
- 26.1 Getting Started with Creating and Removing PDBs with Cloud Control
- 26.2 Overview of Creating and Removing PDBs with Cloud Control
- 26.3 Provisioning a PDB with Cloud Control
- 26.4 Removing PDBs with Cloud Control
- 26.5 Viewing PDB Job Details with Cloud Control
- 27 Administering CDBs and PDBs with Cloud Control
- 28 Using Oracle Resource Manager for PDBs with Cloud Control
-
29
Managing Security for a Multitenant Environment in Enterprise Manager
- 29.1 About Managing Security for a Multitenant Environment in Enterprise Manager
-
29.2
Managing Common and Local Users in Enterprise Manager
- 29.2.1 Creating a Common User Account in Enterprise Manager
- 29.2.2 Editing a Common User Account in Enterprise Manager
- 29.2.3 Dropping a Common User Account in Enterprise Manager
- 29.2.4 Creating a Local User Account in Enterprise Manager
- 29.2.5 Editing a Local User Account in Enterprise Manager
- 29.2.6 Dropping a Local User Account in Enterprise Manager
-
29.3
Managing Common and Local Roles and Privileges in Enterprise Manager
- 29.3.1 Creating a Common Role in Enterprise Manager
- 29.3.2 Editing a Common Role in Enterprise Manager
- 29.3.3 Dropping a Common Role in Enterprise Manager
- 29.3.4 Revoking Common Privilege Grants in Enterprise Manager
- 29.3.5 Creating a Local Role in Enterprise Manager
- 29.3.6 Editing a Local Role in Enterprise Manager
- 29.3.7 Dropping a Local Role in Enterprise Manager
- 29.3.8 Revoking Local Privilege Grants in Enterprise Manager
- Glossary
- Index