Description

Oracle Database 18c: Managing Multitenant Architecture course covers all aspects of the multitenant architecture, providing detailed information on the components of a CDB and its regular and application PDBs. You learn why and how to create and manage a CDB and its regular and application PDBs, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged PDBs in CDBs using various methods.

In addition, you learn how to ensure the security within the containers of the CDB. You create common and local users, grant common and local privileges and roles, and administer database security to meet your business requirements by using encryption, Database Vault and auditing.

This course includes CDB and PDBs backup, duplicate, recovery and flashback procedures.

You learn how to monitor the performance and manage resources within a CDB and its PDBs, and within each PDB.

It introduces the data movement capabilities between non-CDBs and PDBs, and between PDBs.

Finally, it also covers the procedures of upgrading an Oracle Database 12.2 CDB to an Oracle Database 18c CDB or an Oracle Database 12.2 PDB to an Oracle Database 18c PDB.

Radiant Techlearning offers Oracle Database 18c: Managing Multitenant Architecture Training Program in Classroom and Virtual Instructor Led/Online mode.

 

Duration: 2 days

 

Learning Objectives

  • Manage PDB snapshots
  • Encrypt data in PDBs and isolate PDB keystore
  • Monitor performance in CDBs and PDBs
  • Audit users in CDB and PDBs
  • Protect data with Database Vault policies in CDB and PDBs
  • Manage a CDB fleet
  • Manage resource allocation between PDBs and within a PDB
  • Use Data Pump operations from a non-CDB or CDB into a PDB
  • Upgrade 12c CDBs or PDBs to 18c
  • Configure and create a CDB
  • Create, clone, unplug, plug, relocate, proxy, switch over and drop PDBs
  • Startup and shutdown CDBs and PDBs
  • Manage tablespaces in CDB and PDBs
  • Manage common and local users, roles, privileges, profiles, objects in CDBs and PDBs
  • Manage PDB lockdown profiles
  • Backup, duplicate, recover and flashback CDB and PDBs

Prerequisites

Suggested Prerequisite

  • Basic knowledge of Linux operating system
  • Working knowledge of SQL and use of PL/SQL packages

Required Prerequisite

  • Oracle Database 18c: Administration Workshop Ed 1
  • Oracle Database 18c: Administration Workshop Ed 1 LVC

Audience Profile

  • Administrator
  • Architect
  • Database Administrator

Course Content

  • CDB Basics
  • CDB and Regular PDBs
  • Application PDBs and Application Installation
  • PDB CreationCDB and PDB Management
  • Storage
  • Security
  • Backup and Duplicate
  • Recovery and Flashback
  • Performance Monitoring
  • Resources Allocation
  • Data Movement
  • Upgrade methods
  • Miscellaneous

FAQs

Q: What is the benefit of multitenant architecture?

 

A: Oracle database is installed with new feature of the multitenant architecture which helps users to reduce the cost by simplifying consolidation, providing upgrades and more. Multitenant architecture allows a database container to hold many pluggable database simultaneously.

 

Q: Do I need to have any hands on experience in working on a any operating system?

 

A: Yes, the audience is recommended to have an experience of working with Linux operating system.

 

Q: What is meant by tablespaces in database?

 

A: Tablespaces are multiple logical storage units which are responsible for conforming operating system in which Oracle database and for storing files known as datafiles.

 

Q: What kind of audience is expected for this training?

 

A: This training is recommended for :-

  • Administrator
  • Architect
  • Database Administrator

 

Q: What are PDB snapshot?

 

A: PDB snapshot is an exact replica of the data created. Such collection of snapshot form a snapshot carousel. After specific time and when carousel reaches it’s maximum limit of snapshot it overwrites the oldest data.

 

Q: How many PDBs are in CDB?

 

A: A CDB can contain upto 252 PDBs.

 

Q: Why one should prefer Radiant Techlearning ?

 

A: Radiant believes in practical and creative approach to training and development which distinguishes it from the other training and developmental platforms. Moreover training courses are undertaken by some of the experts who are having vast range of experience in their domain.

 

Q: What if I/we have doubts after attending your training program?

 

A: Radiant team of experts would be available on the e-mail support@radianttechlearning.com to answer your technical queries even after the training program.

 

Q: Does this training program include any project?

 

A: Yes, Radiant will provide you most updated high value and relevant real time projects and case studies in each training program.

 

Q: If I face technical difficulty during the session then is there any remedy for that?

 

A: Technical issues are unpredictable and might occur with us as well.   Participants have to ensure that they have access to the required configuration with good internet speed.

 

Q: What is schedule of training program?

 

A: Radiant Techlearning offers training programs on weekday, weekend and combination of weekday and weekend.  We provide you complete liberty to choose the schedule that suits to your need.

Categories: ,

Unble To Find a Batch..?

Request a Batch