Database Oracle¶
The nep-database-oracle provides the minimum requirements to implement a basic monitoring of a Oracle database retriving informations and status using Oracle Instant Client.
The core of this module is based on plugin check_oracle_health.
Using the provided objects, is possible to monitor:
Connected users Count
Connection time
Process usage
Session usage
Tablespace usage
Minimum supported environment¶
This package can be installed on systems running the software described below. Systems with equivalent components are also suitable for installation.
Required software |
Requirements |
|---|---|
NetEye |
Version |
NetEye modules |
|
Package requirements¶
Service and Host Template shipped with package nep-database-oracle require the following nep:
nep-common
Oracle Instant client¶
This package also require the installation of Oracle Instant client. Go to Instant Client Downloads and download the following packages:
oracle-instantclient-basic
oracle-instantclient-sqlplus
Setup instructions¶
If all requirements are met, you can now install this package. To manually set up the nep-database-oracle package, just use nep-setup utility to install it.
nep-setup install nep-database-oracle
In order to be able to collect the needed information from the Oracale database, a dedicated database user with specific privileges is required. Please follow the instructions provided on check_oracle_health website.
Available Objects¶
This section contains a description of all the Objects from this package that can be used to build your own monitoring environment.
Director Objects¶
This package contains the following Director Objects:
Host Templates
The following Host Templates can be used to freely create Host Objects. Remember: do not edit these Host Templates because they will be restored/updated at the next NEP package update.
Host Template name |
Description |
|---|---|
nx-ht-oracle-object |
Represents a generic Oracle Database Server, with its main access coordinates and cretential |
Data fields “Client User name” and “Client user password” must be filled according to dedicated database user created in previous step.
Service Templates
The following Service Templates can be used to freely create Service Objects, Service Apply Rules or Service Sets. Remember to not edit these Service Templates because they will be restored/updated at the next NEP Package update.
Template name |
Run on Agent |
Description |
|---|---|---|
nx-st-agentless-oracle-health |
No |
Service template parent |
nx-st-agentless-oracle-connected-users |
No |
Checks the sum of logged in users at the database |
nx-st-agentless-oracle-connection-time |
No |
Checks how long connection establishment and login take |
nx-st-agentless-oracle-health-sql |
No |
Result of any SQL-Statement that returns a number. The statement itself is passed over with the parameter name |
nx-st-agentless-oracle-health-tnsping |
No |
Checks listener using a connection-time |
nx-st-agentless-oracle-process-usage |
No |
Checks percentage of max possible processes |
nx-st-agentless-oracle-session-usage |
No |
Checks percentage of max possible sessions |
nx-st-agentless-oracle-tablespace-free |
No |
Checks free diskspace in the tablespace |
nx-st-agentless-oracle-tablespace-usage |
No |
Checks used diskspace in the tablespace |
Service Sets
The following Service Sets can be used to freely monitor Host Objects. Remember to not edit these Service Sets because they will be restored/updated at the next NEP Package update.
Service Set name |
Description |
|---|---|
nx-ss-database-oracle-basic |
Service Set providing basic monitoring for Oracle Database Instance |
ITOA Dashboards¶
The Package does not provide any ITOA Dashboards right now.
Package’s objects list¶
Object Type |
Object Name |
Editable |
Containing File |
|---|---|---|---|
Director Host Template |
nx-ht-dbms-database |
Yes |
baskets/import/nep-dbms-base-01-host.json |
Director Host Template |
nx-ht-dbms-instance |
Yes |
baskets/import/nep-dbms-base-01-host.json |
Director Host Template |
nx-ht-dbms-instance-database |
Yes |
baskets/import/nep-dbms-base-01-host.json |
Director Host Template |
nx-ht-dbms-server |
Yes |
baskets/import/nep-dbms-base-01-host.json |
Director Host Template |
nx-ht-dbms-server-database |
Yes |
baskets/import/nep-dbms-base-01-host.json |
Icinga2 Dependency |
nx-disable-notifications-on-parent-dbms-instance-down |
Yes |
custom_files/neteye_shared_root/icinga2/conf.d/nx-dependency-dbms-parent.conf |
Icinga2 Dependency |
nx-disable-notifications-on-parent-dbms-server-down |
Yes |
custom_files/neteye_shared_root/icinga2/conf.d/nx-dependency-dbms-parent.conf |
