Course Description

Course Overview

The Oracle Enterprise Manager (OEM) 19c Cloud Control course is designed to provide participants with a comprehensive understanding of Oracle’s centralized management and monitoring solution for Oracle Database environments. Participants will learn how to deploy, configure, and administer Oracle Enterprise Manager Cloud Control to effectively manage their Oracle Database infrastructure. The course covers topics such as installation, configuration, monitoring, performance tuning, and administration of Oracle databases using OEM 19c Cloud Control.

Prerequisites

To derive maximum benefit from this course, participants should have a solid understanding of Oracle Database administration concepts and familiarity with SQL. Prior knowledge of Oracle Database administration and management tasks is required. It is recommended that participants have completed the Oracle 19c DBA course or possess equivalent knowledge.

Methodology

The course utilizes a combination of theoretical instruction, demonstrations, and hands-on labs. Participants will receive detailed explanations of Oracle Enterprise Manager Cloud Control concepts and techniques, followed by practical demonstrations of their implementation. They will also have the opportunity to apply their learning in hands-on labs, gaining practical experience in deploying, configuring, and administering Oracle Enterprise Manager Cloud Control. The course is delivered through instructor-led sessions, allowing participants to interact, ask questions, and engage in discussions.

Course Outline

• Introduction to Oracle Enterprise Manager Cloud Control
• Overview of Oracle Enterprise Manager and its benefits
• Introduction to OEM Cloud Control architecture
• Understanding OEM Cloud Control components and features
• Overview of management packs and plug-ins
• Deploying and Configuring OEM Cloud Control
• Preparing for OEM Cloud Control installation
• Installing and configuring OEM Cloud Control components
• Managing targets and agents
• Configuring security and access controls
• Monitoring and Managing Oracle Databases
• Registering and discovering Oracle databases in OEM Cloud Control
• Monitoring database performance and availability
• Managing database backups and recovery
• Configuring and managing database alerts and notifications
• Performance Tuning and Diagnostics
• Performance monitoring and analysis using OEM Cloud Control
• Identifying and resolving performance bottlenecks
• Configuring and managing Automatic Database Diagnostic Monitor (ADDM)
• Utilizing SQL Tuning Advisor and SQL Access Advisor
• Administration and Configuration Management
• Managing database configurations using OEM Cloud Control
• Configuring and managing database options and features
• Managing database patches and upgrades
• Database cloning and provisioning using OEM Cloud Control
• Advanced Management and Automation
• Utilizing Oracle Enterprise Manager jobs and notifications
• Automating common administration tasks using OEM Cloud Control
• Managing Oracle Real Application Clusters (RAC) environments
• Utilizing Oracle Data Guard with OEM Cloud Control
• Database Security and Compliance
• Managing database security using OEM Cloud Control
• Implementing database auditing and compliance measures
• Monitoring and managing database privileges and access controls
• Utilizing Oracle Advanced Security features with OEM Cloud Control
• Oracle Cloud Integration
• Integrating Oracle Cloud services with OEM Cloud Control
• Monitoring and managing Oracle Cloud resources
• Backup and recovery strategies for Oracle Cloud environments
• Utilizing Oracle Autonomous Database with OEM Cloud Control

Course Outcome

Upon completion of the course, participants will:

• Understand the concepts and techniques of Oracle Enterprise Manager Cloud Control for Oracle Database management and administration.
• Be proficient in deploying, configuring, and managing OEM Cloud Control components.
• Possess the skills to monitor and manage Oracle databases using OEM Cloud Control.
• Understand performance tuning and diagnostics using OEM Cloud Control.
• Be familiar with administration and configuration management techniques.
• Possess knowledge of advanced management and automation capabilities of OEM Cloud Control.
• Understand database security and compliance measures using OEM Cloud Control.
• Have the ability to integrate Oracle Cloud services with OEM Cloud Control for comprehensive management.

Course Labs

The course includes hands-on labs that provide participants with practical experience in deploying, configuring, and managing Oracle Enterprise Manager Cloud Control. The labs cover various scenarios, allowing participants to practice OEM Cloud Control installation and configuration, database monitoring and management, performance tuning and diagnostics, administration and configuration management, database security and compliance, and Oracle Cloud integration. The labs are designed to reinforce the concepts learned during the theoretical instruction and help participants build confidence in their Oracle Enterprise Manager Cloud Control administration skills.