Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
Tell us about your experience with the "Oracle Enterprise Manager App for Grafana ”
Answers
-
OEM Plugin 2.0
Grafana 8.3.6
I have tried on two of test OEM's
OEM 13.4 RU15
OEM 13.5 no RU applied (13.5.0)
Getting same error on both the OEM 13.4 & 13.5. I noticed that someone had the same error posted back on Jan 19, 2021 9:23AM. Can't figure out what the solution was for that person.
-
I ran a curl command to test using a rest API. Here is the output;
# curl -u sysman:xx --request GET 'http://xoradba1t2f.opr.test.statefarm.org:7788/em/websvcs/restful/grafana/v1/enablestatus'
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<html><head>
<title>403 Forbidden</title>
</head><body>
<h1>Forbidden</h1>
<p>You don't have permission to access /em/websvcs/restful/grafana/v1/enablestatus
on this server.<br />
</p>
</body></html>
-
@Rob Fish can you confirm if grafana server has been enabled on the OMS?
-
Instead of GET , change it to POST method and try.
-
Yes, I have run the commands to enable grafana on the OMS.
Here is the rest API call with a POST instead of a GET;
13:26:44 [[email protected]:1 ~]
# date
Tue May 17 13:26:47 UTC 2022
13:26:47 [[email protected]:1 ~]
# curl -u sysman:xx --request POST 'http://xoradba1t2f.opr.test.statefarm.org:7788/em/websvcs/restful/grafana/v1/enablestatus'
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<html><head>
<title>403 Forbidden</title>
</head><body>
<h1>Forbidden</h1>
<p>You don't have permission to access /em/websvcs/restful/grafana/v1/enablestatus
on this server.<br />
</p>
</body></html>
13:26:50 [[email protected]:1 ~]
-
I am doubting that your EM does not have the minimum expected RU in which this service was implemented. Please double-check whether the expected RU was successfully applied on EM.
-
I am using the OEM plugin 2.0.
Here is the OMS version I am connection to;
16:00:53 [[email protected]:1 ~]
$ date
Tue May 17 16:00:56 UTC 2022
16:00:56 [[email protected]:1 ~]
$ emctl getversion oms
Oracle Enterprise Manager Cloud Control 13c Release 5
Copyright (c) 1996, 2021 Oracle Corporation. All rights reserved.
Oracle Enterprise Manager Cloud Control OMS 13c Release 5
16:01:07 [[email protected]:1 ~]
$
-
@Rob Fish is it possible to connect over a call? It would easier to look at your environment and see what's the issue(s).
-
I already successfully add grafana to OEM 13 R3...
Can I get the graphic data like Top Activity ?
can i have a tutorial to custom query ?
-
Custom query creation is documented here: https://docs.oracle.com/en/enterprise-manager/cloud-control/enterprise-manager-cloud-control/13.5/emgrf/use-sql-queries.html. To fetch Top Activity data, you need to figure out the appropriate MGMT view and construct your custom query using that. For example, all monitoring views are documented here: https://docs.oracle.com/en/enterprise-manager/cloud-control/enterprise-manager-cloud-control/13.5/emvws/monitoring-views.html#GUID-E44A4F29-492D-45B0-8CCD-17BA82ACDC92 ... You might need to combine a couple of MGMT views in your custom query to get your data. You can also take a look at the custom queries used in the OOB dashboards like Sample - Single Instance Database Overview Report(available in the latest plugin), etc.
