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
- About the Multitenant Architecture
- Benefits of the Multitenant Architecture
- Path to Database Consolidation
- Multitenant Environment Documentation Roadmap
-
2
Overview of the Multitenant Architecture
- Overview of Containers in a CDB
-
Overview of Commonality in the CDB
- About Commonality in a CDB
- Overview of Common and Local Users in a CDB
- Overview of Common and Local Roles in a CDB
- Overview of Privilege and Role Grants in a CDB
- Overview of Common and Local Objects in a CDB
- Overview of Common Audit Configurations
- Overview of PDB Lockdown Profiles
- Overview of Applications in an Application Container
- Overview of Services in a CDB
- Overview of Tablespaces and Database Files in a CDB
- Overview of Availability in a CDB
- 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
- About Creating a CDB
-
Planning for CDB Creation
-
Decide How to Configure the CDB
- Plan the PDBs
- Plan the Physical Layout
- Learn How to Manage Initialization Parameters
- Select the Character Set
- Decide Which Time Zones to Support
- Select the Database and Redo Log Block Sizes
- Plan the SYSTEM and SYSAUX Tablespaces
- Plan the Temporary Tablespaces
- Choose the Undo Mode
- Plan the Services for Your Application
- Learn How to Start Up and Shut Down a CDB
- Plan for Oracle RAC
- Prerequisites for CDB Creation
-
Decide How to Configure the CDB
- Creating a CDB
- Configuring EM Express for a CDB
- 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
- About Cloning a PDB or Non-CDB
- Cloning a Local PDB
- Cloning a Remote PDB
- Cloning a Non-CDB
- About Refreshable Clone PDBs
- Cloning PDBs from PDB Snapshots
- Creating and Materializing Snapshot Copy PDBs
- Creating a Split Mirror Clone 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
-
Part IV Administering a Multitenant Environment
-
13
Administering a CDB
-
About CDB Administration
- About the Current Container
- About Administrative Tasks in a CDB
- About Using Manageability Features in a CDB
- About Managing Tablespaces in a CDB
- About Managing Database Objects in a CDB
- About Flashing Back a PDB
- About Restricting PDB Users for Enhanced Security
- Overview of Oracle Multitenant with Oracle RAC
- Accessing Containers in a CDB
- Modifying a CDB at the System Level
- Modifying Containers When Connected to the CDB Root
- Executing SQL in a Different Container
- Shutting Down a CDB Instance
-
About CDB Administration
- 14 Administering a CDB Fleet
-
15
Administering PDBs
- About PDB Administration
- Managing Connections to a PDB
- Modifying a PDB at the System Level
- Modifying a PDB at the Database Level
- Altering the Open Mode of a PDB Using STARTUP and SHUTDOWN
- Starting and Stopping PDBs in Oracle RAC
- 16 Administering a PDB Snapshot Carousel
-
17
Administering Application Containers
- About Application Container Administration
- About Modifying an Application Root
-
Managing Applications in an Application Container
- About Application Management
- Installing Applications in an Application Container
- Upgrading Applications in an Application Container
- Patching Applications in an Application Container
- Migrating an Existing Application to an Application Container
- Synchronizing Applications in an Application PDB
- Synchronizing an Application Root Replica with a Proxy PDB
- Setting the Compatibility Version of an Application
- Performing Bulk Inserts During Application Install, Upgrade, and Patch Operations
- Uninstalling Applications from an Application Container
- Managing Application Common Objects
- Issuing DML Statements on Containers in an Application Container
- Partitioning by PDB with Container Maps
-
18
Managing Security for a Multitenant Environment
-
Managing Commonly and Locally Granted Privileges
- How the Oracle Multitenant Option Affects Privileges
- About Commonly and Locally Granted Privileges
- How Commonly Granted System Privileges Work
- How Commonly Granted Object Privileges Work
- Granting or Revoking Privileges to Access a PDB
- Example: Granting a Privilege in a Multitenant Environment
- Enabling Common Users to View CONTAINER_DATA Object Information
-
Managing Common Roles and Local Roles
- About Common Roles and Local Roles
- How Common Roles Work
- How the PUBLIC Role Works in a Multitenant Environment
- Privileges Required to Create, Modify, or Drop a Common Role
- Rules for Creating Common Roles
- Creating a Common Role
- Rules for Creating Local Roles
- Creating a Local Role
- Role Grants and Revokes for Common Users and Local Users
- Restricting Operations on PDBs Using PDB Lockdown Profiles
- Configuring Operating System Users for a PDB
- Using Application Contexts in a Multitenant Environment
- Using Oracle Virtual Private Database in a Multitenant Environment
- Using Transport Layer Security in a Multitenant Environment
- Oracle Data Redaction in a Multitenant Environment
-
Overview of Auditing in a Multitenant Environment
- Unified Auditing in a Multitenant Environment
- Example: Auditing the DBA Role in a Multitenant Environment
-
Unified Audit Policies or AUDIT Settings in a Multitenant Environment
- About Local, CDB Common, and Application Common Audit Policies
- Traditional Auditing in a Multitenant Environment
- Configuring a Local Unified Audit Policy or Common Unified Audit Policy
- Example: Local Unified Audit Policy
- Example: CDB Common Unified Audit Policy
- Example: Application Common Unified Audit Policy
- How Local or Common Audit Policies or Settings Appear in the Audit Trail
- Fine-Grained Auditing in a Multitenant Environment
-
Managing Commonly and Locally Granted Privileges
-
19
Monitoring CDBs and PDBs
- About CDB and Container Information in Views
- Determining Whether a Database Is a CDB
- Viewing Information About the Containers in a CDB
- Viewing Information About PDBs
- Viewing the Open Mode of Each PDB
- Querying Container Data Objects
- Querying Across Containers with the CONTAINERS Clause
- Determining the Current Container ID or Name
- Listing the Modifiable Initialization Parameters in PDBs
- Viewing the History of PDBs
-
Viewing Information About Applications in Application Containers
- Viewing Information About Applications
- Viewing Information About Application Status
- Viewing Information About Application Statements
- Viewing Information About Application Versions
- Viewing Information About Application Patches
- Viewing Information About Application Errors
- Listing the Shared Database Objects in an Application Container
- 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
- Overview of Oracle Resource Manager in a Multitenant Environment
-
Managing CDB Resource Plans
- About CDB Resource Plans
- Creating a CDB Resource Plan for Managing PDBs
- Creating a CDB Resource Plan for Managing PDBs: Scenario
- Creating a CDB Resource Plan with PDB Performance Profiles
- Creating a CDB Resource Plan for PDB Performance Profiles: Scenario
- Enabling a CDB Resource Plan
-
Modifying a CDB Resource Plan
- Updating a CDB Resource Plan
- Managing CDB Resource Plan Directives for a PDB
- Managing CDB Resource Plan Directives for a PDB Performance Profile
- Updating the Default Directive for PDBs in a CDB Resource Plan
- Updating the Default Directive for Maintenance Tasks in a CDB Resource Plan
- Deleting a CDB Resource Plan
- Disabling a CDB Resource Plan
- Viewing Information About Plans and Directives in a CDB
- Managing PDB Resource Plans
- Monitoring PDBs Managed by Oracle Database Resource Manager
- 23 Using Oracle Scheduler with a CDB
-
24
Using Oracle Database Vault with a CDB
- About Oracle Database Vault
- How Oracle Database Vault Works in a Multitenant Environment
- Verifying That Database Vault Is Configured and Enabled
- Registering Oracle Database Vault with an Oracle Database in a Multitenant Environment
- Configuring Realms
- Rule Sets and Rules in a Multitenant Environment
- Command Rules in a Multitenant Environment
- Oracle Database Vault Policies in a Multitenant Environment
- Using Database Vault Operations Control to Restrict Multitenant Common User Access to Local PDB Data
- Converting a Standalone Oracle Database to a PDB and Plugging It into a CDB
- 25 Using XStream with a CDB
- Glossary
- Index