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.

• 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

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