OEM ( Oracle Enterprise Manager) Online Training

OEM ( Oracle Enterprise Manager) Online Training

0 STUDENTS ENROLLED

    Introduction

    Oracle Enterprise Manager 11g/12C is designed to manage the software and hardware evolved by the oracle corporation. It’s a set of tools for both oracle and non oracle web based management solutions for testing, operating, deploying, monitoring, resolving, diagnosing and monitoring issues. It’s simply the extension of the oracle enterprise manager grid control. It allows the end users to have a wide range of benefits of cloud computing. It completely manages the cloud life cycle management with oracle stack.

    Course Objectives
    • Understand policies and evaluate policy violations.
    • Perform common troubleshooting tasks.
    • Use Information Publisher to generate custom reports.
    • Create jobs to perform commonly-run tasks.
    • Describe the architecture of Enterprise Manager Grid Control.
    • Create administrators and roles.
    • Monitor and manage the Enterprise Manager Grid Control framework.
    • Define and monitor services and service levels.
    • Perform a single-server install.
    • Describe the available upgrade paths.
    • Describe a 1&2-system upgrade scenario.
    • Plan and execute a 1&2-system upgrade from Oracle Enterprise Manager Grid Control.
    • Describe the architecture of Oracle Enterprise Manager 12c Cloud Control.

    PRE-REQUISITES: Good Knowledge of Linux, Database Control and Fusion Middle Ware Control

    Course Curriculum

    MODULE 1: INTRODUCTION

    TOPICS: What Today’s Data Center Looks Like, Key Features, Defining Enterprise Manager Grid Control, Use Of Enterprise Manager Grid Control in Business Driven IT Management, Capabilities to Manage Enterprise Application Stack, Plug Ins and Connectors

    MODULE 2: INTRODUCTION TO ORACLE DATABASE 12C

    TOPICS: Overview of the Oracle Cloud, Overview of the Oracle Database 12c, Database ADMINISTRATION TASKS, RELATIONAL DATABASE CONCEPTS

    MODULE 3: GRID CONTROL ARCHITECTURE

    TOPICS: Components of Grid Control, Architecture of Grid Control, Target Types Managed by Grid Control, Maximum Availability Architecture

    MODULE 4: ORACLE DATABASE 12C ARCHITECTURE

    TOPICS: Overview of the Oracle Database Architecture, Connect to the Oracle Database Instance, Oracle Database Memory Structures, Server and Client Processes, the Oracle Database Instance, the Oracle Database Storage Architecture, Process Architecture and Structures

    MODULE 5: DATA CONCURRENCY AND LOCK CONFLICTS

    TOPICS: Levels Of Locking in Oracle, Data Concurrency, Possible Causes of Contention, Prevent Locking Problems, Methods Used to Acquire Locks, Resolve Conflicts, DML Locks, Grid Control Architecture, Detect Lock Contention

    MODULE 6: SQL TUNING

    TOPICS: SQL Tuning, SQL Plan Directives, The Oracle Optimizer, SQL Advisors, Implement Automatic Tuning Recommendations, Automatic SQL Tuning Results, SQL Tuning Advisor, Adaptive Execution Plans

    MODULE 7: AUTOMATE TASKS WITH THE SCHEDULER

    TOPICS: Introduction to the Scheduler, Access Rights, Create a Job, Scheduler Components and Workflow, Create an Event Based Scheduling, Job Classes, Use Time Based, Event Based Schedules

    MODULE 8: INSTALLING AND CONFIGURATION OF AN ORACLE DATABASE

    TOPICS: Understand System Requirements, Delete a Database Using Dbca, Use Oracle Universal Installer, Use DBCA to Manage Templates, Create and Update Database Using DBCA and DBUA

    MODULE 9: ADMINISTER A DATABASE AND DATABASE STORAGE STRUCTURES

    TOPICS: Administrative Tools Available to a Dba, Start and Stop the EM Database Console, EM Navigation, Administer the Database Using Enterprise Manager, Use SQL*Plus and SQL Developer Manage a Database, Oracle Database Structures, Grant EM Administrative Privileges to a User, Redo Log and Archive Redo Log Files, Control Files, Manage Undo and Use the Undo Advisor, Tablespaces and Data Files, Create And Manage Table Spaces, Use EM to View the Storage Structure of the Database

    MODULE 10: CONFIGURE THE ORACLE NETWORK ENVIRONMENT

    TOPICS: Overview of Network Configuration, Oracle Net Naming Methods, Oracle Net Listener Management and Configuration, Use Tnsping to Test Oracle Net Connectivity, Start and Stop the Oracle Listener, Configure Local Naming for Client Connections with Net Manager, Configure the Listener with EM, Connect to the Database, Tools for Managing and Configuring the Oracle Network

    MODULE 11: MANAGE AN ORACLE INSTANCE

    TOPICS: Oracle Instance, Memory Structures, Instance Management, Initialization Parameters, Access An Oracle Database, Shutdown the Database, Background Processes, Startup the DATABASE, PASSWORD FILE, VIEW ALERT LOG AND TRACE FILES

    MODULE 12: MANAGE USERS AND SCHEMA OBJECTS

    TOPICS: User Accounts, Create and Administer User Accounts, Database Administration Accounts, Administer Privileges and Roles, Create Indexes, Change a User’s Password, Lock and Unlock User Accounts, View the Attributes and Contents of a Table, Create Schema Objects, Understand Data Integrity, Define Constraints, View Index Attributes, Create Views, Sequences, Synonyms, New Tables

    MODULE 13: PERFORMANCE MONITORING

    TOPICS: Monitor an Oracle Database, Self-Monitoring Architecture, Automatic Database Diagnostics Monitor, Automatic Workload Repository, Set Up Notification Rules, Use the Advisors, Conclusion

    Write a Review

    Your email address will not be published. Required fields are marked *

    Course Reviews

    5

    5
    1 ratings
    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 4 weeks, 2 days
    Contact Us

    +1 475-212-0075

    Drop us a query

    Error: Contact form not found.

    Job Support

    Error: Contact form not found.

    Course Features

    Live Instructor-led Classes

    This isn't canned learning. Its dynamic, its interactive, its effective

    Expert Educators

    Only the best or they're out. We are constantly evaluating our trainers

    24&7 Support

    We never sleep. Need something answered at 3 am? No Problem

    Flexible Schedule

    You don't learn as per our calendar. We work according to yours.

    Customized Training's

    The most part self-managed and adaptable to suit a person's particular adapting technology needs

    Priority Based Training's

    Real-time Scenario based Assignments and Case Studies

    COPYRIGHT © 2020 KEEN IT TECHNOLOGIES PVT.LTD, ALL RIGHTS RESERVED