Oracle Database 12c Manage Multitenant Architecture

GB Direct

Course

In London

£ 795 + VAT

The best Oracle courses

See all

See all

Description

  • Type

    Course

  • Location

    London

This Oracle Database 12c Manage Multitenant Architecture course course is designed to give Oracle Database Administrators an understanding of Multitenant Architecture in Oracle Database 12c and to give them an appreciation of how Multitenant Architecture may be implemented at their own sites.

Facilities

Location

Start date

London
See map
Clerks Court 18-20 Farringdon Lane Clerkenwell, EC1R 3AU

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Database training
  • Database
  • IT

Course programme

Follow-On Course

  • Oracle Database 12c Data Guard

Oracle Container and Pluggable Database Architecture

  • Overview of Multitenant architecture
  • An overview of a Container database (CDB)
  • The benefits of Multitenant architecture
  • Multitenant database terminology
  • The root container and pluggable database containers
  • The structure of the root container
  • The structure of a pluggable database (PDB)
  • CDB_xxx and DBA_xxx Views

Configure and create a Container Database and Pluggable Databases

  • Tools used to create and manage a CDB and PDBs
  • Create and configure a CDB using dbca
  • Examine the structure of a CDB using Enterprise Manager, SQL Developer and the CDB_xxx Views
  • Administer the database using Enterprise Manager, SQL*Plus and SQL Developer
  • Create a new PDB from PDB$SEED
  • Create a PDB from a Non-CDB
  • Clone a PDB into the same CDB using DB links
  • Plug and unplug a PDB
  • Drop a PDB

Manage a Container Database anbd Pluggable Databases

  • Connect to a CDB as an Administrator
  • Connect to a PDB using a service name
  • Startup and shutdown a CDB
  • Open and close a PDB Using SQL*Plus and EM
  • Open and close all PDBs
  • Change the state of a PDB
  • Configure CDB and PDB initialization parameters

Manage Storage in a Container Database and Pluggable Databases

  • Data storage overview
  • Create permanent tablespaces in the root and PDBs
  • Create temporary tablespaces in the root and PDBs
  • Temporary UNDO

Manage Common and Local Users, Roles and Privileges

  • Manage common and local schemas and users in the Root and PDBs
  • Manage system and object privileges to common and local grantees
  • Manage common and local roles
  • Manage common and local profiles
  • Shared and non-shared objects

Manage Backup, Recovery and Flashback of a CDB and PDB

  • Backup a CDB
  • Backup a PDB
  • Recover a CDB from the loss of redo log files, control files and undo datafile loss
  • Recover a CDB from the loss of datafiles
  • Use Flashback at CDB Level
  • Duplicate PDBs

Manage Performance

  • Manage performance
  • Manage resources between PDBs
  • Manage resources within a PDB
  • Manage resources with CDB and PDBs plans
  • Automated maintenance tasks
  • Maximize Consolidated Database Replay

Miscellaneous Features

  • Export and import data
  • Load data
  • Audit operations
  • Schedule jobs

See related categories

Oracle Database 12c Manage Multitenant Architecture

£ 795 + VAT

The best Oracle courses

See all

See all