Description

The Oracle Database 12c: Managing Multitenant Architecture training will help professionals gain a conceptual understanding of the multitenant architecture. You will be practicing plugging and unplugging databases in multi-tenant container databases, while learning how to create common and local users and administer database security to meet your business requirements.In this course, professionals will be introduced to Oracle Database Cloud Service.

No hands-on lab environment for TOD format.

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

Duration: 4 days

 

Learn to:

  • Understand the multitenant architecture.
  • Create and manage a multitenant container database and pluggable databases.
  • Manage storage within a multitenant container database and pluggable databases.
  • Manage security within a multitenant container database and pluggable databases.
  • Monitor performance and manage resources within a multitenant container database and pluggable databases.
  • Perform backup, recover and flashback operations on a multitenant container database and pluggable databases.
  • Manage the CDB and PDBs in specific configurations like Data Guard, Database Vault.
  • Perform particular operations like Oracle Data Pump transportation, loading, encryption, auditing.
  • Gain an understanding of the Oracle Database Cloud Service.

 

Benifits

Ensure quick, reliable, secure and easy to manage performance. Develop database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

 

Multitenant Architecture

Professionals will be exploring all aspects of the Oracle multi-tenant container database and any associated pluggable databases during the Oracle Database 12c Administration Workshop. For the business applications purposes Professionals will be learning how to create and control a multi-tenant container database and any associated pluggable databases with storage structures.

 

Backup and Recover Pluggable Databases

During the Oracle Database 12c Backup and Recovery Workshop, professionals will be introduced with multi-tenant container database and pluggable databases backup, recovery and flashback methods.

 

Manage and Monitor Resources

To provide an acceptable response time to users and manage resources effectively, you will learn how to monitor performance and manage resources within the multi-tenant container database.

 

Learning Objectives

  • Configure resource manager to share resources within a multitenant container database between containers and within a pluggable database
  • Implement unified auditing in a multitenant container database and its pluggable databases
  • Use Oracle Data Pump, SQL*Loader in pluggable databases
  • Monitor the multitenant container database and pluggable databases
  • Describe the multitenant architecture
  • Create a multitenant container database
  • Create a pluggable database using different methods
  • Plug a non-CDB into a multitenant container database
  • Manage multitenant container databases and pluggable databases
  • Administer multitenant container database and pluggable database storage structures
  • Create and administer common and local user accounts
  • Manage common and local privileges and roles
  • Configure multitenant container databases and pluggable databases backup and recovery operations
  • Manage the multitenant container database and pluggable databases performance
  • Gain an understanding of the Oracle Database Cloud Service

Prerequisities

Audience Profile

  • Administrator
  • Architect
  • Database Administrator

Course Content

Module 1: Introduction

  • Course Objectives
  • Course Schedule
  • Tools

Module 2: Container and Pluggable Database Architecture

  • Challenges and Benefits
  • Multitenant Architecture
  • Provisioning PDBs
  • Terminology

Module 3: CDB and PDB Creation

  • Using Tools
  • Configuring and Creating a CDB
  • Creating PDBs
  • Dropping PDBs
  • Migrating PDBs

Module 4: Managing a CDB and PDBs

  • Connection
  • Managing a CDB and PDBs
  • Managing PDBs Open Mode and Settings
  • Configuring CDB and PDBs Initialization Parameters

Module 5: Managing Storage in a CDB and PDBs

  • Managing Permanent Tablespaces in CDB and PDBs
  • Managing Temporary Tablespaces in CDB and PDBs

Module 6: Managing Security in a CDB and PDBs

  • Managing Common and Local Users
  • Managing Common and Local Privileges
  • Managing Common and Local Roles
  • Understanding Shared and Non-Shared Objects
  • Managing Common and Local Profiles

Module 7: Managing Availability

  • Managing Backups
  • Managing Recovery Operations
  • Managing Flashback Database
  • Duplicating PDBs
  • Special Situations and Views

Module 8: Managing Performance

  • Managing Performance
  • Managing Resource Allocation
  • Maximizing Consolidated Database Replay

Module 9: Miscellaneous

  • Exporting and Importing Data
  • Loading Data
  • Auditing Operations
  • Scheduling Jobs
  • Using Other Products

Module 10: Oracle Database Cloud Service: Overview

  • Database as a Service Architecture, Features and Tooling
  • Software Editions: Included Database Options and Management Packs
  • Accessing the Oracle Database Cloud Service Console and Automated Database Provisioning
  • Managing Compute Node Associated with a Database Deployment
  • Managing Network Access to Database as a Service and Scaling a Database Deployment
  • Patching Database as a Service and Using the Oracle Database Cloud Service Console to Manage Patches
  • Migrating from On-premises to Oracle Cloud Database
  • Gather Information for Migration

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