The Oracle Database Multitenant Administration Course

Description

Embark on a comprehensive journey through Oracle Multitenant architecture in this course. You will start with an introduction to its key concepts and create a robust Oracle 12c multitenant CDB container on a Linux platform. You will master the art of PDB creation, from establishing them from the seed and cloning them locally or remotely, even exploring the nuances of refreshable PDBs. You will then look at plugging in and relocating PDBs, along with creating them from non-CDB databases and setting up Proxy PDBs. After that, you will create and manage common and local user accounts and roles. Gain expertise in managing PDB lockdown profiles to ensure a secure multitenant container. Master backup and recovery techniques like PITR and database flashback and become adept at using the Resource Manager in multitenant containers. Harness the capabilities of the Data Pump utility with PDBs, and oversee applications, application containers, application PDBs, and common objects. The course covers the latest features in Oracle 18c and 19c. Dive into managing the CDB fleet, navigating a PDB Snapshot Carousel, executing Switch Over actions for Refreshable Clone PDBs, and perfecting PDB cloning and relocation using DBCA. By the end of the course, you will be able to build a reliable, secure, and easy-to-manage Oracle multitenant database.

What You Will Learn

Learn Oracle multitenant architecture and create multitenant CDB
Create a pluggable database using different methods
Create and manage common and local user accounts
Perform backup and recovery along with PITR and flashback
Use Resource Manager in a container database and data pump utility with PDBs
Manage applications, application containers, and PDB lockdown profiles

Audience

This course is tailored for experienced Oracle Database Administrators (DBAs) aiming to enhance their proficiency in effectively managing Oracle Database Multitenant architecture. To get the most out of this course, one needs a foundational understanding of Oracle database administration and proficiency in the Linux operating system.

The other prerequisites are a basic knowledge of the Linux operating system and access to a computer with a minimum configuration of 16 GB RAM, 100 GB HDD, running a 64-bit version of Windows 7, 8, or 10 with Oracle VirtualBox installed.

Approach

This course offers a good blend of theoretical and practical content, ensuring a well-rounded learning experience.

In the concept lectures, you will get comprehensive explanations of the subject, occasionally supported by practical implementation procedures. Each concept lecture is followed by a practice lecture, allowing for hands-on experience in the application of the newly acquired knowledge.

Key Features

Designed for Oracle DBAs eager to dive into the intricacies of managing Oracle database multitenant architecture * Cloud-ready expertise: Acquire the knowledge and practical skills needed to excel in a cloud-based Oracle environment * Stay updated with Oracle 18c and 19c with comprehensive coverage in this multifaceted system

Github Repo

https://github.com/PacktPublishing/The-Oracle-Database-Multitenant-Administration-Course

About the Author

Ahmed Baraka

Ahmed Baraka has 25 years of extensive experience in the computer industry, with a focus on Oracle database administration technologies used in complex and high-availability environments. Baraka's expertise is designing and maintaining database solutions for complex business needs using a wide selection of technologies, such as 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.

Course Outline

1. Introduction

2. Oracle Database Multitenant Architecture

3. Create CBD containers and PDB containers

4. Basic Oracle Multitenant Database Administration

5. Creating PDBs, All the Methods

6. Managing Connectivity and Services in Oracle Multitenant

7. Managing Security in Oracle Multitenant Database

8. Managing Backup, Recovery, and Flashback Database

9. Using Resource Manager in Oracle Multitenant Database

10. Miscellaneous Topics on Oracle Multitenant Database

11. Managing Applications and Application Containers

12. Introduction to Oracle Database Multitenant New Features in 18c and 19c

13. Managing CDB Fleet

14. Managing a PDB Snapshot Carousel

15. Switching Over a Refreshable Clone PDB

16. PDB Cloning and Relocation using DBCA

17. Download Course Slides and Practices