User Guide

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 4.26+

NetEye modules

Core

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