Advanced
OCP Upgrade to Oracle Database 12c Management
By Tim Boles
Learn the new architecture and management features of the Oracle 12c database. Learn the new Oracle 12c topics that are covered in the Oracle certification upgrade test 1Z0-060.
Course info
Level
Advanced
Updated
Jan 19, 2016
Duration
2h 39m
Table of contents
Examining the Multitenant Container Database
Introduction
3m
Prerequisites
2m
System Baseline
2m
Pre-12c Consolidation Paths
5m
Multitenant Description
3m
Detailed Description of Oracle Multitenant
4m
Demo: Physical Architecture
11m
Summary
2m
Creating CDBs and PDBs
Introduction
2m
Using SQL*Plus to Create a CDB
5m
Demo: Create CDB Using SQL*Plus
3m
Using DBCA to Create a CDB
1m
Demo: Create CDB Using DBCA
2m
Creation of PDB
3m
Demo: Create PDB Using SEED
1m
Clone PDBs
1m
Demo: Create Clone PDB from PDB in CDB
1m
Moving a PDB
1m
Demo: Unplug and Plug
3m
A Migration Strategy
2m
Examining the Management of Local and Common Users
Introduction
2m
Connecting
3m
Demo: Testing Connections
5m
Current Container
1m
Local User
2m
Demo: Testing Local User
2m
Common User
2m
Demo: Testing Common User
2m
Privileges
2m
Roles
3m
Demo: Limiting Common Users
4m
Summary
1m
Managing CDBs and PDBs
Introduction
2m
Connecting to a Container
2m
Demo: Connections and Views
8m
Current Container
1m
Administrative Tasks
3m
PDB States
4m
Instance Parameters for CDB/PDB
3m
Utilizing Enterprise Manager Database Express
Architecture
3m
Installation
1m
Demo: Configure EM Express
8m
Demo: Configuration
4m
Demo: Storage
5m
Demo: Security
3m
Demo: Performance
3m
Summary
1m
Managing Tablespaces in the Multitenant Architecture
Introduction
2m
Where to Look?
3m
What Is Shared?
2m
DEMO: Viewing UNDO
2m
Temporary Tablespace
2m
DEMO: Setting PDB Limits
1m
Summary
1m
Identifying the Benefits of a Multitenant Container Database
Description
Course info
Level
Advanced
Updated
Jan 19, 2016
Duration
2h 39m
Description
Learn the new Oracle 12c topics that are covered in the Oracle certification upgrade test 1Z0-060.
In this course, we will take an in-depth look at the following topics:
- Enterprise Manager and other tools
- The basics of a Multitenant Container Database (CDB)
- Configuring and creating CDBs and PDBs
- Managing CDBs and PDBS
- Managing table-spaces, common and local users, privileges, and roles.
About the author
About the author
As a teenager, Tim found a love for teaching, learning, writing, and computers. He believes that everyone should be a lifelong learner. Tim has been teaching for nearly 21 years, either full or part-time. Tim is an Oracle Database Administrator with over 17 years of experience. He works out of Pittsburgh PA and lives in West Virginia with his wife and kids.
More from the author
More courses by Tim Boles