how to use the powerpoint template - oracle › technetwork › oem › arch-deploy › con... ·...

CON9714 Oracle Management Cloud Best Practices for Mining Oracle Enterprise Manager Data

Mithun Shankar Shailesh Dwivedi Werner De Gruyter

System Management Products September 2015

Oracle OpenWorld 2015 Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |

Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |

Safe Harbor Statement

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

Oracle OpenWorld 2015


Agenda

Oracle Enterprise Manager

Oracle Management Cloud

Harnessing Enterprise Manager Data with Oracle Management Cloud

Demo

1

2

3

4


Copyright © 2015, Oracle and/or its affiliates. All rights reserved. | Oracle OpenWorld 2015

Oracle Enterprise Manager

1


Pillars of Manageability

Complete Lifecycle

Management

Integrated Cloud

Stack Management

Business-Driven Application

Management

Self-Service IT | Simple and Automated | Business Driven


Enterprise Manager Architecture


Repository Database

Management Server

EM Users: EMCLI Console / Reports

Agent

Agent

Agent

Firewall

Notifications

Connectors

Internet or Cloud Service

Repository (OMR)

Management Server (OMS)

Management Agent (OMA)

– Heart – Data Store – Aggregate, Evaluate & Purge

– Brains – Data Broker - Handles Agent and UI requests – Sends out notifications

– Nerve Endings – Gathers management information – Performs administration tasks


Evolving Needs for Monitoring and Administration

Optimize Existing Operations with Integrated Stack

Management

Deploy in private cloud: Consolidation, automated provisioning, Self-Service,

Metering & Chargeback

Implement Single Pane of Glass Management with Workload

Portability across clouds

Data Center Private Cloud Hybrid Cloud

The Single Pane of Glass for managing services on-premise and on Oracle Cloud


Optimizing the IT infrastructure


Performance & Availability Management

– User Experience Monitoring

– Problem Diagnosis

– Performance Tuning

– Transaction Tracing

Lifecycle Management

– Patching

– Provisioning

– Resource Management

– Consolidation Planning

Configuration Management

– Collection, Tracking and History

– Application Configuration Management

– Compliance & Reporting

– Auditing & Remediation

Quality Management

– Test Environment Management

– Automated Testing

– Data Cloning

– Data Sub-setting and Masking


Enterprise Manager Data

• Manages / Interacts


Management Server OMS

Target Model: Discovery Info (UI)

Administration Tasks (UI)

• Stores / Aggregates

Repository OMR

Target Model: Target Associations

Compliance Evaluations

Incident Workflow

Service Levels / KPI's

Jobs / Deployment Procedures

• Gathers

Agents OMA

Metrics: Configuration Data

Metrics: Operational Data

Alerts: Threshold Violations

Target Model: Target Properties

Administration Task Details


• Plug-in framework • Standard monitoring plug-ins delivered

with EM for Oracle products

• Add plug-ins to the environment based

on environmental needs

• Agent executes metrics for all monitored targets: – Defines HOW to collect (SQL, OS command,

JMX, …) – Executes on a repeating schedule (frequency) – Has optional thresholds to report alerts – Each metric has a classification (target

modeling, operational data, configuration data)

• Add custom metrics for environment specific monitoring (ME - Metric Extensions)

• The gathered data is send to the OMS for upload into the repository


• 145+ Extensions • All available on the Oracle Enterprise Manager

Extensibility Exchange

• New Extensibility Development Kit

and Partner-Built Plug-Ins

Gathering the Data

http://www.oracle.com/goto/emextensibility


A Wealth Of Operational Data

• Application Topology • Target Associations • Target Relationships

• Configuration History • Historical account of all configuration changes

made

• Operational History • Historical performance and resource

utilization data • Metric and Customized Metrics data

• Alert History • Threshold violations • Availability data



2

Copyright © 2015, Oracle and/or its affiliates. All rights reserved. | 14

Introducing Oracle Management Cloud

Vision:

Complete suite of IT Operations services on the cloud

Monitoring

Diagnostics Performance Management

Orchestration

Scheduler Configuration Management

Reporting

Notifications

Logs

Analytics

Resource Management


Initial Offerings Solve The Most Pressing IT Challenges

Application Performance Monitoring

Improve End-User Experience

and System Performance; Diagnose Performance Issues

Faster

Log Analytics

Extract Value from Logs by Collecting, Correlating, and

Searching Any Kind of Log Data; Quickly Discover Anomalies

IT Analytics

Make Critical Decisions About Your IT Estate; Plan For Growth, Run

What-If Analyses, Compare Resource Usage


Continuous Ingest Machine Learning

Real-Time Processing

Customer-Generated Data

Machine-Generated Data

All of Your Operational Data, Correlated and Analyzed

Anomaly Detection

Real-time Insight

Comprehensive Monitoring


Big Data for IT Operations


• Single unified data platform to store all types of machine data, that will be automatically correlated

• Scalable data processing pipeline that can ingest and process large volumes of data at line speed

• New cloud services that will provide real-time monitoring, rapid diagnostics, operational insight and business analytics

• APIs for customers to design stakeholder dashboards for DevOps, LOB Executive

Unified Big Data Platform

Application Performance Monitoring

Log Analytics IT Analytics

Unified Big Data Platform

Data Pipeline


Harnessing Enterprise Manager Data with



3


Private Cloud Public Cloud

Applications Database Server/Storage EM Cloud Control

Machine Data

Log Analytics IT Analytics APM

Sources of OMC Data Oracle Management Cloud


IT Analytics

Log Analytics

APM

EM Target Model

Metrics

Incidents

Configuration

Compliance

Logs

APM Server Data

APM Browser Data

Continuous Data Streams

OMC Services

Unified Data Platform

Real-time & Historical

Ente

rpri

se M

anag

er

Types of Data loaded to OMC

…

24/7


Oracle Management Cloud – Data Collection

Gateway Firewall

HTTPS HTTPS HTTPS HTTPS Database Application

Storage EMCC Repository

Agent

Internet

Periodic upload from local file Outbound, one-way network connectivity Self-updatable and fault-tolerant

Customer Premises Oracle Cloud


Harnessing EM Data with IT Analytics

• EM Repository data is loaded in OMC data store on and on going basis

– Historical dataset includes metrics, metric extensions, configuration, Target Model, Topology, Association, Events, Availability etc

• Data can be sourced from multiple EMs

• Longer retention period for large data set in cloud allows meaningful analytics

• Powerful Analytics Engine provide capabilities like forecasting, trending, capacity planning, ad hoc searches

• Dashboards to provide rich data visualization



Harnessing EM Data with Log Analytics • Light Touch Aggregation

– Automated configuration of Log Location, Log Types for added EM Targets

– Out-of-box configuration, collection, rules, and saved searches on known target types

• Topology information is used for application aware log search

– Log searches scoped to the components running a specific application

– Topology Elasticity automatically factored in

• APM to Log drill down

– APM is able to locate right log file based on collected topology information

• Custom Dashboard and Searches – Include known entity types like system, groups, cost center, configuration, metrics etc. in

customized dashboard and saved searches



Customer Use Cases • “7-Eleven's 7-Rewards loyalty program mobile application spans across multiple clouds including Oracle and their on-

premises datacenters. The solution serves millions of customers daily from tens of thousands of retail stores in US and Canada," said Ron Clanton, Director, Enterprise Architecture, 7-Eleven. "We intend to leverage Oracle Management Cloud's ability to provide us with Application Performance Management and Log Analytics for end to end visibility across multiple clouds to ensure the highest level of service across our many providers, so that we know about any potential problems before our customers do. Oracle's ability to handle data sets of our size is extremely important for a service as widely-used as ours.”

– Ron Clanton, Director, Enterprise Architecture, 7-Eleven

• “We were very excited to get a preview of the Oracle Management Cloud…the advanced analytical capabilities will be able to proactively alert us to potential application issues before they impact our clients. The sum total of the Oracle Management Cloud offerings provide a rapid time-to-value and will enable a smarter and more effective enterprise.”

– Thomas Clewett, VP & CTO, Exelon Corp



Conclusion

• EM Cloud Control has wealth of operational data

• OMC functionality is complementary to EM Cloud Control

– It is not EM in Cloud

• OMC Services are enriched by the data collected in EM Cloud Control



Demo

4


Questions?



Appendix

5


OMC Launch Day Tuesday!

Session Title Time Location

General Session: Oracle Management Cloud—Real-Time Monitoring, Log, and IT Operations Analytics [GEN9778]

11:00 AM Moscone South

102

Oracle IT Analytics Cloud Service: Next-Generation Analytics for Maximizing Performance [CON9722]

12:15 PM Moscone South

309

Oracle Application Performance Monitoring Cloud Service: Application Visibility for DevOps [CON9746]


309

Oracle IT Analytics Cloud Service: Operational Insight for Your Database and Middleware Estate [CON9752]


300

31


OMC Sessions & Labs for Wednesday & Thursday Session Title Day Time Location

Oracle Log Analytics Cloud Service: Real-Time Insight for Middleware Administrators [CON9754]

Wednesday 12:15 PM Moscone South

303

Oracle Log Analytics Cloud Service: Real-Time Insight for Database Administrators [CON9753]

Wednesday 3:00 PM Moscone South

300

Oracle Management Cloud Best Practices for Mining Oracle Enterprise Manager Data [CON9714]

Thursday Noon Marriott Marquis

Salon 10/11

32

Hands On Lab Day Time Location

Oracle Management Cloud: IT Analytics, Log Analytics, and App Performance Monitoring [HOL10443]

Tuesday 4:00 PM Hotel Nikko

Mendocino I/II


Wednesday 10:15 AM Hotel Nikko

Mendocino I/II


Thursday 12:30 PM Hotel Nikko

Mendocino I/II


OMC Demos

Demo Title Workstation

Oracle Application Performance Monitoring Cloud Service SPI-036

Oracle IT Analytics Cloud Service SPI-003

Oracle Log Analytics Cloud Service SPI-037

33

Demo Hours • Monday: 10:15 AM to 6 PM • Tuesday: 10:15 AM to 6 PM • Wednesday: 10:15 AM to 4 PM

Location Moscone South Oracle Cloud Platform & Infrastructure Showcase


Enterprise Manager Sessions – Monday October 26th Title Time Location

Oracle Enterprise Manager: The Complete Solution and Oracle’s Best-Kept Secrets [CON9715]

12:15 PM Moscone South 300

Simplify the Deployment and Monitoring of Your Identity Management System [CON9468] 12:15 PM Moscone South 310

Advanced Management: Oracle SOA Suite and Oracle Service Bus with Oracle Enterprise Manager [CON9751]


Managing at Hyper-Scale: Oracle Enterprise Manager as the Nerve Center of Oracle Cloud [CON9710]


Oracle Enterprise Manager Database Consolidation Workbench—Secret to Successful Consolidation [CON9718]


Best Practices for Maintaining and Supporting Oracle Enterprise Manager [CON8671] 4:00 PM Moscone West 2024

The Future of Oracle Enterprise Manager: What’s Next? [CON9708] 4:00 PM Moscone South 300

HA–Enabled Oracle Enterprise Manager 12c on Virtualized Oracle Database Appliance [CON6928]


34


Enterprise Manager Sessions – Tuesday October 27th Title Time Location

General Session: Oracle Management Cloud—Real-Time Monitoring, Log, and IT Operations Analytics [GEN9778]

11:00 AM Moscone South 102

Oracle Enterprise Manager: The Future of Hardware Management [CON9732] 12:15 PM 5th Floor – Hotel

Intercontinental C

Oracle IT Analytics Cloud Service: Next-Generation Analytics for Maximizing Performance [CON9722]


Upgrading Oracle Enterprise Manager: Why and How [CON9729] 12:15 PM Moscone South 300

Enterprise Patient Data Repository Using Oracle Healthcare Analytics and Oracle SOA Suite [CON7720]

4:00 PM Park Central – City

Latest Innovations in Database as a Service Enabled by Oracle Enterprise Manager [CON9734]


Oracle Application Performance Monitoring Cloud Service: Application Visibility for DevOps [CON9746]


Oracle IT Analytics Cloud Service: Operational Insight for Your Database and Middleware Estate [CON9752]


35


Enterprise Manager Sessions – Wednesday October 28th Title Time Location

Oracle Enterprise Manager 12c Cloud Control for Managing Oracle E-Business Suite 12.2 [CON8127]

11:00 AM Moscone West

3022

Using Oracle Enterprise Manager Effectively to Become an Oracle Enterprise Manager Champion [CON9711]

11:00 AM Moscone South 104

Oracle Log Analytics Cloud Service: Real-Time Insight for Middleware Administrators [CON9754]


Way Beyond the Basics: Oracle Enterprise Manager Monitoring Best Practices [CON9721]


Oracle Log Analytics Cloud Service: Real-Time Insight for Database Administrators [CON9753]


Best Practices for Engineered Systems Management Using Oracle Enterprise Manager [CON9728]


Hybrid Cloud—Pivot to the Cloud with Oracle Enterprise Manager Cloud Control [CON9712]

4:15 PM 5th Floor – Hotel

Intercontinental B

36


Enterprise Manager Sessions – Thursday October 29th Title Time Location

Case Study: How a Cloud-Based, Service-Oriented Customer Uses Oracle Enterprise Manager [CON2800] 9:30 AM Marriott Marquis

Salon 10/11

Database as a Service: What Is It and How Do You Use It? A Q&A with an Expert Panel [CON3637] 9:30 AM Moscone South 102

Practical Tips for Oracle Enterprise Manager High Availability and Diagnostics [CON9726] 9:30 AM Moscone South 300

Oracle Enterprise Manager for MySQL Database—Latest Features [CON4507] 10:15 AM Moscone South 262

Oracle Management Cloud Best Practices for Mining Oracle Enterprise Manager Data [CON9714] Noon Marriott Marquis

Salon 10/11

Raising the Ante on Security with Oracle Enterprise Manager [CON9719] Noon Moscone South 300

Realizing MWaaS on the Private Cloud Using Oracle Enterprise Manager [CON4627] Noon Moscone South 302

Case Study: Oracle Application Management Suite for Oracle E-Business Suite [CON8126] 1:!5 PM Moscone West 3004

Oracle Enterprise Manager? OpenStack? VSphere? Have It Your Way! [CON8059] 1:15 PM Intercontinental—Sutter

(5th Floor)

Supercharge Your DevOps Automation Using Oracle Enterprise Manager’s CLI and REST APIs [CON9731] 1:15 PM Moscone South 300

37


Enterprise Manager Labs

Location: Hotel Nikko—Carmel (3rd Floor) – unless noted Day Time

Oracle Systems and Virtualization Management with Oracle Enterprise Manager [HOL10466]

Monday 11:00 AM

Consolidate and Standardize Database Resources with Lifecycle and Private Cloud Management [HOL10468]

Monday Wednesday

2:00 PM 4:15 PM

Hybrid Cloud Management: Complete Management of On-Premises and Public Services [HOL10465]

Tuesday Wednesday

10:15 AM 11:45 AM

Practical Overview of the Latest Features of Oracle Enterprise Manager for MySQL [HOL4522] **Location: Hotel Nikko—Peninsula (25th Floor)

Tuesday 10:15 AM

Maximizing Oracle Database 12c Performance with Oracle Enterprise Manager [HOL10442]

Tuesday Tuesday

11:45 AM 5:30 PM

Managing Oracle Fusion Middleware with the New Oracle Enterprise Manager [HOL10453]

Wednesday Thursday

10:15 AM 12:30 PM

Consolidate and Standardize Database Resources with Lifecycle and Private Cloud Management [HOL10468]

Monday Wednesday

2:00 PM 4:15 PM

38


Continue The Conversation…


http://www.oracle.com/goto/enterprisemanager http://docs.oracle.com/en/enterprise-manager/

https://www.linkedin.com/topic/oracle-enterprise-manager

https://www.facebook.com/oracleenterprisemanager

https://twitter.com/oracle_em

https://www.youtube.com/user/OracleEnterpriseMgr

https://blogs.oracle.com/oem

http://www.oracle.com/goto/enterprisemanager

http://docs.oracle.com/en/enterprise-manager/








https://www.facebook.com/oracleenterprisemanager

https://twitter.com/oracle_em

https://www.youtube.com/user/OracleEnterpriseMgr

https://blogs.oracle.com/oem


API Application Programming Interface APM Application Performance Management CLI Command Line Interface CMDB Configuration Management DataBase CPU Central Processing Unit DB DataBase EDK Enterprise Development Kit EM Enterprise Manager GC Grid Control HTTP HyperText Transfer Protocol HTTPS HyperText Transfer Protocol Secure IT Information Technology IO Input/Output JDK JAVA Development Kit JMX JAVA Management Extensions

KPI Key Performance Indicator LOB Line Of Business ME Metric Extensions OEM Oracle Enterprise Manager OMA Oracle Management Agent OMC Oracle Management Cloud OMR Oracle Management Repository OMS Oracle Management Server OS Operating System SLA Service Level Agreement SQL Structured Query Language UI User Interface VM Virtual Machine


TLA Library


Classroom Training

Learning Subscription

Live Virtual Class

Training On Demand

Keep Learning with Oracle University

education.oracle.com

Cloud

Technology

Applications

Industries


Harnessing EM Data with IT Analytics Data Exploration

Category Key questions

Asset Analysis, Performance Analysis

• What are my data center assets and how are they distributed across my organization • What version and options for my Oracle database are deployed across my datacenter? • Which WebLogic servers are configured with 2G heap? Are they in Test or Production? Which

versions are they running? • Which are my top 10 Hosts consuming CPU in the last six months ?

Custom Dashboards and Advanced analytics

• How do I create executive dashboards that provide summary view of capacity, performance and availability by data center location.

• Infrastructure administrators have asked for a quarter over quarter report of CPU growth of production databases on Exadata and its relative comparison with corresponding CPU growth on standard (non-Exadata) database servers

• Application managers need to see the impact of configuration changes on their application availability? Are the no. of events increasing with configuration changes ?

• Which cost center generated most events ?

DB Performance Analysis

• How can I perform detailed performance analysis across databases and across time?

how to use the powerpoint template - oracle › technetwork › oem › arch-deploy › con... ·...

Documents