This hands-on course covers all aspects of the multitenant architecture, providing detailed information on the components of a multitenant container database and its regular pluggable databases. It includes the key new features of 21c and 23c. You learn why and how to create and manage a multitenant container database and its regular pluggable databases. You practice creating, cloning, and plugging in pluggable databases, and converting from non-CDB to the multitenant environment.You learn how to create common and local users; manage encryption, security and audit; monitor and tune performance; perform backup and recovery operations with RMAN. Application and proxy pluggable databases are described but not covered in detail.
An additional workshop (optional, depending on time, interest, and pre-requisite knowledge) is included on configuring Data Guard in a Multitenant environment.
The current release of the database is used for exercises and demonstrations, and the content back-ported as necessary for previous releases.
Technical Requirements
Nothing is required for labs (workshops). SkillBuilders will provide everything you need for all hands-on labs. Modest PC or Mac specs are required to connect to the online class. Detailed specs can be found here.
Also, we strongly recommend using two monitors for this class.
Course Features
- Lectures 0
- Quizzes 0
- Duration 4 Half Days (~16 hours)
- Skill level All levels
- Language English
- Students 42
- Assessments Yes
Multitenant architecture
- Investigate the multitenant architecture
- Describe the container types: root, seed, pluggable
- Understand how Oracle Net establishes sessions
- Query the views that describe the environment
- Describe some features relevant to large deployments
Set up a Multitenant environment
- Create a container database
- Create pluggable containers
- Convert a non-CDB to a pluggable container
- Relocate, unplug, and drop containers
- Hot clones of PDBs and non-CDBs
- Upgrade a CDB
Multitenant administration
- Startup and shutdown a CDB
- Open and close pluggable containers
- Tablespace management
- Create local and common objects
- Understand use of roles and privileges
- Set instance parameters
Backup and recovery
- Backup the CDB and PDBs
- Complete and incomplete restore and recovery
- Database flashback
- Data Guard in a Multitenant environment
Performance
- Resource management
- Memory and IO limits
- Use of the Resource Manager
- Monitoring
- The AWR and Statspack
Security issues
- Audit
- Encryption
- Data Vault
- Some fine-control capabilities
