Oracle (Linux)
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
Metric |
Unit |
---|---|
Current number of Maximum Shared Servers |
|
Current number of transactions |
|
Free space of tablespace in MB |
MB |
Maximum number of enqueue locks |
|
Maximum number of enqueue resources |
|
Maximum number of Global Enqueue Service locks |
|
Maximum number of Global Enqueue Service processes |
|
Maximum number of Global Enqueue Service resources |
|
Maximum number of Maximum Shared Servers |
|
Maximum number of processes |
|
Maximum number of sessions |
|
Maximum number of transactions |
|
Number of current enqueue locks |
|
Number of current enqueue resources |
|
Number of current Global Enqueue Service locks |
|
Number of current Global Enqueue Service processes |
|
Number of current processes |
|
Number of current sessions |
|
Number of Global Enqueue Service resources |
|
Percent of tablespace free |
% |
Size of tablespace in MB |
MB |
TNS listener is active and reachable |
boolean |