Tell us about your experience with the "Oracle Enterprise Manager App for Grafana ”

Murtaza Husain-Oracle

Announcing the release of NEW

Oracle Enterprise Manager App for Grafana

Version 3.0.0

 Congratulations everyone and thank you to entire team who worked tirelessly last several months to release this new version of the app! 🎉

What’s new!

This new version 3.0.0 of the Grafana App introduces several set of new features designed to enhance the value and the overall customer experience with Oracle Enterprise Manager. 

This update of the app includes 2 brand new out of the box dashboards (see below). It has multiple enhancements and performance bug fixes. This version is also updated & certified to work with newer version of Grafana Server version. 

NEW Dashboard-1: Oracle Host Health Report

This out of the box dashboard gives our customers a quick snapshot view of the overall health of a host target that is discovered within the Enterprise Manager Console.

NEW Dashboard-2: Oracle Single Instance Database Overview Report 

This new dashboard gives a snapshot view of the overall health and configuration of a database discovered in the Enterprise Manager Console.

We also have a new blog that just went live!

For more details refer to the newly published documentation here: Oracle Enterprise Manager App for Grafana User's Guide

Visit the OEM App for Grafana Page

S_Lour

Hi Murtaza, Thanks to Oracle for this long awaited app as OEM has lot of data to show. I am using this app extensively in my org.

For me, One thing is very painful though. I am unable to set Query based variables in my dashboard based on some filters. or joining multiple tables.

Do we have any way to achieve that in addition to this default query ?

{ "type":"target" ,"targettype":"$oem_gf_target_type" , "emsite" : "$oem_gf_emsite" }

Thanks,

Shyam

S_Lour

Hi, I want to use Query variable based on join for two tables:

E.g. select target_name from mgmt$target t, table t2

where t.target_name=t2.target_name and t2.dbole='PRIMARY'

Can we achieve this somehow ?

As we have both PRIMARY and STANDBY in OEM, I want only PRIMARY targets in performance dashboard. But, not sure if I can write that query.

Murtaza Husain-Oracle

Hi Shyam,

Glad to you are enjoying the newly release v3.0 App. In terms of your request pertaining to custom variables, that is something which is on our roadmap for upcoming release. Currently, we only support variables pertaining to target_type, target_name and so on.

Rob Fish

I am trying to install the OEM Plug-in for Grafana and it's not showing up on the Grafana plug-in after the plug-in has been installed. I have used the grafana-cli to install the plug-in. I have stopped/restarted grafana and updated teh defaults.ini file as well. Am I missing something here? Hopefully something simply :) Grafana version 8.3.6

13:18:28 [[email protected]:1 ~]

# date

Fri May 6 13:18:37 UTC 2022

13:18:37 [[email protected]:1 ~]

# grafana-cli --pluginUrl /home/SZ1Q/V1020218-01.zip plugins install oracle-emcc-app

✔ Downloaded oracle-emcc-app v3.0.0 zip successfully

Please restart Grafana after installing plugins. Refer to Grafana documentation for instructions if necessary.

13:18:44 [[email protected]:1 ~]

# grafana-cli plugins ls

installed plugins:

oracle-emcc-app @ 3.0.0

Please restart Grafana after installing plugins. Refer to Grafana documentation for instructions if necessary.

13:21:56 [[email protected]:1 /usr/share/grafana/conf]

# grafana-cli -v

Grafana CLI version 8.3.6

Karl_Brown

We are looking to deploy Grafana plugin, however, our deployment of OEM is on Windows.

According to the following link under the Downloads and Certification section, it states that the plugin is only supported on Linux.

Are there any plans to provide a Windows version of the plugin?

Thanks

Karl

Jennifer Gramling-Oracle

Hi @user10082444

Did you complete the enabling of the plugin in grafana?

https://docs.oracle.com/en/enterprise-manager/cloud-control/enterprise-manager-cloud-control/13.5/emgrf/enable-oracle-enterprise-manager-app-grafana.html

Thanks, Jennifer

Jennifer Gramling-Oracle

Hi @Karl_Brown

We do not have it on our roadmap to port the plugin for Windows at this time.

Thanks, Jennifer

Rob Fish

@Jennifer Gramling-Oracle - no, I am not able to get the Grafana to recognize the OEM 3.0 plug-in.

Jennifer Gramling-Oracle

Hi @user10082444

Please complete the steps in this section, especially Grafana 8.x Configuration.

https://docs.oracle.com/en/enterprise-manager/cloud-control/enterprise-manager-cloud-control/13.5/emgrf/enable-oracle-enterprise-manager-app-grafana.html

This must be done before you will see the app in grafana. Our plugin is unsigned in Grafana, so the enable steps must be completed.