Enquiry

Oracle Database 12c: Managing Multitenant Architecture Training & Certification Courses

Share this page:

Exam Details

Duration:	120 minutes
Number of Questions:	80
Passing Score:	60% View passing score policy
Validated Against:	This exam has been validated against Oracle Database 12.1.0.1.0.
Format:	Multiple Choice
Exam Price:	₹10,265.00 More on exam pricing

Course Content / Exam(s)

1. Introduction

Course Structure
Suggested Schedule
Enterprise Manager Cloud Control and Other Tools
Target Discovery: Multitenant Container Database
Enterprise Manager Cloud Control
Enterprise Manager Database Express
Configuring Enterprise Manager Database Express
Database Configuration Assistant
SQL*Plus
Oracle SQL Developer: Connections
Oracle SQL Developer: DBA Tasks

2. Basics of Multitenant Container Database and Pluggable Databases

Course Structure
Challenges
Non-CDB Architecture
New Multitenant Architecture: Benefits
Other Benefits of Multitenant Architecture
Configurations
Oracle Container Database
A Pristine Installation
User Data Is Added
Separating SYSTEM and User Data
SYSTEM Objects in the USER Container
Naming the Containers
Provisioning a Pluggable Database
Interacting Within Multitenant Container Database
Multitenant Container Database Architecture
Containers
Questions: root Versus PDBs
Questions: PDBs Versus root
Terminology
Common and Local Users
Common and Local Privileges and Roles
Shared and Non-shared Objects
Data Dictionary Views
Impacts
Multitenant Architecture General Architecture Poster

3. Creating a Multitenant Container Database and Pluggable Databases

Course Structure
Goals
Tools
Steps to Create a Multitenant Container Database
Create a Multitenant Container Database: Using SQL*Plus
Create a Multitenant Container Database: Using DBCA
New Clause: SEED FILE_NAME_CONVERT
New Clause : ENABLE PLUGGABLE DATABASE
After CDB Creation: What’s New in CDB
Data Dictionary Views: DBA_xxx
Data Dictionary Views: CDB_xxx
Data Dictionary Views: Examples
Data Dictionary Views: V$xxx Views
EM Cloud Control:
EM Cloud Control: Storage Example
After CDB Creation: To do List
Automatic Diagnostic Repository
Automatic Diagnostic Repository: alert.log File
Provisioning New Pluggable Databases
Tools
Method 1: Create New PDB from PDB$SEED
Steps: With FILE_NAME_CONVERT
Steps: Without FILE_NAME_CONVERT
Method 1: Using SQL Developer
Synchronization
Method 2: Plug a Non-CDB into CDB
Plug a Non-CDB into CDB Using DBMS_PDB
Plug a Non-CDB into CDB Using Replication
Method 3: Clone PDBs
Clone PDBs: Using SQL Developer
Method 4: Plug Unplugged PDB into CDB
Method 4: Flow
Unplugged PDB: Using SQL Developer
Plug Unplugged PDB: Using SQL Developer
Unplug and Plug PDB with Encrypted Data
Plug Sample Schemas PDB: Using DBCA
Dropping a PDB
Migrating pre-12.1 or 12.1 non-CDB to CDB

4. Managing a Multitenant Container Database and Pluggable Databases

Course Structure
Connection
Connection with SQL*Developer
Creating Services
Switching Connection
Starting Up a CDB Instance
Mounting a CDB
Opening a CDB
Opening a PDB
Closing a PDB
Shutting Down a CDB Instance
Database Event Triggers: Automatic PDB Opening
Changing PDB Mode
Changing PDB Mode: With SQL Developer
Modifying a PDB Settings
Instance Parameter Change Impact
Instance Parameter Change Impact: Example
Using ALTER SYSTEM Statement on PDB

5. Managing Tablespaces in CDB and PDBs

6. Managing Security in CDB and PDBs

Course Structure
Users, Roles, and Privileges
Local Users, Roles, and Privileges
Creating a Local User
Common Users
Creating a Common User
Common and Local Schemas
Common and Local Privileges
Granting Common and Local Privileges
Granting and Revoking Privileges
Creating Common and Local Roles
Granting Common or Local Privileges / Roles to Roles
Granting Common and Local Roles to Users
Granting and Revoking Roles
Creating Shared and Nonshared Objects
Enabling Common Users to Access Data in Specific PDBs
Finding Information About CONTAINER_DATA Attributes
Creating Common and Local Profiles
Assigning Common and Local Profiles to Users
Assigning Profiles
Restriction on Definer's Rights

7. Backup, Recovery, Flashback CDB and PDBs

Course Structure
New Syntax and Clauses in RMAN
CDB Backup: Whole CDB Backup
CDB Backup: User-Managed Hot CDB Backup
CDB Backup: Partial CDB Backup
PDB Backup: Whole PDB Backup
PDB Backup: Partial PDB Backup
Using RMAN Backup to Plug an Unplugged PDB
Recovery
Instance Failure
NOARCHIVELOG Mode
Media Failure: CDB or PDB Tempfile Recovery
Media Failure: PDB Tempfile Recovery
Media Failure: Control File Loss
Media Failure: Redo Log File Loss
Media Failure: root SYSTEM or UNDO datafile
Media Failure: root SYSAUX Datafile
Media Failure: PDB SYSTEM Datafile
Media Failure: PDB Nonsystem Datafile
Using Data Recovery Advisor
Data Failures
Data Recovery Advisor RMAN Command-Line Interface
Media Failure: PITR
Flashback CDB
Duplicating Pluggable Databases
Checking for Block Corruption
Special Situations
New Data Dictionary View and Column

8. Performance

9. Miscellaneous

Course Structure
Using Oracle Data Pump with PDBs
Exporting from non-CDB and Importing into PDB
Exporting and Importing Between PDBs
Exporting from PDB and Importing into non-CDB
Full Transportable Export/Import: Overview
Full Transportable Export/Import: Usage
Full Transportable Export/Import: Example
Transporting a Database Over the Network: Example
Using SQL*Loader with PDBs
Auditing Actions in a CDB and PDBs
Creating an Audit Policy at CDB/PDB Level
Enabling / Disabling the Audit Policy
Viewing the Audit Policy
Viewing the Audit Records CDB_UNIFIED_AUDIT_TRAIL
Dropping the Audit Policy
Audit Cleanup
Securing Data with Transparent Data Encryption
The Keystore and Master Keys
Creating the Keystore
Opening the Keystore
Setting Master Encryption Keys
Unplug and Plug PDB with Encrypted Data
Securing Data with Oracle Database Vault
Using Xstreams with a CDB and PDB
Creating a Standby of a CDB
Scheduling Operations in a PDB
Jobs Coordinator and Resources
Mining Statements of a PDB Using LogMiner

10. Oracle Database Cloud Service: Overview

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

© 2024 Unisoft Technologies - Nagpur | Developed By In House Team

Full Name*

Mobile*

Email

Course*

City*

Nagpur Pune

Message