#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
#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}