Monitoring Best Practices White Paper for Enterprise Manager 13c

Monitoring Best Practices White Paper for Enterprise Manager 13c now available

Written by Ana Mccollum, initially published with Oracle Enterprise Manager 12c and now updated for Oracle Enterprise Manager 13c, it was written based on many years of working with customers with large data centers who needed monitoring features to enable them to monitor at scale. The paper offers guidance from planning your monitoring setup, understanding key Oracle Enterprise Manager monitoring concepts and features, to strategies for how you can use these features to implement a scalable monitoring solution.

Download the paper now

In this paper, you’ll learn how to:

  • Leverage Administration Groups and Template Collections to manage alert thresholds across different environments in an automated way
  • Configure your Incident Rule Sets to send incident notifications to the appropriate teams based on event type and severity, escalate important incidents, prevent a flood of email alerts when a host goes down
  • Use privilege-propagating groups with roles to ensure different IT Operations staff have the appropriate level of access to your targets as soon as they are added to Oracle Enterprise Manager

Many of the examples are largely based on real-world scenarios.

OEM and monitoring the -MGMTDB GIMR Database

Just run into this interesting post concerning the monitoring of MGMTDB databases as part of Grid Infrastructure, on Neil Chandler’s DBA Blog

oem-mgmtdb

 

 

 

 

However as we know that Oracle 12.1.02 comes with a mandatory Grid Infrastructure Management Repository database (the MGMTDB database) it to my opinion makes sense to monitor it using Oracle Enterprise Manager.

For more information on the GIMR database see the Oracle documentation on it: http://docs.oracle.com/database/121/CWADD/troubleshoot.htm#CWADD92242

Improved topology browser

Going through the recently released EM12c version 12.1.0.4, you can’t miss several improvements…

Let’s take a look at the topology browser after selecting a composed target like a Generic Service, EM Console Service is this example:

Improved topology browser 1

As you can see the page includes a graphical presentation of the topology show all relationship lines nicely organized. By simply moving the mouse pointer over one of the targets, all directly related targets will get highlighted.

Looking at the righside pane we notice the Node type filter that allows you to include or exclude any of the targets from the topology view.

By simply moving the mouse pointer over  the critical alert mark, you are able to directly zoom into the details.

Improved topology browser 3

 

Optimize Oracle WebLogic performance/manageability: Oracle EM12c

Screen Shot 2012-10-01 at 9.34.03 AM

For those of you who are still not aware; the days of EM being just a nice Database monitoring tool are way behind us. Curious to know what managing the complete stack means, might have persuade you to join this session by Nicole Haba (Oracle) and Ishaq Mohammed (Pacific Gas & Electric).

IMG_0098

Nicole starts with pointing out some of the challenges we have when trying to monitor and manage the Middleware Stack.

These include:

  • Monitoring & Diagnostics
    • Multiple Domain Discovery
    • Out-of-Box Monitoring
    • Metric Extensions
    • Administration Groups & Template Collections
    • Incident & Problem Management
    • Business Application Management
    • Middleware Diagnostics Advisor
    • JVM Diagnostics
    • Log Viewer
  • Administration
    • Credential Management
    • Record WLST scripts
    • System MBean Browser
    • Configure Log File Settings
    • Change Center
    • JDBC Data Source Management
    • Process Control
    • Selective Tracking
  • Configuration Management
    • Automated Asset Directory
    • Compare Configurations
    • Search Configurations
    • Compliance Management
    • Custom Configurations
    • Synchronize Configurations
    • Config Change History
  • Lifecycle Management
    • Cloning Domains
    • Patch Automation

Nicole introduces some Hints and Tips… :

Like: How can we discover multiple domains in EM? Simply create a csv file containing the specs of all domains to be discovered and use EMCLI to perform the discovery, using the csv as input parameter file.

IMG_0081

Using the Middleware Diagnostics Advisor to identify and resolve performance issues

IMG_0087

I must admit after conducting several EM12c Bootcamps, I am a MDA fan myself…

Enforcing standards by cloning WebLogic Domains. Exactly as we are used to working with “Golden Images” of Database Homes, the same goes for WebLogic domains.

Uploading binaries to the EM Software Library (a central location in EM to store images like OS, Database, Middleware and Applications) to allow provisioning of these to new servers and by that enforcing standardization.

IMG_0089

Next Ishaq Mohammed gives us an insight of the challenges at Pacific Gas & Electric and the way they implemented EM12c to monitor and manage the middleware stack.

IMG_0092

Several challenges motivated PG&E to start EM12c implementation, including:

  • 20% increase of WebLogic landscape over next 12 months with same number of administrators
  • Unawareness of performance problems until end users complain
  • Manual deployments of software being much too time-consuming, error prone, leading to inconsistent  non-standard configurations

Key Use cases included:

  • Administration Groups and Template Collections – to enforce standard monitoring settings
  • Middleware Diagnostics Advisor – To allow for fast root cause analysis
  • JVM Diagnostics – For application to disk drilldown
  • Provisioning Profiles and Cloning WebLogic Domains – to enforce standard domain deployment

IMG_0103

IMG_0106

Using Provisioning Profiles and Cloning of WebLogic Domains allowed for SSL-Enabled WebLogic Domains with OSB deployed as well as SSL-Enabled Weblogic Domain with WebLogic Portal deployed.

It also supports the differentiation of provisioning profiles in case of dev, test or production situations.

Customized Deployment Procedures were created to provision OSB domains and WebLogic Portal domains.

Initially the EM console has been used for launching deployment procedures, to be later replaced with EMCLI.

Ishaq concludes with some final steps finalise the project including: the creation of custom reports using BI Publisher, the patching of WebLogic Servers across multiple domains, the monitoring to Service Level Agreements and the implementation of Business Transaction Management (BTM).

I must say a very interesting customer story appreciated by many in the audience.

New Features – EM12c 12.1.0.3 – Modify Administration Groups

One very powerful feature in EM12c I think is Administration Groups. It allows you to do a setup of monitoring settings that is continuously up to date.

Monitoring Templates as part of a Template Collections are instantly applied as soon as a Target become member of a Administration Group within its hierarchy.

One issue you could have with the setup of an Application Group Hierarchy is that, after creating it you could not change it anymore and had to delete it before being able to make corrections or extend.

Starting EM12c 12.1.0.3 we can now modify an Administration Group Hierarchy after is has been created, which I think is a very welcome enhancement!

Screen Shot 2013-07-11 at 3.27.43 PM

In the example one level (Location) is added to an existing Hierarchy. The message in the page indicates that the change need to be save to the repository by pressing [Update]

After pressing the [Update] button a message shows up, telling you a job has been started to reorganise the Administration Group Hierarchy and you need to wait for it to finish.

Screen Shot 2013-07-11 at 3.28.39 PM

After the job has finished and you redisplay the page, the modification is completed.

Screen Shot 2013-07-11 at 3.29.10 PM