With Oracle Enterprise Manager (OEM) you are able to monitor an Oracle environment as well as a non-Oracle environment, like Microsoft’s SQL Server.

You are also able to exchange notifications between Oracle Enterprise Manager and e.g. Microsoft’s SCOM. How to monitor this heterogeneous environment. What licenses do you for monitoring? And.. do you need Oracle licenses when sending notifications by mail? Hold on to this thought.

In this blog 3 scenario’s are being discussed (clarifying images later on in this post):

– OEM monitors the Oracle databases as well as the SQL Server-databases and report the notifications through e-mail to a private or central e-mail address.

– OEM monitors the Oracle database, SCOM monitors the SQL Server databases, and SCOM redirect the notifications to OEM. OEM sents the notifications through e-mail.

– OEM monitors the Oracle database, SCOM the SQL Server databases, and OEM redirect the notifications to SCOM. SCOM sents the notifications through e-mail.

Before we dive in these three scenario’s, first what basic license stuff while working with OEM.

Monitoring SQL server databases needs the System Monitoring Plug-in for SQL server:

image

It’s possible to see what management packs you need on your current page of OEM (Click Setup – in the upper-right corner of the page -, then Management Packs, and finally Enable Annotation).

Creating standard ‘incident rules’ don’t need licenses (screenshot of OEM-page):

image

Sending the notifications of these rules to SCOM for example, needs a management pack license:

image

And…… sending notifications to an e-mail address is part of Diagnostic Pack (!):

image

Diagnostic Pack needed for notifications by e-mail

I guess it’s quite an unknown requirement that you need a Diagnostic Pack for notifications per target server with a Enterprise Edition database on it, and thus often forgotten.

Supported Oracle databases

Not only Enterprise Edition is supported. Quote license documentation:

Oracle Enterprise Manager Cloud Control 13c supports management of Oracle Database Standard Edition One, Oracle Database Standard Edition, and Oracle Database Enterprise Edition. Other editions of Oracle Database, such as Oracle Database Personal Edition, which provides single-user development and deployment environments, is not supported by Oracle Enterprise Manager.

Notifications at Standard Edition databases

O.k. You need Diagnostic Pack licenses when e-mailing the notifications of these databases. But what about monitoring a Standard Edition database as you can’t use Diagnostic Pack with Standard Edition?

According to the mentioned rules you are not allowed to sent notifications. And however you can’t use Diagnostic Pack with Standard Edition, technically you are still able to sent notifications. This is explained in note 947827.1. : “How to Explain that Notifications Are Sent Even If the Diagnostic Pack Is Disabled for the Target ? “

Monitoring Standard Edition the same way as an Enterprise Edition is becoming quite a challenge in this way….

Notifications at O.S.-level

All this is not very consistent within OEM. The good news is that notifications on events and incidents for infrastructure targets are free of charge according to the documentation :

image

Querying the repository

Trying to avoid the need of a Diagnostic Pack and create a possibility to monitor a Standard Edition database in a decent way by querying the repository-views has also become quite challenging.

According to the doc you are not allowed to query monitoring views like:

 

MGMT$ALERT_ANNOTATIONS
MGMT$ALERT_CURRENT
MGMT$ALERT_HISTORY
MGMT$ALERT_NOTIF_LOG
MGMT$AVAILABILITY_CURRENT
MGMT$AVAILABILITY_HISTORY
MGMT$BLACKOUT_HISTORY
MGMT$BLACKOUTS
MGMT$METRIC_COLLECTIONS
MGMT$METRIC_CURRENT
MGMT$METRIC_DAILY
MGMT$METRIC_DETAILS
MGMT$METRIC_HOURLY
MGMT$TARGET_METRIC_COLLECTIONS
MGMT$TARGET_METRIC_SETTINGS

while this are very interesting views to query…..

But I’m very confident Oracle is also wrestling with these inconsistencies while monitoring a (non)Oracle environment, and pop up with a solution to this widely  spread problem.

Having all this information, back to the scenario’s

Scenario 1

OEM monitors the Oracle databases as well as the SQL Server-databases and report the notifications through e-mail.

image

What licenses you  need here:

Diagnostic Pack for every monitored Oracle database (=Enterprise Edition database), because you are e-mailing the notifications.

System Monitoring Plug-in for every server where the Non-Oracle Database resides. E.g. 20 servers with a quad core (Intel based) cpu: 20 x 4 cores = 80 cores * 0,5 = 40 Oracle processors.

 

Scenario 2

OEM monitors the Oracle database, SCOM the SQL Server databases, and SCOM redirect the notifications to OEM.

OEM sents the notifications through e-mail to a private or central e-mail address.

image

 

Needed:

Diagnostic Pack for every monitored Oracle database (=Enterprise Edition database), because you are e-mailing the notifications.

Microsoft license: SCOM licenses

Microsoft license: Microsoft Oracle management pack for SCOM

 

Scenario 3

OEM monitors the Oracle database, SCOM the SQL Server databases, and OEM redirect the notifications to SCOM. SCOM report the notifications through e-mail.

 

image

Needed:

Diagnostic Pack for every monitored Oracle database (=Enterprise Edition database), because you are notifying SCOM, and this needs a so-called Management Connector for SQL server’s SCOM. This is included in Diagnostic Pack.

Microsoft SCOM licenses

Notifications through SCOM: out of scope for this article (and frankly I’ll have to investigate, suggestions/corrections are welcome).

Wrapping up this article: look before you leap, and be aware of license consequences while clicking within the enormous potential functionality within Enterprise Manager.

Regards…

 

Sources:

Oracle Enterprise Manager 13c , online documentation database management licensing:

https://docs.oracle.com/cd/E91266_01/OEMLI/GUID-B7FDEFFE-DECB-4826-A3C8-7660B013C5DE.htm#OEMLI117

Diagnostic pack licensing:

https://docs.oracle.com/cd/E24628_01/doc.121/e24474/ch2_db_mgmt.htm#OEMLI114

System monitoring plug-ins for non-Oracle databases:

https://docs.oracle.com/cd/E91266_01/OEMLI/GUID-452D6868-0191-424C-8BCC-6A794906C403.htm#OEMLI144

X