Learn how to create and administer multitenant databases
Background
For many Oracle database administrators, the move to Multitenant has appeared to be a daunting task which there has been little reason to undertake. Well, there is no option: in the current release, 21c, the previous non-CDB architecture we all know and love is no longer supported. However, apart from the necessity to convert moving forward, we (in common with many other DBAs) have found that the move is well worth making. Even for a small SE2 shop still running release 12.x, there are benefits to be gained from converting to Multitenant.
Do it now – before you have to.
Course Content
This workshop covers all the essentials of the multitenant architecture, providing detailed information on the components of a multitenant container database and its 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 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 course is presented in two blocks of four hours. These are lectures, demonstrations, and discussion. Exercises in building the environment will be done outside of class, either on the student’s own systems or using Linux environments provided by Skillbuilders. Demonstrations are done on both Linux and Windows.
Course Features
- Lecture 0
- Quiz 0
- Duration 2 Half Days (~8 hours)
- Skill level All levels
- Language English
- Students 2
- 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
