Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Oracle Multitenant Database Administration (DBA)

Learn complete Oracle Multitenant Database Administration. Create CDB and PDBs. Use Resource Manager & Data Pump Utility
2.2
2.2/5
(2 reviews)
31 students
Created by

6.9

CourseMarks Score®

8.2

Freshness

3.8

Feedback

8.1

Content

Platform: Udemy
Video: 7h 23m
Language: English
Next start: On Demand

Table of contents

Description

A warm welcome to the Oracle Multitenant DBA course by Uplatz.

Post Oracle 12c, Oracle came up with new architecture called Multitenant Architecture.
In previous versions of Oracle database versions, there was a major problem – if the user starts a new instance there are particular background processes for each instance and each of these process wasted a lot of memory and resources thus affecting the system performance badly. Hence, Oracle came up with a new idea to connect different databases into one database technique. That idea is called “Multitenant Architecture.”
That one main database is called CDB (Container Database) and other databases which are used to connect the main database are called PDB (Pluggable Database). A pluggable database is fully compatible with a non-CDB. In fact, Oracle has something called the PDB/non-CDB compatibility guarantee, which states that anything you would do in a non-CDB would also work in a PDB. This compatibility guarantee is important when it comes to certifying things like third-party vendor products to work in a multitenant architecture.

How to create a multitenant database environment in Oracle 12c
When creating a database, you must designate it as a CDB or non-CDB for it to be able to support the multitenant architecture. The next set of examples walks you through the steps to create a container database with the DBCA. There is only one step that differentiates a CDB from a non-CDB when using the DBCA.
The multitenant architecture enables you to have many pluggable databases inside a single Oracle Database instance. The Oracle Multitenant Database Architecture is designed to host multiple “PLUGGABLE DATABASE” PDB databases within a single CDB “CONTAINER DATABASE” container instance. The architecture of the CDB instance maintains more PDBs within it, using the same set of processes and the same SGA (System Global Area).

Main components of Multitenant Architecture
1) CDB – Container Database – this is the mother container (main container). Control files and Redo log files are the main files of the CDB.
2) CDB$Root – Root Container – every CDB has one root container (CDB$Root). All Pluggable databases (PDBs) control and manage by root container. All PDBs belong to root container. Root container does not store user data.
3) PDB – Pluggable Database. There can be connect one or more PDBs to the container database. This is a separate database that creates by a user or creates for a user to store particular data. We can store data in PDBs that can support particular applications.
4. PDB$SEED – Seed Container. This is a system-supplied template that is used to create new PDBs. We cannot add or modify objects in Seed Container (PDB$SEED).

Benefits of Multitenant Architecture
•Can combine many databases at once
•Patches and upgrades can apply easily to CDB
•PDBs can unplug from one CDB and can connect to another CDB
•Can manage many databases at once

The Multitenant architecture facilitates the following:
•High consolidation density: Many databases can share memory and background processes.
•Provisioning: A database can be unplugged from one environment and plugged into another or cloned with SQL commands in just a few seconds. They can even be plugged across operating systems and chipsets.
•Patching and upgrades: You can patch a database simply by unplugging from one unpatched container and plugging it into another patched container.
•Manage many databases concurrently: You can do tasks such as backing up and patching on the primary container database instead of the individual pluggable databases.
•Resource management: The Oracle Resource Manager feature can work at the pluggable database level for you to manage resource competition among the databases in your environment.

This Oracle Multitenant DBA course by Uplatz will help you learn the multitenant architecture and the different types of pluggable databases (PDBs) in multitenant container databases (CDBs). You will understand the process of installing Oracle Database 19c followed by the creation of CDB and non-CDB databases. Oracle Database 19c Multitenant Architecture course explores the multitenant architecture and the different types of pluggable databases (PDBs) in multitenant container databases (CDBs). In this Oracle Multitenant Database Administration course, you will be creating a PDB through different methods, managing users, understanding the back-up and recovery processes in CDB and PDBs. You will also gain knowledge of the various utilities used for e.g. resource manager, data pump utility, and so on. Overall, you’ll become a professional Oracle Multitenant DBA with end-to-end skills on managing applications and application containers.

Oracle Multitenant DBA – Course Syllabus

•Overview of Oracle Multitenant DBA
•Installing Oracle Linux 7.8 in Oracle Virtual Box
•Installing Oracle Database 19c Software
•Creating CDB and non-CDB databases
•Creating PDBs from the Seed
•Performing Basic CDB Administration Tasks
•Creating a PDB by Cloning from Local and Remote PDBs
•Creating PDB by Plugging in an Unplugged PDB
•Creating a PDB from non-CDB
•Creating a PDB by Relocating a PDB
•Managing Common and Local Users
•Backup and Recovery in CDB and PDBs
•Flashback and Point-in-time Recovery
•Using Resource Manager with CDB and PDBs
•Using Data Pump Utility with PDBs
•Managing Applications and Application Containers

You will learn

✓ End-to-end knowledge of Oracle Multitenant Database Administration
✓ Become a top Oracle DBA
✓ Learn Oracle Multitenant Database Administration & Management
✓ Manage Oracle Database Multitenant Architecture
✓ Overview of Oracle Multitenant DBA
✓ Installing Oracle Linux 7.8 in Oracle Virtual Box
✓ Installing Oracle Database 19c Software
✓ Creating CDB and non-CDB databases
✓ Creating PDBs from the Seed
✓ Performing Basic CDB Administration Tasks
✓ Creating a PDB by Cloning from Local and Remote PDBs
✓ Creating PDB by Plugging in an Unplugged PDB
✓ Creating a PDB from non-CDB
✓ Creating a PDB by Relocating a PDB
✓ Managing Common and Local Users
✓ Backup and Recovery in CDB and PDBs
✓ Flashback and Point-in-time Recovery
✓ Using Resource Manager with CDB and PDBs
✓ Using Data Pump Utility with PDBs
✓ Managing Applications and Application Containers

Requirements

• Enthusiasm and determination to make your mark on the world!

This course is for

• Oracle Database Administrators (DBAs) and Senior DBAs
• Oracle Database Consultants
• Individuals aspiring for a career in Oracle Database Administration
• Database Security Analysts
• Application Developers
• Database Architects and Technical Architects
• Lead Developers
• Solution Architects
• Oracle Cloud Administrators
• System & Database Analysts
• Anyone interested in learning Oracle Multitenant Database Management
• ETL Developers
• Oracle Database Tuning Specialists
Fastest growing Global IT Training Provider
Uplatz is UK-based leading IT Training provider serving students across the globe. Our uniqueness comes from the fact that we provide online training courses at a fraction of the average cost of these courses in the market.
Over a short span of 3 years, Uplatz has grown massively to become a truly global IT training provider with a wide range of career-oriented courses on cutting-edge technologies and software programming.
Our specialization includes Data Science, Data Engineering, SAP, Oracle, Salesforce, AWS, Microsoft Azure, Google Cloud, IBM Cloud, SAS, Python, R, JavaScript, Java, Full Stack Web Development, Mobile App Development, BI & Visualization, Tableau, Power BI, Spotfire, Data warehousing, ETL tools, Informatica, IBM Data Stage, Digital Marketing, Agile, DevOps, and more.
Founded in March 2017, Uplatz has seen phenomenal rise in the training industry starting with an online course on SAP FICO and now providing training on 5000+ courses across 103 countries having served 300,000 students in a period of just 3 years.
Uplatz’s training courses are highly structured, subject-focused, and job-oriented with strong emphasis on practice and assignments. Our courses are designed and taught by more than a thousand highly skilled and experienced tutors who have strong expertise in their areas whether it be AWS, Azure, Adobe, SAP, Oracle, or any other technology or in-demand software.
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 7h 23m
Language: English
Next start: On Demand

Students are also interested in