OEM ( Oracle Enterprise Manager) Online Training
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
No Reviews found for this course.