EMCC: Grafana install and setup with EM13.4

 

#1 Check the grafana versions certified with the emcc grafana plugin at https://www.oracle.com/enterprise-manager/downloads/grafana-downloads.html

At the time this note is written, the certified version for the plugin oracle-emcc-app-1.02 are 6.6.2, 6.7.0, 6.7.1 and 6.7.2.

 

#2 Install the latest certified grafana version, here 6.7.2, on all OMS servers if HA is required.

wget https://dl.grafana.com/oss/release/grafana-6.7.2-1.x86_64.rpm 
yum install grafana-6.7.2-1.x86_64.rpm

 

#3 Start the grafana services

On OL6:

service grafana-server start
service grafana-server status

 

#4 Configure grafana to start at boot time

chkconfig grafana-server on

 

#5 Download the emcc grafana plugin. At the time this note is written, the latest version is oracle-emcc-app-1.0.2

 

#6 Install the plugin

grafana-cli --pluginUrl /mnt/shared/grafana/oracle-emcc-app-1.0.2.zip plugins install oracle-emcc-app

 

#7 Restart the grafana server

service grafana-server restart
service grafana-server status

 

#8 Enable the grafana service in emcc

$ORACLE_HOME/bin/emctl set property -name oracle.sysman.db.restfulapi.grafana.enable -value true -sysman_pwd ${LSYSMAN_PWD}
$ORACLE_HOME/bin/emctl set property -name oracle.sysman.db.restfulapi.grafana.executesql.repository.query.enable -value true -sysman_pwd ${LSYSMAN_PWD}
$ORACLE_HOME/bin/emctl set property -name oracle.sysman.db.restfulapi.grafana.executesql.target.query.enable -value true -sysman_pwd ${LSYSMAN_PWD}
 

 

#9 Login to the grafana console, setup with the port 3000 by default

https://hostname:3000

Default login is admin/admin

 

#10 Enable the Enterprise Manager plugin

Navigate to the Plugins page, select the plugin and click on ‘enable’

 

#11 Configure a datasource to connect to the OMS using a dedicated, non sysman, and non superadmin use, with the view all targets privilege

grafana

 

#12 Optionally, increase the number of requests allowed per seconds

$ORACLE_HOME/bin/emctl set property -name oracle.sysman.db.restfulapi.grafana.throttle.max.concurrent.request -value 5 -sysman_pwd ${LSYSMAN_PWD}
$ORACLE_HOME/bin/emctl set property -name oracle.sysman.db.restfulapi.grafana.throttle.max.req.per.user -value 120 -sysman_pwd ${LSYSMAN_PWD}
$ORACLE_HOME/bin/emctl set property -name oracle.sysman.db.restfulapi.grafana.throttle.max.req.per.user.interval.sec -value 60 -sysman_pwd ${LSYSMAN_PWD}