Oracle Database 12c Manage Multitenant Architecture
StayAhead Training
Summary
- Tutor is available to students
Location & dates
Barbican
LONDON
Greater London
EC1A9HF
United Kingdom
Overview
This Oracle Database 12c Manage Multitenant Architecture course is designed to give Oracle Database Administrators an understanding of Multitenant Architecture in Oracle Database 12c and to give them an appreciation of how Multitenant Architecture may be implemented at their own sites.
The delegate will learn and acquire skills as follows:
- Creating a multitenant container database and pluggable databases
- Managing container and pluggable databases
- Managing storage in container and pluggable databases
- Managing common and local users, privileges and roles
- Managing backup, restore, recovery and flashback operations in a multitenant database
- Implementing Unified Auditing in a multitenant database
- Managing resource allocation in a container database and pluggable database
- Monitoring performance in a container database and pluggable database
- Using Data Pump and SQL*Loader features in a multitenant environment
- Using Auditing in a multitenant environment
Who will the Course Benefit?
This Oracle Database 12c Manage Multitenant Architecture course is designed for Oracle professionals who need to gain an understanding of multitenant architecture, and who need to create and manage a Container and Pluggable databases in Oracle Database 12c.
Course Objectives
This Oracle Database 12c Manage Multitenant Architecture course is designed to give Oracle 12c Database Administrators the knowledge and skills needed to implement multitenant architecture. The Oracle Database 12c administrator will gain practical experience in creating, administering, backing up and recovering and monitoring an Oracle 12c multitenant database.
Examinations
Together with the Oracle Database 12c Backup & Recovery with RMAN course, the Oracle Database 12c Manage Multitenant Architecture course covers the major topics for the Oracle examination 1Z0-063: Oracle Database 12c: Advanced Administration.
Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.
Exams are not included as part of the course.
Description
Course Contents - DAY 1 Course Introduction
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
Session 1: ORACLE CONTAINER AND PLUGGABLE DATABASE ARCHITECTURE
- Overview of Multitenant architecture
- An overview of a Container database (CDB)
- The benefits of Multitenant architecture
- Multitenant database terminology
- 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
Session 2: CONFIGURE AND CREATE A CONTAINER DATABASE AND PLUGGABLE DATABASES
- Tools used to create and manage a CDB and PDBs
- Create and configure a CDB using dbca
- Examine the structure of a CDB using Enterprise Manager, SQL Developer and the CDB_xxx Views
- Administer the database using Enterprise Manager, SQL*Plus and SQL Developer
- Create a new PDB from PDB$SEED
- Create a PDB from a Non-CDB
- Clone a PDB into the same CDB using DB links
- Plug and unplug a PDB
- Drop a PDB
Session 3: MANAGE A CONTAINER DATABASE AND PLUGGABLE DATABASES
- Connect to a CDB as an Administrator
- Connect to a PDB using a service name
- Display the current container
- Switch between containers
- Startup and shutdown a CDB
- Open and close a PDB Using SQL*Plus, SQLDeveloper and EM
- Open and close all PDBs
- Change the state of a PDB
- Preserve or discard the open mode of a PDB on a CDB restart
- Configure CDB and PDB initialisation parameters
Session 4: MANAGE STORAGE IN A CONTAINER DATABASE AND PLUGGABLE DATABASES
- Data storage overview
- Create permanent tablespaces in the root and PDBs
- Create temporary tablespaces in the root and PDBs
- Temporary UNDO
DAY 2 Session 5: MANAGE COMMON AND LOCAL USERS, ROLES AND PRIVILEGES
- Manage common and local schemas and users in the Root and PDBs
- Manage system and object privileges to common and local grantees
- Manage common and local roles
- Manage common and local profiles
- Shared and non-shared objects
Session 6: MANAGE BACKUP, RECOVERY AND FLASHBACK OF A CDB AND PDB
- Backup a CDB
- Backup a PDB
- Container and Pluggable Database Recovery
- Recover a CDB from the loss of redo log files, control files and undo datafile loss
- Recover a CDB from the loss of datafiles
- Use Flashback at CDB Level
- Duplicate PDBs
Session 7: MANAGE PERFORMANCE
- Manage performance
- The SQL Tuning Adviser
- Manage resources between PDBs
- Manage resources within a PDB
- Manage resources with CDB and PDBs plans
- Automated maintenance tasks
- Maximise Consolidated Database Replay
Session 8: MISCELLANEOUS FEATURES
- Use Data Pump with a CDB and PDBs
- Load data into a PDB
- Audit operations
- Schedule jobs with Multitenant architecture
Requirements
- Oracle Database 12c Administration
- Oracle Database 12c Install & Upgrade
Follow-On Courses
- Oracle Database 12c Data Guard
- Oracle Database 12c RAC and Grid Infrastructure Administration
Notes:
- Course technical content is subject to change without notice.
- Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.
Questions and answers
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.