Oracle DBA – A lifelong learning experience

Posts Tagged ‘OEm’

How to add a metric extension and use a ‘control’ table to test results

Posted by John Hallas on November 27, 2017

I have previously blogged about creating a User Defined Metric (UDM) before  (7 years ago!)  but the method I am using today demonstrates how you can test out the alert using specific data.

The aim was to see if integration data is flowing through a table.  If there is a backlog we want to know about it.

Simon Ryan, a colleague did all the preparatory work and created all the 18 !! screen shots which I had to copy and paste into this entry

select * from sm7.EVENTOUTM1; -- Transient table so data not usually present.

The data is processed quickly but occasionally you can see a handful of rows for a few seconds.

 (BLOB) email 08-NOV-2017 11:40:01 0000000005254328

A typical query for the ME would be very simple:

select count(*) from sm7.EVENTOUTM1;

However, we are going to plugin a ‘control’ table in order for us to test the alert by artificially adjusting the results. Read the rest of this entry »


Posted in Oracle | Tagged: , , , | Leave a Comment »

Enterprise manager – How To Install An Additional Management Service

Posted by John Hallas on June 7, 2011

How To Install An Additional Management Service

This document will describe how to install an additional management service for Oracle Enterprise Manager Grid Control on HP-UX. It was written by my colleague Carl Holmes.

You must first install the base release of Enterprise Manager ( and patch it to

The recommended installation method is to install the software, patch it to and then configure Enterprise Manager.

To do this, use these installer commands

./runInstaller -noconfig -ignoreSysPreReqs b_skipDBvalidation=TRUE

Explanation of this command

-noconfig – Do not run the configuration assistants after the software is installed

-ignoreSysPreReqs – Skip the system pre req checks as this version of Enterprise Manager is not aware of HP-UX version 11.31

b_skipDBvalidation=TRUE – Use this command to stop the installer checking the repository database version, as it is not aware of version

When the system pre req screen appears, manually verify the OS version to continue.

When the installation is complete you will be prompted to run  $OMS_HOME/

This runs the scripts for the OMS and the management agent that have just been installed Read the rest of this entry »

Posted in Grid control and agents, Oracle | Tagged: , , , , | Leave a Comment »

Overview of OEM management packs

Posted by John Hallas on December 16, 2010

Porus Homi Havewala who produced two of the top ten most downloaded articles on OTN in 2009 has produced an overview of OEM Management Packs

Mostly centred on the Diagnostic and Tuning Packs, which you need to have purchased before you are allowed to use the ASH views, the article briefly covers Configuration Management, Change Management, Data Masking and other management packs.

If you need to get a good overview of the management packs then this article will do for you.

It does not mention a new one that I know is coming out in Mid 2011 – the data subsetting pack (not sure of the actual title) but it will be a pack/toolset to produce cut down referentially complete smaller versions of larger, normally production databases. It is expected that it will be tightly integrated with the Data Masking Pack so that smaller versions of production databases can be used for development and testing purposes with all confidential data masked.

Posted in Grid control and agents, Oracle | Tagged: , , , , , | Leave a Comment »

How to create a User Defined metric(UDM) in Grid

Posted by John Hallas on December 8, 2010

Using Grid it is possible to create user defined metrics that capture information about the state of a database, a host or an application. Once you have a script or sql statement that returns a value then a UDM can be created. Within EM a report can be created to report the metrics or an alert can be raised.

Firstly I will create a UDM that reports when an account is locked and automatically raise an alert. It may be a simple example but I show one or two issues that can occur.

EM/Select the database/User defined Metrics at the bottom of the main page. Create a new UDM and I suggest starting the name off with a business area such as Retail or EBS as you can end up with quite a few metrics once you get the hang of them.

The key choice to make is whether the output will be a number or a string and whether or not you want one or two values output. In my case I want to know the status of an account so that will be string and I want to output two columns, the username and the status. Enter your query and an account to use for the connection. Ensure that the query works and the account has the privilege to run that query. In this case when  I tested the UDM it fails as I had not  created the accounts beforehand. Select a comparison operator (equal, less than MATCH etc) to the sql query you are running and then format the output you want in the alert.

Note the %Key% and the %value% keywords have to be in exactly that case.

Set the test time to be 5 minutes in the schedule team for the purposes of testing it out and then run the test command (or save if fully confident). Remember to reschedule later. Note 5 minutes is the lowest frequency you can use. Read the rest of this entry »

Posted in Grid control and agents, Oracle | Tagged: , , , | 7 Comments »

The value of in-house seminars (run by the correct people)

Posted by John Hallas on November 2, 2010

Lately we have been very lucky where I work  as we have managed to get Graham Wood from Oracle to pay a visit for the day and we have booked Julian Dyke to present three seminars to us on-site.

Getting the intro to Graham was rather fortuitous as we have another Oak Table member working on site regularly and he put me in touch with Graham. Graham’s role amongst other things is to circulate and present information on what Oracle are doing and in particular around the performance tuning available from within OEM.

He came on site and the idea was that we would give him an hour or so on a system that was obviously new to him and he would have a scout around and then later on he would repeat the process but to a larger audience but this time it would be be much quicker as he already knew some of areas that needed further attention.

Well we (me really) made two mistakes there in that we picked a system which needed work doing on it (which was actually quite intentional) and we got the developers in for that session. It is fair to say that a number of issues around how the application was written were picked up and discussed robustly. The key point was that Graham proved that he could look at a new system using just OEM tools (and we do have the performance packs and are therefore licensed for AWR)  and perform some deep and meaningful analysis.

Perhaps the tool that was newest to most of us was the ability of the sqlmonitor tab under performance monitoring. I have shown an example of how powerful it is. Firstly I looked at Top Activity screen and selected a session that seemed to have done some work Read the rest of this entry »

Posted in Oracle, UKOUG | Tagged: , , , | Leave a Comment »

Producing a grid report

Posted by John Hallas on June 21, 2010

I mentioned that we have a morning check report that we run from OEM in this post . I was asked about it a couple of days ago so I thought I would post the contents as it may give some ideas on what can be monitored and how we use the report.

We check status on the following events and I have shown the code we use for each of the following reports

Usable space in FRA < 20%
Filesystems over 90% used
Database not backed up within 1 day and not blacked out and not a physical standby
Data Guard Status (targets not blacked out)
Alert Log Errors
Database Parameter Changes Read the rest of this entry »

Posted in Oracle, scripts | Tagged: , , , , , , | 14 Comments »