Oracle Enterprise Manager: 7 Robust Features To Put In Action

Oracle Enterprise Manager:7 Robust Features to Put inActionPRESENTED BYRakesh Nagdev,Senior Oracle Database Administrator

New York Oracle UserGroup (NYOUG)Virtually live from New York, the world's mostexciting city welcomes all Oracle users,associates, students and professionals tobecome part of this dynamic group.NYOUG was formed in 1984 for the exchangeof ideas, assistance and support among usersof Oracle software products.nyoug.orgLeadershipPresident: Simay Alpogepresident@nyoug.orgVice President: Coleman Levitervicepresident@nyoug.orgTreasurer: Robert Edwardstreasurer@nyoug.org

PresenterRakesh Nagdev, Senior Oracle Database AdministratorSenior Oracle Database Administrator with 17 years ofexperienceOracle Certified Professional & AWS Certified SolutionArchitect ProfessionalTech Expertise: Oracle Enterprise Manager Automation AWS Cloud Services Oracle Real Application Clusters Data Guard, Database Upgrades, Migrations, &Performance Tuningwww.datavail.com3

DatavailOverviewWe are data specialistsDatabases, Analytics, andApplication Data Integration16 years deliveringdata servicesAll major platforms: SQL Server,Oracle, DB2, MySQL, MongoDB,PostgreSQL, AWS, AzureEBSComprehensive development &operational servicesSharePointMicrosoft DynamicsCustom development Microsoft .NETReactive and proactive services Oracle APEXAnalytics, Visualization &Integrationwith average clientretention of 7 yearswww.datavail.comHyperion/EssbaseUS & Global models700 customersManaged services,projects, and rosoft SSRS, SSIS, SSASInformaticaPowerBIOracle Data IntegratorOracle OBIEE, BICS, GoldenGateETL development andoperational run4

Fill OutEvaluation FormFill out the Cloud Adoption surveyfor a chance to WIN a Work fromHome bdbc0b7e1dThe Work from Home package includes:Datavailopoly – the game for DBAs by DBAsDatavail maskNoise-canceling headphonesDatavail hoodieDatavail insulated cupSherpa blanket

AgendaOracle Enterprise Manager (OEM) OverviewHistory of OEMWho Uses OEM?Why Do Organizations Choose OEM?Seven Highlights of OEM Cloud Control 13c

OEM OverviewOracle Enterprise Manager (OEM) is amonitoring & management tool thatsupports small to large and sometimescomplex environments.www.datavail.com7

OEM OverviewOEM can monitor and manageyour wide-ranging enterpriseenvironment lization Infrastructure,Cross Deployments &OEM provides additional functionalitywith the help of management packsthat includes:Oracle Diagnostics Pack and Oracle TuningPack, Database Lifecycle ManagementPack, Oracle Configuration ManagementPack, Oracle Change Management Pack,Oracle Data Masking Pack and many more.These management packs require aseparate license.Non-Oracle Targetswww.datavail.com8

History of OEM2001200420102016OEMDatabaseControl2020OEM CloudControl 13cVersion 4OEM CloudControlOEMApplicationServer ControlOEM GridControlwww.datavail.com9

Who Uses OEM?OEM is intended for database administrators andsystem administrators supporting enterprise-levelinfrastructure.Organizations heavily invested in Oracle-basedinfrastructure gain the most significant benefitsamong potential users, since this is a first-partyenterprise management tool.However, other companies can find significantvalue even if you have a limited Oracle focus.www.datavail.com10

Why DoOrganizationsChoose OEM?Oracle has a rock-solid reputation for offeringenterprise-grade solutions that are powerful andsecure.Both your on-premise and Oracle Cloud-basedtechnologies are supported, along with a long list ofother assets.OEM has been in development for 20 years & Oraclecontinually releases improvements that enhance thisplatform.Automation, database optimizations, user experience –a win for a DBA.Extensions combined with flexibility.www.datavail.com11

Seven Highlights ofOEM 13c1. Intelligent Incident Compression2. Chef Job Support3. Always-ON Monitoring4. Notification Blackouts5. System Broadcast6. Export & Import Incident Rule Sets7. Metric Enhancementswww.datavail.com12

Intelligent Incident Compression(Smart Alerting)“Flood of Alerts” experienced with 11g and/or 12c OEMWith the release of Enterprise Manager 13c, Intelligent Incident Compression allowsmultiple events to be automatically grouped into a single incident.Situations where its useful to deal with multiple related events as a single incident are: Consolidation of events from targets on same host. Merging of all Tablespace Used (%) alerts across all tablespaces for a particular databaseinto a single incident. You want to automatic union of all Metric Collection Errors for a target into a single incident. By compressing notifications, we can manage related events as one unit.www.datavail.com13

Intelligent Incident Compressionwww.datavail.com14

Chef Job SupportChef is a declarative configurationmanagement and automation platform.Chef has become popular for its concept of“infrastructure as code,” in which machinereadable files called Chef recipes are usedto provision infrastructure includingcomputing hardware and networking.Chef recipes are now supported with a newjob type introduced in 13c EnterpriseManager Cloud Control.www.datavail.com15

Chef Job SupportYou can now manage and access Chefcookbooks and Chef recipes in the softwarelibrary.The execution of chef recipes is nowsupported by deployment procedures.You can store Chef cookbooks and Chefrecipes in the software library or even locally toa host where it gets executed: www.datavail.comMust have chef-solo setupCreate a folder in Software libraryChef cookbook should be uploadedCreate an OEM job using the new Chef job typeand submit it16

Chef Job Supportwww.datavail.com17

Always-ON MonitoringTHE WAIT IS OVER formonitoring targets in critical anddown alerts when OEM is downfor a planned maintenance orunavailable during an outage withAlways-ON Monitoring.The Administrator can enable notifications as andwhen required, but it’s best practice to keep AOMrunning all the time and notifications can be enabledas per requirement.Always-ON Monitoring (AOM) is alightweight application that isincluded in 13c Cloud Control.The monitoring configuration of targets andnotifications data including contacts and emailgateway configuration synchronized with Always-ONMonitoring as it will be reusing existing configurationof Enterprise Manager.You can enable AOM monitoringby following a few simple steps inOEM.Once AOM is properly setup and synchronized, theEM notifications can be received even whenEnterprise Manager services are unavailable.www.datavail.com18

Always-ON MonitoringAlways nterprise ManagerExample:emctl set property -name "oracle.sysman.core.events.ems.emsURL" -value "https://yourhostname:8081/upload" -sysman pwd sysmanwww.datavail.com19

Notification BlackoutsNotification Blackout disablesnotifications during the blackout periodon the targets which are undernotification blackout.There are two types of NotificationBlackouts:www.datavail.com Maintenance Notification Blackout Notification-only Notification Blackout20

Notification Blackoutswww.datavail.com21

Retroactive Blackoutwww.datavail.com22

System BroadcastBest practice is to notify users current connected to Enterprise Manager aboutoutages before any planned maintenance.Oracle introduced a new feature in 13c Cloud Control known as System Broadcast.The super administrator can notify all users who are connected to EnterpriseManager by sending a message before any planned maintenance work.The EMCLI provides new send system broadcast verb using which we can sendmessage including severity levels.Based on the requirement you should set necessary user preferences for SystemBroadcastswww.datavail.com23

System BroadcastExample:emcli send system broadcast -messageType "INFO" -toOption "ALL" -message "EnterpriseManager will be taken down in an hour for an emergency patch"www.datavail.com24

Export and Import of Incident Rule SetsExporting incident rule sets from One Enterprise Manager site into another is now available in13c Cloud Control.Mimic the rule set with multiple Enterprise Managers without redoing the configuration ofincident rule sets manually.Please Note: The rulesets along with incident rules, users, recipients’ email addresses,targets on which ruleset are configured and notification methods can also be exported. If any of these entities are already available in the target Enterprise Manager cloud control then theywill be kept in the rule set, else they are removed during the import to target site.Standardizes the notification rule sets across multiple enterprise managers in the globalcomplex environment where multiple Enterprise managers are hosted in different datacenters.www.datavail.com25

Export and Import of Incident Rule Setswww.datavail.com26

Metric EnhancementsIn previous releases of OEM, users extendedmonitoring by creating user defined metric which had limited functionality and wasavailable only for a few known target types.In 13c Cloud Control the metric extensionsallow you to create full-fledged metrics for amultitude of target types: Hosts, Databases, Oracle Exadata databases and storageservers,Advantages of Metric Extensions Metric Comparison operators can now bemodified for alerts Compute expressions are now supported inmetric extensions. Metric extensions are can be setup for RACand NON-RAC (single instance) databasesThese enhancements in Metric extensionsprovide better monitoring and flexibility tomeet requirement of monitoring complexenvironments. Siebel components, Oracle Business Intelligence components, Fusion Applications IBM WebSpherewww.datavail.com27

Metric Enhancementswww.datavail.com28

Fill OutEvaluation FormFill out the Cloud Adoption surveyfor a chance to WIN a Work fromHome bdbc0b7e1dThe Work from Home package includes:Datavailopoly – the game for DBAs by DBAsDatavail maskNoise-canceling headphonesDatavail hoodieDatavail insulated cupSherpa blanket

@nyoug nyc, @NYOUG PresConnectWith Us!New York Oracle Users GroupNew York Oracle Users ork-Open-Group-Meetup/

Outreach toOur Members.Oracle User Group ergroups

Questions &Discussion

Thank You!Thank You!nyoug.orgdatavail.com

with the help of management packs that includes: Oracle Diagnostics Pack and Oracle Tuning Pack, Database Lifecycle Management Pack, Oracle Configuration Management Pack, Oracle Change Management Pack, Oracle Data Masking Pack and many more. These management packs require a separate license. OEM can monitor and manage your wide-ranging enterprise