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.2.1
Decide How to Configure the CDB
- 4.2.1.1 Plan the PDBs
- 4.2.1.2 Plan the Physical Layout
- 4.2.1.3 Learn How to Manage Initialization Parameters
- 4.2.1.4 Select the Character Set
- 4.2.1.5 Decide Which Time Zones to Support
- 4.2.1.6 Select the Database and Redo Log Block Sizes
- 4.2.1.7 Plan the SYSTEM and SYSAUX Tablespaces
- 4.2.1.8 Plan the Temporary Tablespaces
- 4.2.1.9 Choose the Undo Mode
- 4.2.1.10 Plan the Services for Your Application
- 4.2.1.11 Learn How to Start Up and Shut Down a CDB
- 4.2.1.12 Plan for Oracle RAC
- 4.2.2 Prerequisites for CDB Creation
-
4.2.1
Decide How to Configure the CDB
-
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 or Non-CDB
- 7.2 Cloning a Local PDB
- 7.3 Cloning a Remote PDB
- 7.4 Cloning a Non-CDB
- 7.5 About Refreshable Clone PDBs
- 7.6 Cloning PDBs from PDB Snapshots
- 7.7 Creating Snapshot Copy PDBs
- 7.8 Creating a Split Mirror Clone PDBs
- 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 Application Management
- 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 Commonly and Locally Granted Privileges
- 18.1.1 How the Oracle Multitenant Option Affects Privileges
- 18.1.2 About Commonly and Locally Granted Privileges
- 18.1.3 How Commonly Granted System Privileges Work
- 18.1.4 How Commonly Granted Object Privileges Work
- 18.1.5 Granting or Revoking Privileges to Access a PDB
- 18.1.6 Example: Granting a Privilege in a Multitenant Environment
- 18.1.7 Enabling Common Users to View CONTAINER_DATA Object Information
-
18.2
Managing Common Roles and Local Roles
- 18.2.1 About Common Roles and Local Roles
- 18.2.2 How Common Roles Work
- 18.2.3 How the PUBLIC Role Works in a Multitenant Environment
- 18.2.4 Privileges Required to Create, Modify, or Drop a Common Role
- 18.2.5 Rules for Creating Common Roles
- 18.2.6 Creating a Common Role
- 18.2.7 Rules for Creating Local Roles
- 18.2.8 Creating a Local Role
- 18.2.9 Role Grants and Revokes for Common Users and Local Users
- 18.3 Restricting Operations on PDBs Using PDB Lockdown Profiles
- 18.4 Configuring Operating System Users for a PDB
- 18.5 Using Application Contexts in a Multitenant Environment
- 18.6 Using Oracle Virtual Private Database in a Multitenant Environment
- 18.7 Using Transport Layer Security in a Multitenant Environment
- 18.8 Oracle Data Redaction in a Multitenant Environment
-
18.9
Auditing in a Multitenant Environment
- 18.9.1 About Auditing in a Multitenant Environment
- 18.9.2 Example: Auditing the DBA Role in a Multitenant Environment
-
18.9.3
Unified Audit Policies or AUDIT Settings in a Multitenant Environment
- 18.9.3.1 About Local, CDB Common, and Application Common Audit Policies
- 18.9.3.2 Traditional Auditing in a Multitenant Environment
- 18.9.3.3 Configuring a Local Unified Audit Policy or Common Unified Audit Policy
- 18.9.3.4 Example: Local Unified Audit Policy
- 18.9.3.5 Example: CDB Common Unified Audit Policy
- 18.9.3.6 Example: Application Common Unified Audit Policy
- 18.9.3.7 How Local or Common Audit Policies or Settings Appear in the Audit Trail
- 18.9.4 Fine-Grained Auditing in a Multitenant Environment
-
18.1
Managing Commonly and Locally Granted Privileges
-
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 Database Utilities in a Multitenant Environment
-
22
Using Oracle Resource Manager for PDBs
- 22.1 Overview of Oracle Resource Manager in a Multitenant Environment
-
22.2
Managing CDB Resource Plans
- 22.2.1 About CDB Resource Plans
- 22.2.2 Creating a CDB Resource Plan for Managing PDBs
- 22.2.3 Creating a CDB Resource Plan for Managing PDBs: Scenario
- 22.2.4 Creating a CDB Resource Plan with PDB Performance Profiles
- 22.2.5 Creating a CDB Resource Plan for PDB Performance Profiles: Scenario
- 22.2.6 Enabling a CDB Resource Plan
-
22.2.7
Modifying a CDB Resource Plan
- 22.2.7.1 Updating a CDB Resource Plan
- 22.2.7.2 Managing CDB Resource Plan Directives for a PDB
- 22.2.7.3 Managing CDB Resource Plan Directives for a PDB Performance Profile
- 22.2.7.4 Updating the Default Directive for PDBs in a CDB Resource Plan
- 22.2.7.5 Updating the Default Directive for Maintenance Tasks in a CDB Resource Plan
- 22.2.7.6 Deleting a CDB Resource Plan
- 22.2.8 Disabling a CDB Resource Plan
- 22.2.9 Viewing Information About Plans and Directives in a CDB
- 22.3 Managing PDB Resource Plans
- 22.4 Monitoring PDBs Managed by Oracle Database Resource Manager
- 23 Using Oracle Scheduler with a CDB
-
24
Using Oracle Database Vault with a CDB
- 24.1 About Oracle Database Vault
- 24.2 How Oracle Database Vault Works in a Multitenant Environment
- 24.3 Verifying That Database Vault Is Configured and Enabled
-
24.4
Registering Oracle Database Vault with an Oracle Database in a Multitenant Environment
- 24.4.1 Registering Database Vault in the CDB Root
- 24.4.2 Registering Database Vault Common Users to Manage Specific PDBs
- 24.4.3 Registering Database Vault Local Users to Manage Specific PDBs
- 24.4.4 Plugging in a Database Vault-Enabled PDB
- 24.4.5 Manually Installing Oracle Database Vault in a Multitenant Environment
- 24.5 Configuring Realms
- 24.6 Rule Sets and Rules in a Multitenant Environment
- 24.7 Command Rules in a Multitenant Environment
- 24.8 Oracle Database Vault Policies in a Multitenant Environment
- 24.9 Using Database Vault Operations Control to Restrict Multitenant Common User Access to Local PDB Data
- 24.10 Converting a Standalone Oracle Database to a PDB and Plugging It into a CDB
- 25 Using XStream with a CDB
- Glossary
- Index