INSTALLATION / UPGRADING

• OVERVIEW OF DATABASE CREATION
• THE ORACLE UNIVERSAL INSTALLER
• PREREQUISE 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

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
• AUTOMATING TNSNAMES.ORA MAINTENANCE

MULTITENANT ROUNDUP

• RENAMING A PLUGGABLE DATABASE
• MOVING A PDB
• BUILDING A UNIFIED PARAMETER QUERY

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
• OTHER INTERESTING CDB VIEWS
• CDB VIEW EXAMPLES
• NEW FUNCTIONS FOR CONTAINERS
• TRIGGERS IN A CDB
• MOVING DATAFILES ONLINE
• RAW PARTITIONS
• DATABASE SMART FLASH CACHE SUPPORT

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

RESOURCE MANAGER FOR CDBS

• RESOURCE MANAGER AND CDBS
  • CDB Resource Plans
  • The Initial Default Directive Attributes For PDBs
  • PDB Resource Plans
  • Background And Administrative Tasks
  • Creating The Resource Plan For The CDB
  • Updating The CDB Resource Plan
  • Adding A New Plan Directive For A PDB
  • Deleting A PDB?s Plan Directive
  • Enabling The CDB Resource Plan
  • Disabling The CDB Resource Plan
  • Deleting The Entire CDB Resource Plan
  • Creating / Modifying PDB Resource Plans
  • Enabling / Disabling PDB Resource Plans
  • Resource Manager Views
  • Enabling Resource Manager In PDBs
  • Using Cloud Control With Resource Manager
• RUNAWAY QUERY MANAGEMENT
• DBMS_SCHEDULER WITH A CDB