The Oracle plugin allows you to monitor a number of metrics which provide insight on the performance, capacity and health of your database server. If you can not find this plugin in the /usr/lib/panopta-agent/plugins folder, then your version of the Agent is out of date and you should update it to gain access to this feature.
The user that is specified above for the agent needs specific permissions in order to access the metrics from Oracle. The user should be created in Oracle with the following grants:
CREATE USER <USERNAME> IDENTIFIED BY "<PASSWORD>";GRANT CREATE SESSION TO <USERNAME>;GRANT SELECT ON dba_data_files TO <USERNAME>;GRANT SELECT ON dba_segments TO <USERNAME>;GRANT SELECT ON dba_free_space to <USERNAME>;GRANT SELECT ON v_$resource_limit to <USERNAME>;
Once the agent is installed you will need to add the following information to the agent config file (/etc/panopta-agent/panopta_agent.cfg):
[oracle]oracle_home = /u01/app/oracle/product/11.2.0/dbhome_1oracle_sid = database_nameusername = usernamepassword = passwordtns_listener_ip = 126.96.36.199
You should replace these variables with the appropriate values. Of these variables, all are required except for tns_listener_ip, which defaults to 127.0.0.1 if it is left out. oracle_home should be set to the same value as the ORACLE_HOME environment variable that is normally set in your shell. The oracle_sid can be set as a comma separated list if you would like to monitor multiple databases.
After making these changes give the agent a few minutes to connect with Panopta’s servers then you should see new server resources available to add for your server in the control panel.
If you have not already, read the “How do I add an Agent Resource?” article to learn how to set up monitoring for any agent plugin. First select “Oracle" from the monitoring catalog.
There are a number of metrics to choose from, and are listed below