[-]
  
[-]
  
  
  
  
  
  
  
 
 
[-]
  
  
  
  
[-]
  
 [+]
  
[-]
Monitoring
  
 [+]
 [+]
 [+]
  
[-]
Monitoring guides
  
  
[-]
Templates
  
  
  
[-]
Cloud monitoring
 [+]
  
  
 [+]
Kubernetes
[-]
Network checks
 [+]
  
  
  
[-]
 [+]
  
  
  
  
  
  
 [+]
 [+]
 [+]
 [-]
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
[-]
CounterMeasures
  
 [+]
 [+]
  
  
[-]
Panopta OnSight
 [+]
 [+]
[-]
SNMP
 [+]
  
[-]
Alerting
 [+]
 [+]
 [+]
 [+]
 [+]
[-]
Reporting
  
  
  
[-]
Maintenance
  
  
[-]
API
  
  
  
  
[-]
Users, Groups, and Authentication
 [+]
  
  
  
[-]
Billing and Payments
  
  
  
  
  
  
 
[-]
  
  
  
  
  
  
  
  
  
  
  
  
Updated on 10/15/2019
Online Help
Oracle
Direct link to topic in this publication:

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.

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:

MySQL
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):

Properties (.properties files)
[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 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

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