Audience
This Oracle database course is aimed at:
- Database administrators
- Application designers and developers
- Web server administrators
- System administrators
- Implementation specialists
- Data centre support engineers
- Chief Information Officers (CIO) and other information technology (IT) management professionals
Prerequisites
This course considers new and advanced capabilities for the Oracle database and therefore has a number of prerequisites in order for one to fully benefit from the material.
It is recommended that delegates first complete the following courses, or have equivalent experience:
Duration
3 days. Hands on.
This course is available on site only. Please call for details.
Course Objectives
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.
This course focuses on the following objectives:
- 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, performing 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
Course Content
Fundamentals
The Multitenant Database Architecture
Creating & Connecting To Multitenant Databases
Multitenant Database Security Management
Provisioning
Provisioning pDBs From pdb$seed
Additional pDB Provisioning
Administration
Administering Multitenant Databases
Multitenant Storage Management
Multitenant Backup & Recovery
Multitenant Resource Management