Oracle 18c Container and Pluggable Database Administration

O18CCPA

This Oracle 18c Container and Pluggable Database Administration course is designed to give experienced Oracle 11gR2 Database Administrators practical experience in using the container and pluggable database features that have been introduced in Oracle Database 12c and 18c. Delegates will gain an appreciation of how the Multitenant Architecture features may be implemented at their own sites.

More details

More info

This course is aimed at:

Delegates who wish to attend this Oracle 18c Container and Pluggable Database Administration course should have administration experience of Oracle Database. Knowledge of using PL/SQL packages is strongly recommended.

This course is run on a Linux operating system, therefore a good working knowledge of UNIX/Linux is required.

You will learn:

  • Install the Oracle Database 18c or 12cR2 software with the OUI
  • Create a container and pluggable database with the DBCA
  • Use different methods to create Pluggable databases
  • Configure a CDB and PDBs
  • Create a PDB with Local UNDO
  • Hot Clone a PDB
  • Manage a container and pluggable databases
  • Use new tablespace and management features
  • Manage common and local users, roles and privileges
  • Create and manage Application Containers
  • Plug and unplug a database with a PDB archive file
  • Relocate a PDB to a new container
  • Backup a Container and Pluggable Database
  • Restore, recover and flashback at PDB level
  • Create and manage Application Containers
  • Create and manage and implement security in Application root and Application Container PDBs
  • Manage performance at a PDB level
  • Upgrade an Oracle database to 12.2 or 18c Multitenant Architecture
  • Migrate Data with Data Pump
  • Upgrade multitenant and pluggable databases
  • Implement Unified Auditing New Features
  • Manage resources with Resource Manager performance profiles and memory directives
  • Use the Trace File Analyzer to collect and diagnose issues

Course Content

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: CHANGES TO DATABASE MANAGEMENT TOOLS

  • Enterprise Manager Express Home Page
  • SQL Developer new DBA management functionality
  • Changes to the OUI and the DBCA

Session 2: ORACLE DATABASE MULTITENANT ARCHITECTURE

  • Overview of the Oracle Database architecture
  • An overview of a Container Database (CDB)
  • The benefits of Multitenant Architecture
  • The Root Container and Pluggable Database containers
  • The structure of the Root Container
  • The structure of a Pluggable Database (PDB)
  • CDB_xxx and DBA_xxx Views
  • Plan an installation
  • System requirements and operating system prerequisites
  • Install the Oracle Database 18c oror 12cR2 software with the OUI
  • The Oracle Inventory
  • Silent mode installation
  • Database software de-install
  • Workshop Exercises

Session 3: CREATE A DATABASE WITH THE DATABASE CONFIGURATION ASSISTANT (DBCA)

  • Create a Container and Pluggable databases with the OUI
  • Select a database storage method
  • Select a CDB or non-CDB database
  • Select a database type based on workload
  • Select a character set for the database
  • Set the NLS_LANG initialization parameter
  • Create a database with the DBCA
  • Manual Creation of a CDB
  • Workshop Exercises

Session 4: MANAGE A CONTAINER DATABASE AND PLUGGABLE DATABASES

  • Introduction
  • Connect to a CDB as an administrator
  • Connect to a CDB using a service name
  • Connect to a Pluggable database
  • Display the current container
  • Switch between containers
  • Startup and shutdown a CDB
  • Open and close a PDB
  • Open and close all PDBs
  • Automatic startup of pluggable databases
  • Preserve or discard the PDB open mode after a CDB restart
  • Change the state of a PDB
  • Workshop Exercises

Session 5: NEW TABLESPACE AND MANAGEMENT FEATURES

  • Introduction
  • Data storage overview
  • Create and manage tablespaces in the CDB and PDBs
  • Online rename and Relocation of an active datafile
  • Restrict PGA Size
  • Configure Instance Parameters in a CDB and a PDB
  • Enable and disable temporary undo
  • Query temporary undo information
  • Workshop Exercises

View Course Contents - DAY 2 ...more

Oracle 18c Container and Pluggable Database Administration Training Course

Session 6: MANAGE COMMON AND LOCAL USERS, ROLES AND PRIVILEGES

  • Introduction
  • Overview of common and local user management
  • Create and manage common users
  • Create and manage local users
  • Create common roles
  • Create local roles
  • Grant roles and privileges to common and local users
  • Use the PDB CONTAINERS clause with common and local users
  • Workshop Exercises

Session 7: CONFIGURE A CONTAINER DATABASE AND CREATE AND CLONE PLUGGABLE DATABASES

  • Configure a Container Database
  • Examine the structure of a CDB using CDB_XXX views
  • Administer the database using SQL Developer and EM Express
  • Create a new PDB from PDB$SEED
  • The PDB LOGGING and NOLOGGING clauses
  • Create a Metadata only PDB
  • Clone a PDB subset
  • Create a PDB from a non-CDB
  • Clone a PDB into the same CDB
  • Clone a PDB into the same CDB using database links
  • Clone a remote PDB or non-CDB
  • Plug and unplug a PDB
  • Parallel PDB creation
  • Create a PDB with a default tablespace
  • Use local UNDO mode with a PDB
  • Hot clone a PDB
  • Refresh a read only PDB
  • Plug and unplug a PDB using a PDB archive file
  • Relocate a PDB to a new container
  • Remote proxy PDBs
  • Workshop Exercises

Session 8: AVAILABILITY ENHANCEMENTS

  • The SYSBACKUP privilege
  • Execute SQL statements in RMAN
  • Use the RMAN DESCRIBE Command
  • RMAN syntax enhancements
  • Container and Pluggable Database Backups
  • Backup a Container Database
  • Root Container Backup
  • Backup a Pluggable Database
  • Tablespace and Datafile Backups
  • Container and Pluggable Database Recovery
  • Container Database Complete Recovery
  • Root Container Complete Recovery
  • Pluggable Database Complete Recovery
  • Tablespace and Datafile Complete Recovery
  • Point in Time Recovery
  • Container Database Point in Time Recovery
  • Pluggable Database Point in Time Recovery
  • Table Point in Time Recovery
  • Recover a CDB from the Loss of Redo Logs, Control Files and Undo
  • Use Flashback at CDB Level
  • Restrictions on Point in Time Recovery of Pluggable Database
  • RMAN syntax enhancements
  • Recover a database after missing redo logs found
  • Enhanced table point in time recovery
  • The enhanced REPAIR FAILURE command
  • Enhanced table point in time recovery
  • Create multi-section backups
  • Backup and restore very large files
  • Recover a database after missing redo logs found
  • Reuse preplugin backups before and after a non-CDB conversion as a PDB or a PDB migration to another CDB
  • Clone an active PDB into another CDB using DUPLICATE
  • Workshop Exercises

Session 9: RECOVERY AND FLASHBACK AT PDB LEVEL

  • Shutdown a PDB with critical datafiles missing
  • Flashback a pluggable database at PDB level
  • Create a restore point at CDB and PDB level
  • Create a clean restore point
  • Flashback a PDB in local and shared undo mode

View Course Contents - DAY 3 ...more

Oracle 18c Container and Pluggable Database Administration Training Course

Session 10: APPLICATIONS AND APPLICATION CONTAINERS

  • Application Root and Application Container PDBs
  • Create an Application Container
  • Open an Application Container
  • Create network services
  • Drop an Application Container
  • Manage Applications
  • Install and uninstall an Application
  • Upgrade an Application
  • Drop an Application Container
  • Manage an Application seed
  • Application common objects
  • Application Container views

Session 11: PDB SECURITY

  • Create common and local users in an application
  • Grant common and local privileges in an application
  • Create and grant common and local roles in application containers
  • Use common and local objects and profiles in an application
  • Application common objects
  • Implement Lockdown Policies
  • Assign a lockdown profile to a PDB
  • Lockdown profile inheritance
  • Create and use static and dynamic lockdown profiles
  • Isolate PDB Keystores

Session 12: PDB PERFORMANCE MANAGEMENT

  • Automatic Workload Repository Data at CDB and PDB Level
  • Enable PDB snapshots
  • Disable AWR for a PDB with a Lockdown profile
  • Set SGA and PGA for a PDB
  • Share Resource between PDBs
  • PDB Profile Directives
  • Share Based Instance Caging
  • Limit I/O rates for PDBs
  • Use PDB Resource Plans

Session 13: RESOURCE MANAGER ENHANCEMENTS

  • Memory Resource management for PDBs
  • Manage session PGA limit
  • Control memory usage for PDBs
  • PDB memory parameters
  • Set PDB memory parameters
  • Monitor memory usage for PDBs
  • The SESSION_PGA_LIMIT parameter
  • Limit session PGA with a resource plan
  • Manage session PGA limit

View Course Contents - DAY 4 ...more

Oracle 18c Container and Pluggable Database Administration Training Course

Session 14: SQL TUNING ENHANCEMENTS

  • New default values for OPTIMIZER_ADAPTIVE parameters
  • Adaptive Query optimization enhancements from 12.2
  • The Optimizer Statistics Advisor rules, findings, recommendations and actions
  • The Expression Statistics Store
  • Continuous Adaptive Query plans
  • Enhancements to the SQL Performance Analyzer
  • Enhancements to SQL Plan Management
  • Execution plan capture from AWR
  • Automatic Capture files

Session 15: DIAGNOSABILITY

  • Set an ADR retention target
  • The Retention Advisor
  • The TFA Collector
  • Install the TFA Collector
  • Manage the TFA daemon
  • Start and stop the TFA Collector
  • Dynamic Data Pump tracing

Session 16: PREPARATION FOR UPGRADE

  • Methods used to perform upgrade
  • Methods of data migration
  • Direct upgrade supported releases
  • The Database Upgrade Assistant (dbua)
  • Upgrade process overview
  • Rolling upgrade
  • Create an upgrade test plan
  • Carry out performance testing
  • Run the Pre-Upgrade Information tool
  • Backup the database
  • Install the Oracle Database software
  • Create the new Oracle home

View Course Contents - DAY 5 ...more

Oracle 18c Container and Pluggable Database Administration Training Course

Session 17: UPGRADE TO ORACLE DATABASE

  • Prepare to upgrade a database to 12c or 18c
  • Execute preupgrade.jar
  • Upgrade a database with the Database Upgrade Assistant (DBUA)
  • Upgrade a database manually
  • Post upgrade tasks
  • Plugin an upgraded database as a PDB into a CDB
  • Deprecated database features and parameters

Session 18: POST UPGRADE TASKS

  • Common installation errors
  • Check the /etc/oratab file
  • Check the database version
  • Enterprise Manager Express configuration
  • Carry out post upgrade tasks after a manual upgrade
  • Migrate to unified auditing

Session 19: MIGRATE DATA WITH DATA PUMP

  • Migrate data with Data Pump
  • Transport a database
  • Import data using a Data Pump network link

£ 2,095.00 ex.vat

Data sheet

Course Duration 5 Days
Location London
Examination Not included