Oracle Database 12c Managing Multitenant Architecture Training & Placements in Chennai "ISQL GLOBAL"
Oracle Database 12c: Managing Multitenant Architecture
(The Course Materials and Course Completion Certificates are directly delivered from Oracle University to those seeking for Foreign Opportunity)
(Government of India Approved Education Center - SQL STAR)
This Oracle Database 12c: Managing Multitenant Architecture training will help you understand the multitenant architecture. Learn how to manage
an Oracle multitenant container database and any associated pluggable databases in an effective and efficient manner.In this course, you
will be introduced to Oracle Database Cloud Service.
This Oracle Database 12c: Managing Multitenant Architecture training helps you gain a conceptual understanding of the multitenant
architecture. You'll practice 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, you will be introduced to Oracle Database Cloud Service.
Learn To:- Understand the multitenant architecture.
- Create and manage a multitenant container database and pluggabledatabases.
- Managestorage within a multitenant container database and pluggabledatabases.
- Managesecurity within a multitenant container database and pluggabledatabases.
- Monitorperformance and manage resources within a multitenant containerdatabase and pluggable databases.
- Performbackup, recover and flashback operations on a multitenantcontainer 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.
Benefits to You
Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of
service by enabling consolidation onto database clouds.
Multitenant Architecture
During the Oracle Database 12c Administration Workshop, you'll explore all
aspects of the multi-tenant architecture, providing detailed information on the components of an Oracle multi-tenant container
database and any associated pluggable databases. You'll learn why and how to create and manage a multi-tenant container database and
any associated pluggable databases with storage structures appropriate for the business applications.
Backup and Recover Pluggable Databases
During the Oracle Database 12c Backup and Recovery Workshop, you'll be presented with multi-tenant container database and pluggable databases backup, recovery and flashback procedures.
Manage and Monitor Resources
To provide an acceptable response time to Users and manage resources
effectively, you'll learn how to monitor performance and manage resources within the multi-tenant container database.
Prerequisites
Suggested Prerequisite
- Working knowledge of SQL and use of PL/SQL packages
- Working knowledge of tools like SQL*Plus or Enterprise Manager CloudControl
- Knowledgeof non-CDB configuration and management
- Basic knowledge of Linux operating system
Required Prerequisite- Oracle Database 12c: Administration Workshop Ed 2
- Oracle Database 12c: Backup and Recovery Workshop Ed 2
- Oracle Database 12c: Install and Upgrade Workshop
Audience
- Technical Administrator
- Data Warehouse Administrator
- Data Warehouse Administrator
- Database Administrators
- Database Designers
Course
Objectives- Configure resource manager to share resources within a multitenant containerdatabase between containers and within a pluggable database
- Implementunified auditing in a multitenant container database and itspluggable databases
- Use Oracle Data Pump, SQL*Loader in pluggable databases
- Monitorthe multitenant container database and pluggable databases
- Describe the multitenant architecture
- Create a multitenant container database
- Create a pluggable database using different methods
- Pluga non-CDB into a multitenant container database
- Manage multitenant container databases and pluggable databases
- Administer multitenant container database and pluggable database storagestructures
- Create and administer common and local User accounts
- Manage common and local privileges and roles
- Configure multitenant container databases and pluggable databases backup andrecovery operations
- Manage the multitenant container database and pluggable databasesperformance
- Gain an understanding of the Oracle Database Cloud Service
Course Topics
Introduction- Tools
- Course Objectives
- Course Schedule
Container
and Pluggable Database Architecture- Terminology
- Multitenant Architecture
- Provisioning PDBs
- Challenges and Benefits
CDB
and PDB Creation- Dropping PDBs
- Using Tools
- Configuring and Creating a CDB
- Creating PDBs
- Migrating PDBs
Managing
a CDB and PDBs- Managing PDBs Open Mode and Settings
- Managing a CDB and PDBs
- Configuring CDB and PDBs Initialization Parameters
- Connection
Managing
Storage in a CDB and PDBs- Managing Temporary Tablespaces in CDB and PDBs
- Managing Permanent Tablespaces in CDB and PDBs
Managing
Securityin a CDB and PDBs- Managing Common and Local Privileges
- Understanding Shared and Non-Shared Objects
- Managing Common and Local Users
- Managing Common and Local Profiles
- Managing Common and Local Roles
Managing
Availability- Managing Recovery Operations
- Duplicating PDBs
- Special Situations and Views
- Managing Flashback Database
- Managing Backups
Managing
Performance- Managing Resource Allocation
- Managing Performance
- Maximizing Consolidated Database Replay
Miscellaneous- Using Other Products
- Scheduling Jobs
- Exporting and Importing Data
- Auditing Operations
- Loading Data
Oracle
Database Cloud Service: Overview- Database as a Service Architecture, Features and Tooling
- Patching Database as a Service & Using the Oracle Database Cloud Service Console to Manage Patches
- Managing Network Access to Database as a Service & Scaling a DatabaseDeployment
- Managing the Compute Node Associated With a Database Deployment
- Software Editions: Included Database Options and Management Packs
- Accessing the Oracle Database Cloud Service Console & Automated DatabaseProvisioning
- Migrating from On-premises to Oracle Cloud Database
- GatherInformation for Migration