Oracle Database 12c R2: New Features For Administrators Part 1 Ed 1

Transcription

Oracle Database 12c R2: New Featuresfor Administrators Part 1 Ed 1DuraciónDías: 5 DíasHoras: 30 horasDescripciónThroughout the lessons of the Oracle Database 12c R2: New Features forAdministrators Part 1 course constituted by three modules; the Using SQL NewFeatures and Tools, the Understanding DB Architectures, and the DiagnosingDatabase Problems, students receive a good knowledge of the Oracle Database12c Release 2 new and enhanced features in different areas of databaseadministration, mainly in on-premises Multitenant databases.Beneficios para ustedYou will benefit from learning the following lessons:Using the SQL New Features and Tools module covers the usage of the new SQLclutility and the new features in SQL*Plus and SQL.Most of the Understanding DB Architectures module lessons cover the newMultitenant architecture. The concept of regular and application containers of aMultitenant container database includes new administrative tasks such ascreating, managing, securing, backing up, recovering and upgrading regular andapplication containers, as well as migrating an 11g database to a 12c multitenantcontainer database. The lessons also cover enhanced features of ResourceManager to help you manage the resources within a Multitenant containerhttps://www.corenetworks.es/Tfno.: 34 91 767 10 65 Mail: formacion@corenetworks.esC/ Serrano Galvache, 56. Edificio Olmo Planta 1- 28033, Madrid (España)C/ Castilla 169 y C/ Rafael Belmonte García 6 - 41010 Sevilla (España)Avda. París, 26 – 10005 Cáceres (España)

database. You will discover other enhancements supported in a Multitenantcontainer database like heat map and Automatic Data Optimization (ADO)support, Database Vault and encryption. The second part of the module gives anoverview of database sharding. It describes the challenges and benefits of asharded database, the sharded database architecture and how to configure asharded database.The lesson of the Diagnosing Database Problems module covers enhancementsin ADR space management and explain what can be completed with the TraceFile Analyzer (TFA) tool in terms of database diagnosis.A quién se dirige Database AdministratorsSystem AdministratorSystem IntegratorSystems ArchitectsTechnical AdministratorRequisitosSuggested Prerequisite Familiarity with Database Control Familiarity with Fusion Middleware Control Good knowledge of LinuxQué aprenderá Use the new SQLcl utility and gain information on SQL*Plus and SQLenhancements. Understand the new and enhanced features of Oracle Database 12cRelease 2 (12.2.0.1) amongst different areas such as the new Multitenantarchitecture and the Sharded database architecture. Diagnose database issues, handling Automatic Diagnostic Repository(ADR) file management and using the Trace File Analyzer (TFA) tool.https://www.corenetworks.es/Tfno.: 34 91 767 10 65 Mail: formacion@corenetworks.esC/ Serrano Galvache, 56. Edificio Olmo Planta 1- 28033, Madrid (España)C/ Castilla 169 y C/ Rafael Belmonte García 6 - 41010 Sevilla (España)Avda. París, 26 – 10005 Cáceres (España)

Objetivos1.2.3.4.5.6.7.8.Navigate and monitor the overall health of your Cloud Control systemOrganize targets and groupsSetup targets monitoring, alerts and notificationsUse the job system to create and manage jobs to automate commonlyperformed tasksView, search and compare configurationsManage targets patchingExplain compliance policies and evaluate policy violationsUse BI Publisher to generate custom reportsContenido1. Introduction Key Challenges for Administrators What Is Enterprise Manager Cloud Control? Built-in and Integrated Manageability This Course in Context Course Schedule2. 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, SoftwareLibrary Viewing Log Files and Trace Files3. Targets Setup Targets discovery (review) Administration Hierarchy Groups Target Propertieshttps://www.corenetworks.es/Tfno.: 34 91 767 10 65 Mail: formacion@corenetworks.esC/ Serrano Galvache, 56. Edificio Olmo Planta 1- 28033, Madrid (España)C/ Castilla 169 y C/ Rafael Belmonte García 6 - 41010 Sevilla (España)Avda. París, 26 – 10005 Cáceres (España)

4. Oracle Cloud In Your IT Ecosystem Describe the benefits of having Oracle Cloud services in your ITEcosystem Explore how Oracle Cloud services can be managed and whyEnterprise Manager Cloud Control is a superior choice Describe how Enterprise Manager Cloud Control establishes aconnection to Oracle Cloud services Explore the new capabilities that are unlocked when Cloud Controlis managing Oracle Cloud services5. Roles and Privileges Roles Privileges Who can define Roles and Privileges Privileges and Roles Uses6. Monitoring Standards Define monitoring standards Setting and using metric thresholds Using Monitoring Templates and templates collection7. 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 Dashboardhttps://www.corenetworks.es/Tfno.: 34 91 767 10 65 Mail: formacion@corenetworks.esC/ Serrano Galvache, 56. Edificio Olmo Planta 1- 28033, Madrid (España)C/ Castilla 169 y C/ Rafael Belmonte García 6 - 41010 Sevilla (España)Avda. París, 26 – 10005 Cáceres (España)

8. Using Notifications, Blackouts and Brownouts Define Blackouts and Brownouts, benefits Blackouts Brownouts Monitoring Service Receiving Alerts and Notifications Metric Extensions9. 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 activity10. 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 Elements11. 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 provisioninghttps://www.corenetworks.es/Tfno.: 34 91 767 10 65 Mail: formacion@corenetworks.esC/ Serrano Galvache, 56. Edificio Olmo Planta 1- 28033, Madrid (España)C/ Castilla 169 y C/ Rafael Belmonte García 6 - 41010 Sevilla (España)Avda. París, 26 – 10005 Cáceres (España)

Software patching: modes and workflow Software Upgrades12. Managing Configurations What Is Configuration Management? Viewing Configurations Comparing Configurations Searching the Enterprise Configuration Configuration topology13. 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 ControlOracle Database Compliance Standards14. 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 Reportshttps://www.corenetworks.es/Tfno.: 34 91 767 10 65 Mail: formacion@corenetworks.esC/ Serrano Galvache, 56. Edificio Olmo Planta 1- 28033, Madrid (España)C/ Castilla 169 y C/ Rafael Belmonte García 6 - 41010 Sevilla (España)Avda. París, 26 – 10005 Cáceres (España)

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 .