Hi Everyone, I am happy to introduce our first out-of-the box WebLogic dashboards in Enterprise Manager App for Grafana.
Oracle EM App for Grafana retrieves time-series and configuration data directly from Enterprise Manager repository, using the new REST APIs hosted in Enterprise Manager Server. You can easily create a dashboard for any targets monitored by Enterprise Manager, such as Oracle Database, Exadata, WebLogic, or E-Business Suite.
Oracle EM App for Grafana ships with out-of-the-box sample dashboards for Enterprise Manager target types. Starting with EM App for Grafana version 2.0, the WebLogic Performance Summary and JVM Performance Report dashboards are bundled with the App. The EM App for Grafana version 2.0 requires Enterprise Manager 13c Release 4 (188.8.131.52) update 7 and above.
The image below is a screenshot of the WebLogic Performance Summary Report dashboard. It has pre-defined panels for WebLogic metrics, such as CPU, Heap, Memory Pool, Active Sessions or Garbage collection, which are the metrics collected by Enterprise Manager. By default, the panels are configured with graph visualization, but you can customize to see them in other visualization styles, such as gauge, heatmap or data table views. Pulldown menus on the upper side of the screen allows you to select one or more WebLogic targets, or quickly switch the data source from one Enterprise Manager instance to another.
One of the advantages of using Grafana is you can easily create a single dashboard with multiple data sources.
For example, in one of your datacenters, you have WebLogic Servers, Oracle Databases and E-Busines Suite application. You also have other components and storage devices, and all of them are monitored by a locally deployed Enterprise Manager.
But this may not be your only datacenter. You may have other data centers having different Enterprise Manager deployment in each location. Using EM app for Grafana, you can consolidate the monitoring information coming from different Enterprise Manager deployments and display them in a single pane of glass view.
As an example, a Grafana dashboard on the screen below has 4 panels, each representing WebLogic Memory Pool statistics. The data in the dashboard is coming from 4 different WebLogic domain targets around the world, providing a federated view of your Global WebLogic Server deployments.
Here are a few simple steps to setup a Grafana server to work with your Enterprise Manager.
Install and setup your Grafana Enterprise server from Grafana labs. EM App for Grafana 2.0 is certified with Grafana Enterprise Edition 7.1.1 and 7.3.1. In this example, I installed version 7.3.1 EE for Linux platform. I used standalone binary installation (tar.gz).
Download the tar.gz file and extract.
$ wget https://dl.grafana.com/enterprise/release/grafana-enterprise-7.3.1.linux-amd64.tar.gz
$ tar -zxvf grafana-enterprise-7.3.1.linux-amd64.tar.gz
This will create a folder named after the version of Grafana server downloaded. E.g., "grafana-7.3.1". From the bin folder, execute the binary to start the server.
$ ./grafana-7.3.1/bin/grafana-server web
By default, URL to the Grafana logon screen is http://<hostname>:3000
Download Oracle EM app for Grafana, version 2.0 (oracle-emcc-app-2.0.0). Follow the instructions in the user's guide to install, either by using the grafana-cli or by unzipping it to the data/plugins folder. Note the “data” folder is created once you run the grafana-server command for the first time.
In this example, I copied the installation file to the data/plugins folder, unzipped contents to the same folder, then restarted the Grafana server.
*<grafana home> directory is grafana-7.3.1/
$ cp oracle-emcc-app-2.0.0.zip <grafana home>/data/plugins
$ cd <grafana home>/data/plugins
$ unzip oracle-emcc-app-2.0.0.zip
$ cd <grafana home>/bin
<stop grafana-server, then restart it with the command below>
$ ./grafana-server web
Oracle EM App for Grafana 2.0 requires Oracle Enterprise Manager 13c Release 4 (184.108.40.206) update 7 and above. Download the latest RU from My Oracle Support > Patches & Updates. Alternatively, you can find a link to download the latest RU in the support note: "Enterprise Manager 13.4 Master Release Update List (Includes Plug-ins) - (Doc ID 2647078.1)”.
Keep in mind that in order to apply the RU, you need to update OMSPatcher and OPatch as well. Please refer to the following support notes for additional details.
Once the latest RU is applied to Enterprise Manager, follow Grafana Plugin User’s Guide Chapter 4 to enable the EM App for Grafana on your Enterprise Manager. You will need to run several emctl commands. I recommend applying the throttling settings to restrict load on your EM site too.
$ ./emctl set property -name oracle.sysman.db.restfulapi.grafana.enable -value true -sysman_pwd <password>
$ ./emctl set property -name oracle.sysman.db.restfulapi.grafana.executesql.repository.query.enable -value true -sysman_pwd <password>
$ ./emctl set property -name oracle.sysman.db.restfulapi.grafana.executesql.target.query.enable -value true -sysman_pwd <password>
Login to Grafana with the URL http://<hostname>:3000.
Go to Configuration > Plugins.
Find Oracle Enterprise Manager App and Click on it.
Click Enable button.
Find two buttons, Update & Disable on the screen to confirm the plugin is enabled.
Select Dashboards tab. Verify the Sample out-of-the-box dashboards, which are imported by the EM App. Confirm Sample – WebLogic Server JVM Performance Report and Sample – WebLogic Server Performance Summary Report are included in the list.
From the toolbar on the left side of the screen, select Configuration > Data Sources.
Click Add data source.
Enter “Enterprise” into the search box to find Oracle Enterprise Manager App, then click on it to add the data source.
The Settings tab will open. Enter Name, URL, Username and Password to access your Enterprise Manager site. URL format is: https://<hostname>:<port> (E.g., https://myhost:7802).
Click Save & Test. This will save the EM configuration and the EM App for Grafana will automatically test the connection.
Green banners indicate the test connection was successful.
Go to Configuration > Plugins. Select Oracle Enterprise Manager App, and click on Dashboards tab to see sample out-of-the-box dashboards. Click on any one of them to open the dashboard. In this example, WebLogic Server Performance Summary Report is selected.
This opens the sample WebLogic Performance dashboard, which is read-only. You can create a copy of the dashboard to customize it. Click Dashboard Settings (gear icon) from the tool bar.
Enter a name for the report, and click Save As, then Save.
Now that a copy of the sample dashboard has been created, you can customize the dashboard. For example, you can change the color of the chart by selecting a bar next to the legends.
Or move around the panels by drag & drop to change the dashboard layout. You can also select the title bar on each panel to edit, remove, or to duplicate the chart.
You can also select multiple targets from the pulldown menu to correlate metric statistics. These are just a few examples of the many things that you can do with your Enterprise Manager data in Grafana.
To save the changes you made on the dashboard, click on Save (floppy disk icon) from the tool bar, then click Save again in the window opened.
For more information on EM App for Grafana, please see Oracle Enterprise Manager App for Grafana User's Guide. Please also refer to the blog Introducing the brand new Oracle Enterprise Manager App for Grafana.