Oracle Database 12c: Managing Multitenant Architecture
No hands-on lab environment for TOD format.This Oracle Database 12c: Managing Multitenant Architecture training helps you gain a conceptual understanding of the multitenant architecture.
Description
No hands-on lab environment for TOD format.This Oracle Database 12c: Managing Multitenant Architecture training helps you gain a conceptual understanding of the multitenant architecture. You'll practice plugging and unplugging databases in multi-tenant container databases, while learning how to create common and local users and administer database security to meet your business requirements.In this course, you will be introduced to Oracle Database Cloud Service.
What You'll Learn
- 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.
- Gain an understanding of the Oracle Database Cloud Service.
Prerequisites
- Working knowledge of tools like SQL*Plus or Enterprise Manager Cloud Control
- Knowledge of non-CDB configuration and management
- Working knowledge of SQL and use of PL/SQL packages
- Oracle Database 12c: Backup and Recovery Workshop Ed 2
- Basic knowledge of Linux operating system
- Oracle Database 12c R2: Install and Upgrade Workshop
Outline
10 modules
•
2 Days total
- Course Objectives
- Course Schedule
- Tools
- Challenges and Benefits
- Multitenant Architecture
- Provisioning PDBs
- Terminology
- Using Tools
- Configuring and Creating a CDB
- Creating PDBs
- Dropping PDBs
- Migrating PDBs
- Connection
- Managing a CDB and PDBs
- Managing PDBs Open Mode and Settings
- Configuring CDB and PDBs Initialization Parameters
- Managing Permanent Tablespaces in CDB and PDBs
- Managing Temporary Tablespaces in 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 Backups
- Managing Recovery Operations
- Managing Flashback Database
- Duplicating PDBs
- Special Situations and Views
- Managing Performance
- Managing Resource Allocation
- Maximizing Consolidated Database Replay
- Exporting and Importing Data
- Loading Data
- Auditing Operations
- Scheduling Jobs
- Using Other Products
- Database as a Service Architecture, Features and Tooling
- Software Editions: Included Database Options and Management Packs
- Accessing the Oracle Database Cloud Service Console & Automated Database Provisioning
- Managing the Compute Node Associated With a Database Deployment
- Managing Network Access to Database as a Service & Scaling a Database Deployment
- Patching Database as a Service & Using the Oracle Database Cloud Service Console to Manage Patches
- Migrating from On-premises to Oracle Cloud Database
- Gather Information for Migration