Duración

5 días

Descripción

Throughout the lessons of the Oracle Database 12c R2: New Features for Administrators Part 1 course constituted by three modules; the Using SQL New Features and Tools, the Understanding DB Architectures, and the Diagnosing Database Problems, students receive a good knowledge of the Oracle Database 12c Release 2 new and enhanced features in different areas of database administration, mainly in on-premises Multitenant databases.

Objetivos

  1. Navigate and monitor the overall health of your Cloud Control system
  2. Organize targets and groups
  3. Setup targets monitoring, alerts and notifications
  4. Use the job system to create and manage jobs to automate commonly performed tasks
  5. View, search and compare configurations
  6. Manage targets patching
  7. Explain compliance policies and evaluate policy violations
  8. Use BI Publisher to generate custom reports

Contenidos del curso

Introduction

  • Key Challenges for Administrators
  • What Is Enterprise Manager Cloud Control?
  • Built-in and Integrated Manageability
  • This Course in Context
  • Course Schedule
  • Classroom Setup

Enterprise Manager Core Concepts

  • Review Oracle Enterprise Manager architecture
  • Security (high level)
  • Controlling the Cloud Control Framework
  • Self-Monitoring and Maintenance
  • Backup and Recovery: Repository, OMS and OMA, Software Library
  • Viewing Log Files and Trace Files

Targets Setup

  • Targets discovery (review)
  • Administration Hierarchy
  • Groups
  • Target Properties

Oracle Cloud In Your IT Ecosystem

  • Describe the benefits of having Oracle Cloud services in your IT Ecosystem
  • Explore how Oracle Cloud services can be managed and why Enterprise Manager Cloud Control is a superior choice
  • Describe how Enterprise Manager Cloud Control establishes a connection to Oracle Cloud services
  • Explore the new capabilities that are unlocked when Cloud Control is managing Oracle Cloud services

Roles and Privileges

  • Roles
  • Privileges
  • Who can define Roles and Privileges
  • Privileges and Roles Uses

Monitoring Standards

  • Define monitoring standards
  • Setting and using metric thresholds
  • Using Monitoring Templates and templates collection

Managing Events and Incidents

  • Metric Thresholds and Settings
  • Define and manage incidents
  • Distinguish between incidents and problems
  • Monitor problems (including incidents flooding)
  • Use incident rule sets
  • Describe the processing priority of rules and notifications
  • Corrective Actions
  • Incidents Dashboard

Using Notifications, Blackouts and Brownouts

  • Define Blackouts and Brownouts, benefits
  • Blackouts
  • Brownouts
  • Monitoring Service
  • Receiving Alerts and Notifications
  • Metric Extensions

Using the Job System

  • Core Concepts and Tasks: what is new in EM 13c
  • Understand job privileges
  • Distinguish predefined jobs for your user-defined ones
  • Create and manage jobs of different types
  • Creating a Multi-Task Job
  • Use the job library
  • Enable job notifications
  • View job activity

Managing Systems and Services

  • Workflow for Systems and Services Define and administer systems
  • Viewing the System Topology
  • Define and create services, service types
  • Define and monitor the availability of a service
  • Discuss the use of beacons
  • Define and monitor service levels
  • Specifying Service Level Rule Elements

Patching and Provisioning

  • Software life-cycle management
  • Provisioning and patching
  • Software library review
  • Use of Deployment Procedure Manager
  • Deployment procedures and use cases
  • Bare metal provisioning
  • Software patching: modes and workflow
  • Software Upgrades

Managing Configurations

  • What Is Configuration Management?
  • Viewing Configurations
  • Comparing Configurations
  • Searching the Enterprise Configuration
  • Configuration topology

Managing Compliance

  • Compliance Management
  • Define compliance management: framework, standards, and rules
  • Describe the predefined compliance functionality
  • Assign compliance standards to targets
  • View the results: score and importance
  • Point out the doc Oracle® Enterprise Manager Cloud Control Oracle Database Compliance Standards

Producing and Using EM Reports Using BI Publisher

  • Information Publisher vs BIP: IP deprecated
  • BIP intro and configuration basics
  • Using Oracle-Provided BIP Reports
  • Reporting on Targets
  • Workflow for Creating Reports
  • Schedule, save, and email reports
  • Publish Enterprise Manager Reports


Información extra

Learn to

  • Use the new SQLcl utility and gain information on SQL*Plus and SQL enhancements.
  • Understand the new and enhanced features of Oracle Database 12c Release 2 (12.2.0.1) amongst different areas such as the new Multitenant architecture and the Sharded database architecture.
  • Diagnose database issues, handling Automatic Diagnostic Repository (ADR) file management and using the Trace File Analyzer (TFA) tool.

Benefits to you

You will benefit from learning the following lessons:

Using the SQL New Features and Tools module covers the usage of the new SQLcl utility and the new features in SQL*Plus and SQL.

Most of the Understanding DB Architectures module lessons cover the new Multitenant architecture. The concept of regular and application containers of a Multitenant container database includes new administrative tasks such as creating, managing, securing, backing up, recovering and upgrading regular and application containers, as well as migrating an 11g database to a 12c multitenant container database. The lessons also cover enhanced features of Resource Manager to help you manage the resources within a Multitenant container database. You will discover other enhancements supported in a Multitenant container database like heat map and Automatic Data Optimization (ADO) support, Database Vault and encryption. The second part of the module gives an overview of database sharding. It describes the challenges and benefits of a sharded database, the sharded database architecture and how to configure a sharded database.

The lesson of the Diagnosing Database Problems module covers enhancements in ADR space management and explain what can be completed with the Trace File Analyzer (TFA) tool in terms of database diagnosis.

Audience

  • Database Administrators
  • System Administrator
  • System Integrator
  • Systems Architects
  • Technical Administrator

Suggested Prerequisites

  • Familiarity with Database Control
  • Familiarity with Fusion Middleware Control
  • Good knowledge of Linux

Información general

Área formativa

Oracle Base de Datos

Fabricante

Oracle

Metodología

Presencial

Certificación

Garantía juvenil

 

¿TIENES DUDAS? PREGÚNTANOS

He leído y acepto la del sitio y las condiciones de tratamiento de mis datos de carácter personal

 

 

Fecha y precios de nuestros cursos

Fecha Horario de impartición Ubicación Precio por alumno Previsto en fecha
17 Sep 2018
De 09:00 a 15:00 h.
Core Madrid
2145€ + IVA
10 Dec 2018
De 09:00 a 15:00 h.
Core Madrid
2145€ + IVA

¿Necesitas Ayuda?

Consúltanos si necesitas información de nuestros cursos o masters.

 

Contacta con Core Networks