Learn To:

• Understand the multitenant architecture.
• Create and manage a multitenant container database and pluggable databases.
• Manage storage within a multitenant container database and pluggable databases.
• Manage security within a multitenant container database and pluggable databases.
• Monitor performance and manage resources within a multitenant container database and pluggable databases.
• Perform backup, recover and flashback operations on a multitenant container database and pluggable databases.
• Manage the CDB and PDBs in specific configurations like Data Guard, Database Vault.
• Perform particular operations like Oracle Data Pump transportation, loading, encryption, auditing.

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Audience:

• Data Warehouse Administrator
• Database Administrators
• Database Designers
• Support Engineer
• Technical Administrator

Related Training

Required Prerequisites:

• Knowledge of non-CDB configuration and management
• Working knowledge of SQL and use of PL/SQL packages
• Working knowledge of tools like SQL*Plus or Enterprise Manager Cloud Control
• Oracle Database 12c: Administration Workshop
• Oracle Database 12c: Backup and Recovery Workshop

Suggested Prerequisites:

• Basic knowledge of Linux operating system
• Oracle Database 12c: Install and Upgrade Workshop

Course Objectives:

• Manage the multitenant container database and pluggable databases performance
• Configure resource manager to share resources within a multitenant container database between
• containers and within a pluggable database
• Implement unified auditing in a multitenant container database and its pluggable databases
• Use Oracle Data Pump, SQL*Loader in pluggable databases
• Monitor the multitenant container database and pluggable databases
• Describe the multitenant architecture
• Create a multitenant container database
• Create a pluggable database using different method
• Plug a non-CDB into a multitenant container database
• Manage multitenant container databases and pluggable databases
• Administer multitenant container database and pluggable database storage structures
• Manage common and local privileges and ro
• Configure multitenant container databases and pluggable databases backup and recovery operations

Course Topics:

Introduction

• Course Objectives
• Course Schedule
• Tools

Container and Pluggable Database Architecture

• Challenges and Benefits
• Multitenant Architecture
• Provisioning PDBs
• Terminology

CDB and PDB Creation

• Using Tools
• Configuring and Creating a CDB
• Creating PDBs
• Dropping PDBs
• Migrating PDBs

Managing a CDB and PDBs

• Connection
• Managing a CDB and PDBs
• Managing PDBs Open Mode and Settings
• Configuring CDB and PDBs Initialization Parameters

Managing Storage in a CDB and PDBs

• Managing Permanent Tablespaces in CDB and PDBs
• Managing Temporary Tablespaces in CDB and PDBs

Managing Security in a CDB and PDBs

• Managing Common and Local Users
• Managing Common and Local Privileges
• Managing Common and Local Roles
• Understanding Shared and Non-Shared Objects
• Managing Common and Local Profiles

Managing Availability

• Managing Backups
• Managing Recovery Operations
• Managing Flashback Database
• Duplicating PDBs
• Special Situations and Views

Managing Performance

• Managing Performance
• Managing Resource Allocation
• Maximizing Consolidated Database Replay

Miscellaneous

• Exporting and Importing Data
• Loading Data
• Auditing Operations
• Scheduling Jobs
• Using Other Products