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


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}