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 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