Oracle 12c Multitenant Architecture Administration
4.7 (14 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
64 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle 12c Multitenant Architecture Administration to your Wishlist.

Add to Wishlist

Oracle 12c Multitenant Architecture Administration

Learn how to build and manage an Oracle 12c Multitenant Architecture database.
New
4.7 (14 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
64 students enrolled
Created by Ahmed Baraka
Last updated 9/2017
English
Current price: $40 Original price: $160 Discount: 75% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 10.5 hours on-demand video
  • 22 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Describe the Oracle 12c 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
View Curriculum
Requirements
  • 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
Description

Learn how to build and manage Oracle 12c Multitenant Architecture (including releases 12.1 and 12.2)

Not only the course will demonstrate the concepts for you, you will also gain practical experience on implementing the them.

  • Describe the Oracle 12c 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

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 40 lectures and more than 10 hours of video-based sessions, you’ll learn all of the managing Oracle 12c 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 12c 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 two 12c release: 12.1 and 12.2.

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 12c multitenant container and have the knowledge and experience to manage it.

Join the author in this learning journey to experience this amazing technology!

Who is the target audience?
  • Oracle Database Adminisrators
Compare to Other Oracle Database Courses
Curriculum For This Course
48 Lectures
10:24:24
+
Introduction
1 Lecture 05:59
+
Oracle Database Multitenant Architecture
3 Lectures 38:16

By the end of this lecture, you should be able to:

  • Understand the business challenges that the Multitenant option is addressing
  • Understand the basic structure of the Oracle Multitenant
  • and finally describe the benefits of Oracle Multitenant 
Preview 11:28

By the end of this lecture, you should be able to:
  • Describe the difference between the CDB and PDB
  • Describe the Multitenant Architecture components
  • Describe the difference between the shared undo and the local undo configuration
  • Describe the difference between the local users and common users
  • Understand the impact of implementing a multitenant configuration
Preview 14:02

By the end of this lecture, you should be able to:

  • Describe the changes introduced in Oracle Multitenant Architecture release 12.2.
  • Describe the new components:
    • Application root
    • Application
    • Application PDB
  • Describe the advantage of using application PDBs.
Oracle Database Multitenant Architecture 12.2
12:46
+
Create CBD containers and PDB containers
8 Lectures 01:43:11

By the end of this lecture, you should be able to:

  • Describe the methods and the options to create an Oracle 12c R2 CDB database
Creating a CDB
12:03

This practice guides you to prepare the environment that you will use in the course practices. The practices in the course were designed using virtual machines. You will build two Linux-based virtual machines. One of them will be the main machine that you will use in most of the course practices and the other machine will be used only in a few practices.

Practice 1 Preparing the Practice Environment
09:01

This practice guides through creating two databases in the appliances that you created in the previous practice.

In this practice you will perform the following:
  • You will create a CDB in the appliance srv1. 
  • You will create a non-CDB database in the appliance srv2. 
  • Perform the following configuration settings:
    • Enable the automatic database startup and shutdown
    • Getting the Enterprise Manager Database Express working in the VM appliance
    • Run and test the SQL Developer
Practice 2 Creating a CDB ( Part 1 of 4 )
20:06

This is a continue to the previous video.

Practice 2 Creating a CDB ( Part 2 of 3 )
15:10

Practice 2 Creating a CDB ( Part 3 of 4 )
09:42

Practice 2 Creating a CDB ( Part 4 of 4 )
08:22

By the end of this lecture, you should be able to:

  • List the tools to create a PDB
  • List the options to create a PDB
  • List the options to define the location of PDB file locations
  • Create a PDB from the seed using the SQL*Plus.
Creating PDBs from the Seed
13:06

In this practice, you will create PDB databases from the seed using two methods.

In this practice you will perform the following:
  • Create a PDB using SQL*Plus
  • Create a PDB using the DBCA
  • Add the created Pluggable Database net service name in the tnsnames.ora file 
  • Perform basic exploring to the created PDBs.
Practice 3 Creating PDBs from the Seed
15:41
+
Basic Oracle Multitenant Database Adminisration
4 Lectures 55:58

By the end of this lecture, you should be able to:

  • Understand the licenses needed to use the Multitenant option
  • Describe the pros and cons of using the Multitenant option
  • Learn more about the changes in the Multitenant architecture
  • Describe the PDB identifiers
More Concepts About Oracle Database Multitenant
14:58

By the end of this lecture, you should be able to:

  • Switch the current container
  • Change the CDB and PDB states
  • Save the PDB open states
  • Change a PDB initialization parameter
  • Drop a PDB
Basic Administration Tasks
13:47

In this practice, you will implement the regular tasks that you may need to do when managing the PDBs. The target is to explore and get familiar with the CDB architecture.

In this practice you will perform the following:
  • Various ways of changing the states of the CDB and the PDBs.
  • Modify the PDB restart states.
  • Modify a parameter in a PDB
  • Change the Global Database Name of a PDB 
  • Explore the CDB tablespaces and datafiles
Practice 4 Performing Basic CDB Administration Tasks ( Part 1 of 2 )
14:17

This is to continue the previous video.

Practice 4 Performing Basic CDB Administration Tasks ( Part 2 of 2 )
12:56
+
Creating PDBS, all the methods
9 Lectures 01:43:37
By the end of this lecture, you should be able to:
  • Create a new PDB by cloning from a local PDB
  • Create a new PDB by cloning from a remote PDB
Creating PDBs More Options Part I
07:37

In this practice you will perform the following:

  • Create a PDB by cloning a local PDB
  • Create a PDB by cloning a remote PDB
Preview 10:27

By the end of this lecture, you should be able to:

  • Create a PDB by plugging in an unplugged PDB
  • Create a PDB by cloning a non-CDB
  • Create a PDB using DBMS_PDB on a non-CDB
Creating PDBs More Options Part II
12:06

In this practice you will perform the following:

  • Create a PDB by plugging in an unplugged PDB using xml file.
  • Create a PDB by plugging in an unplugged PDB using the archived pdb file.
Practice 6 Creating PDB by Plugging in an Unplugged PDB
13:27

In this practice you will perform the following:

  • Create a new PDB by cloning from non-CDB
  • Create a new PDB using the DBMS_PDB package on a non-CDB database.
Practice 7 Creating a PDB from non-CDB
14:16

By the end of this lecture, you should be able to:

  • Relocate a PDB
  • Create a proxy PDB
  • Create a refreshable PDB
Creating PDBs More Options Part III
11:07

In this practice you will relocate a PDB from a CDB to another CDB.

Practice 8 Creating a PDB by Relocating a PDB
15:44

In this practice you will create a proxy PDB. You will then perform basic testing on it.

Practice 9 Creating a Proxy PDB
08:55

In this practice you will create a refreshable PDB and perform basic testing on it.

Practice 10 Creating a Refreshable PDB
09:58
+
Managing Connectivity and Services in Oracle Multitenant
1 Lecture 07:32

By the end of this lecture, you should be able to:

  • Manage services in a multitenant container
  • Dedicate a Listener to a PDB
Connectivity and Services in Oracle Multitenant
07:32
+
Managing Security in Oracle Multitenant database
5 Lectures 01:00:26

By the end of this lecture, you should be able to:

  • Describe the difference between Local and Common Users
  • Create local and common users
  • Describe the difference between common and local grants
  • Enable Common Users to Query Data in Specific PDBs
  • Describe the difference between common and local roles
Managing Local and Common Users
16:09

In this practice you will examine the principles that govern managing the common and local users in CDB and PDBs.

Specifically, you will learn:
  • How to manage common users
  • How to manage local users
  • How to manage common and local roles
  • Granting privileges as common or local
  • Enabling common users to view information about specific PDBs
Practice 11 Managing Common and Local Users ( Part 1 of 2 )
17:04

This is to continue the previous practice.

Practice 11 Managing Common and Local Users ( Part 2 of 2 )
09:37

By the end of this lecture, you should be able to:

  • Describe when you should use Lockdown profiles
  • How to use PDB lockdown profiles
  • How to configure an OS user for a PDB
Managing PDB Lockdown Profiles
10:29

In this practice you will use the PDB lockdown profile to:

  • Disable a database option in a PDB
  • Force a policy on using the ALTER SYSTEM statement in a PDB
Practice 12 Managing PDB Lockdown Profiles
07:07
+
Managing Backup, Recovery, and Flashback Database
6 Lectures 01:15:34

By the end of this lecture, you should be able to:

  • Understand when to use the SYSBACKUP privilege
  • Use RMAN to manage CDB and PDB backup and recovery
Backup and Recovery in CDB and PDBs
11:03

In this practice you will use RMAN to do the following:

  • Take backup of the whole CDB
  • Take backup of the whole PDB
  • Take partial backup of a PDB
  • Implement recovery procedure form SYSTEM datafile loss
  • Implement recovery procedure form non-SYSTEM datafile loss
  • Use the Data Recovery Advisor commands
Practice 13 Backup and Recovery in CDB and PDBs ( Part 1 of 2 )
12:57

This is to continue the previous lecture.

Practice 13 Backup and Recovery in CDB and PDBs ( Part 2 of 2 )
10:45

By the end of this lecture, you should be able to:

  • Perform PITR in CDBs and PDBs
  • Perform Flashback database on CDBs and PDBs
Flashback and Point-in-time Recovery
15:24

In this practice you will perform the following:

  • Point-in-time Recovery (PITR) in a Pluggable Database
  • PITR on a Tablespace in a PDB
  • Flashback at the CDB level
  • Flashback at the PDB level
Practice 14 Point-in-time Recovery and Flashback ( Part 1 of 2 )
14:50

Practice 14 Point-in-time Recovery and Flashback ( Part 2 of 2 )
10:35
+
Using Resource Manager in Oracle Multitenant Database
3 Lectures 38:39

By the end of this lecture, you should be able to:

  • Describe the difference between using the Resource Manager in a CDB container and a non-CDB database.
  • Use the Resource Manager to manage allocating the resources to the PDBs
Using Resource Manager with CDB and PDBs ( Part 1 of 2 )
13:30

This is to continue the previous lecture.

Using Resource Manager with CDB and PDBs ( Part 2 of 2 )
09:58

In this practice, you will create two CDB Resource Manager plans and associated directives to limit the CPU time used by two PDBs.

Practice 15 Using Resource Manager with CDB and PDBs
15:11
+
Miscellaneous Topics on Oracle Multitenant Database
3 Lectures 52:40

By the end of this lecture, you should be able to:

  • Query from a table in multiple containers
  • Use the CONTAINERS clause with DML statements
  • Specify the CONTAINERS DEFAULT TARGET
  • Use Data Pump utility in a multitenant container
  • Apply audit policies in a multitenant container
Miscellaneous Topics on CDB and PDBs
14:52

In this practice, you will perform the following:

  • Query the data owned by common users in multiple PDBs.
  • Change the data owned by common users in multiple PDBs.
  • Specify the Default Container target and test it.
  • Apply an auditing policy in PDB1.
Practice 16 Implementing Miscellaneous Topics
18:17

In this practice, you will perform the following:

  • Export the data from a non-CDB database and import it into a PDB.
  • Export the data from a PDB and import it into another PDB within the same CDB.
Practice 17 Using Data Pump Utility with PDBs
19:31
1 More Section
About the Instructor
Ahmed Baraka
4.6 Average rating
237 Reviews
969 Students
3 Courses
Snr. Database Administrator

Ahmed Baraka has 19 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 computer games.