Oracle Database Multitenant Administration (12c to 19c)
What you'll learn
- Describe the Oracle multitenant architecture
- Create multitenant container database
- Create a pluggable database using different methods
- Create and manage common and local user accounts
- Manage PDB lockdown profiles
- Perform backup and recovery
- Perform PITR and flashback
- Use the Resource Manager in a container database
- Use Data Pump utility with PDBs
- Manage the applications and application containers
- Manage the Oracle 18c and 19c Multitenant New Features
- Oracle Database Administration fundamentals
- Linux operating system basics
- PC with 16 GB, 100 GB HDD, Windows 7,8,or 10 64-bit , Oracle VirtualBox installed in it
Learn how to build and manage Oracle Multitenant Architecture (including releases 12.1, 12.2, 18c, and 19c)
Not only the course will demonstrate the concepts for you, you will also gain practical experience on implementing the them.
Describe the Oracle multitenant architecture
Create multitenant container database
Create a pluggable database using different methods:
Creating a PDB from the seed
Cloning PDBs from local or remote PDBs including the refreshable PDBs
Plugging in an Unplugged PDB
Relocating a PDB
Creating a PDB from a non-CDB database
Creating Proxy PDBs
Manage the security in a multitenant container:
Create and manage common and local user accounts and roles
Manage PDB lockdown profiles
Perform backup and recovery, PITR and flashback database in a multitenant container
Use the Resource Manager in a multitenant container
Use Data Pump utility with PDBs
Manage the applications, application containers, application PDBs, and common objects
Manage Oracle database 18c and 19c multitenant new features:
Manage CDB fleet
Managing a PDB Snapshot Carousel
Switching Over a Refreshable Clone PDB
PDB Cloning and Relocation using DBCA
Content and Overview
Information presented in this course, will get the Oracle Database Administrators ready for the next generation of Oracle database. Through this course of 72 lectures and more than 13 hours of video-based sessions, you’ll learn all of the managing Oracle Multitenant Architecture. After every concepts lecture, you will implement a hands-on practical exercise. To guide you on implementing the practices, the practice lectures are supported by video-based demonstrations and the downloadable guide documents.
Starting with introducing the Oracle Multitenant Architecture, this course will take you all the away from creating an Oracle 12c multitenant CDB container on a Linux platform, creating new PDBs using all the possible methods of creating them, managing the security in a multitenant container, implementing the backup and recovery, flashback database, PITR, using the Resource Manager, applying the auditing policies, using the data pump utility, up to managing the applications, application containers, and common objects. The course will cover the multitenant capabilities in the releases: 12.1, 12.2, 18c, and 19c.
This is an opportunity for the students to gain practical experience on this new Oracle cutting-edge technology, and get themselves ready for managing Oracle databases on the cloud.
Upon completing this course, you will be able to build up an Oracle multitenant container and have the knowledge and experience to manage it.
Join the author in this learning journey to experience this amazing technology!
Who this course is for:
- Oracle Database Adminisrators
Ahmed Baraka has 20 years of extensive experience in the computer industry, with focus on Oracle database administration technologies used in complex and high available environments. Baraka's expertise is designing and maintaining database solutions for complex business needs using a wide selection of technologies, like Oracle RAC, ASM, Data Guard, GoldenGate, WebLogic, Database Appliance, and Enterprise Manager. He has worked with international firms in Australia and Abu Dhabi. His hobbies are soccer (football) and listening to soft music.