Oracle 12c Release 1 Multitenant Architecture

Course Number:

N/A

This course provides a comprehensive introduction to the most significant new feature in Oracle history: multitenant architecture.

Audience:

This course is appropriate for end users, business analysts, application developers, database administrators and IT management.
Course Duration:
5 days

Prerequisites:

A thorough knowledge of Oracle11g database administration is required. Familiarity with Oracle11g PL/SQL is highly desirable.

Course Objectives:
Course Outline:
  • Installation / Upgrading
    • Overview of Database Creation
    • The Oracle Universal Installer
    • Prerequisite Tasks
      • Memory Requirements
      • Hardware Requirements
      • Software Requirements
      • Package Requirements
      • What About Windows?
    • Running the Installer
    • Post Installation
    • Using the Database Configuration Assistant
    • Using the Database Configuration Assistant – Short Form
    • Database Templates
    • Upgrading the Database
    • Removing Oracle Software
  • Multitenant Databases
    • The Impact of Multitenant Architecture
    • Major Benefits of Multitenant Architecture
    • The Bird’s Eye View
    • Walking the Directories of A Container Database
    • Who? What? When? Where? How?
    • Impacts of Multitenant Architecture
    • Tools for Use with Multitenant Architecture
      • SQL*Plus
      • DBCA
      • Oracle Enterprise Manager Cloud Control
      • SQL Developer
      • Server Control (SRVCTL)
  • Multitenant Basics
    • Creating CDBS
    • Features Unsupported for Multitenant Architecture
    • The Create Database Command
    • Seed Data Files
    • Configuring Enterprise Manager Database Express for CDBS
    • Using SQL Developer with CDBS as a DBA
  • Intermediate Multitenant
    • Options Available
    • The Create Pluggable Database Statement
      • The STORAGE Clause
      • File Locations Clause
      • Temp File Clause
    • Preparing to Create PDBS
    • Creating PDBS Using the CDB Seed
      • Specifics Using SQL*Plus
    • Cloning an Existing Local PDB
      • Specific Cloning Steps
    • Cloning an Existing Remote PDB
      • Specific Cloning Steps
      • Effects of Cloning a Remote PDB
    • Unplugging a PDB
    • Creating a PDB By Plugging in an Unplugged PDB
    • Creating a PDB From a Non-CDB Database
      • Using DBMS_PDB
    • New Trigger Types For PDBS
      • The BEFORE UNPLUG Trigger
      • The AFTER CLONE Trigger
  • Advanced Multitenant
    • Using Data Pump Export and Import
    • Using EXP and IMP
    • Dropping PDBS
    • Using Cloud Control to Create and Drop PDBS
    • Administration Details
      • Special Roles for CDBs
      • Other Administrative Considerations for CDBs
      • Manageability Considerations
      • Objects in CDBs
      • Services
      • Sessions
      • Common Listeners
      • Connecting to PDBs In MOUNT Mode
      • Login Triggers and The SET CONTAINER Clause
      • Package States and Containers
      • EXECUTE IMMEDIATE and SET CONTAINER
    • Executing Across All Pluggable Databases Using DBMS_SQL
    • Logging Errors for Multiple Containers
    • Alter Database in a CDB
    • Tablespaces in CDBS
    • Using Force On PDBS
    • CLOSE vs. CLOSE IMMEDIATE
    • Specifying PDBS In Alter Pluggable Database
  • Ultimate Multitenant
    • The Startup Command Within PDBS
    • Startup Pluggable Database
    • Shutdown Within PDBS
    • Alter System Set Statements In CDBS
    • The Container Clause in DDL Statements
    • Running Scripts in All Containers
  • Multitenant Roundup
    • Renaming A Pluggable Database
    • Moving A PDB
  • Storage and Security
    • New Super Users
    • Enhanced Security for CDBS
    • Temporary Tablespace Considerations for CDBS
    • Hardening A CDB
    • Storage Clauses Relevant To PDBS
    • Alter System in a PDB
    • SCOPE = SPFILE in PDBs
    • Services and PDBs
    • Views in CDBs
    • CON_ID Details
  • Backup and Recovery for CDBS
    • Container Database Considerations
    • Backup Setup
    • Backing Up the Entire CDB
    • Backing Up Just the Root Container
    • Backing Up PDBS
    • Backing Up Tablespaces and Datafiles From Within a PDB
    • Executing RMAN Across PDBS
    • Redo Log, Archive Log and CONTROLFILE Backups in CDBS
    • Complete Recovery of a CDB
    • Complete Recovery of a PDB
    • Complete Recovery of the Root Container
    • Incomplete Recovery of the Entire CDB
    • Incomplete Recovery Of PDBS
    • Loss of System Tablespace in a PDB
    • RMAN Restrictions In PDBS
    • Prior Backups and ARCHIVELOGS for Converted NON-CDBS
    • Flashback and CDBS
    • Data Pump and CDBS

Related Posts

About Us

IT Training, Agile Ways of Working and High Impact Talent Development Strategies

Let Us Come to You!

Classes recently delivered in: Atlanta, Boston, Chicago, Columbus, Dallas, Detroit, Indianapolis, Jerusalem, London, Milan, New York, Palo Alto, Phoenix, Pittsburgh, Portland, Raleigh, San Antonio, San Diego, San Francisco, San Jose, Seattle, Springfield, Mass., St. Louis, Tampa and more!