The Oracle plugin allows you to monitor a number of metrics that provide insight into 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.

Oracle Configuration

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>;

Agent Configuration

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_1

oracle_sid = database_name

username = username

password = password

tns_listener_ip = 1.2.3.4

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.

Control Panel Configuration

After making these changes give the agent a few minutes to connect with FortiMonitor’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 Add FortiMonitor Agent checks 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