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
Ntier company logo

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!