Oracle Database 12c: Manage The Multitenant Architecture
Request more details:
The single most important new capability introduced with the Oracle 12c release of the database is the multitenant database feature. With this technology, the Oracle database can be a full participant in a cloud computing-based application architecture. Even a traditional on-premise systems architecture can be dynamically and dramatically transformed as a result of this feature. Many traditional and new database features are enhanced or introduced when a multitenant database configuration is used.
Cost: Price on application
Duration: 2-3 days
This course is not available as part of our public schedule but can be provided on a customised client specific basis.
With regard to this course and its position within the Series For Oracle Administrators these are the required prerequisites, or equivalent experience:
We will devote this course to the following multitenant database topics:
• Understanding the multitenant database architecture.
• Review the business challenges, needs and objectives that are addressed with multitenant database technology.
• Creating and connecting to Oracle container databases (cDBs) and pluggable databases (pDBs).
• Managing common and local users along with multiple container management of security objects.
• Creating container databases, provisioning pluggable databases, perform unplug and plug-in and administering multiple database tenants.
• Migrating traditional single tenant databases to pluggable databases.
• Managing temporary and permanent storage within container and pluggable databases.
• Multitenant backup and recovery strategies, including complete and incomplete recovery at either the container or the pluggable database level, Flashback Database and other sophisticated recovery operations.
• Using SQL, RMAN, DBCA and Enterprise Manager Cloud Control for the administration of multiple database tenants.
• Resource management and container caging
Fundamentals: The Multitenant Database Architecture:
• Cloud Computing Principles
• Peering Into The Architecture
• Multitenant Database Instance
• Multitenant Storage Architecture
• Multitenant Data Dictionary
• Benefits Of The Architecture
• Challenges Of The Architecture
Fundamentals: Creating & Connecting To Multitenant Databases:
• About cDB Capacity Planning
• cDB & pDB Creation
• Using Oracle Installer
• Using DBCA
• cDB & pDB Connections
• Using SQL*Plus
• EM Cloud Control
• Multitenant Security Model
• Multitenant Privileges & Roles
• Common Users
• Local Users
• Common & Local Roles & Privileges
• Commonly & Locally Defined
• Commonly & Locally Granted
• Common & Local Profiles
• Common & Local Dictionary Access
• Multitenant Unified Auditing
• Local Audit Policies
• Querying The Unified Audit Trail
• Common Audit Policies
• Auditing Management With EM CC
Provisioning: Provisioning pDBs From pdb$seed:
• Provision & Decommission pDBs
• EM CC Provisioning Prerequisites
• pDB File Location Prerequisites
• Provision A pDB From pdb$seed
• Provision Using SQL
• Provision Using EM CC
• Post Provisioning Checklist
• Drop A pDB
• Querying cDB & pDB Metadata
Provisioning: Additional pDB Provisioning:
• Clone A pDB
• Unplug & Plug-In A pDB
• Migrate A Non-cDB To A pDB
• pDB Provisioning Using EM CC
• pDB Provisioning Using DBCA