Oracle Tablespace

[gdolidze]

I ran the monitoring wizard for Oracle tablespace and I get the following errors.

(No output on stdout) stderr: bumm Can't call method "execute" on an undefined value at /usr/local/nagios/libexec/check_oracle_health line 4891.
(No output on stdout) stderr: Use of uninitialized value in split at /usr/local/nagios/libexec/check_oracle_health line 4579.

This is a physical machine and its OS is RHEL 5.

[jolson]

Please navigate to your services and click on the 'View Text Config' icon, as described in this picture.

2015-07-07 09_48_15-Nagios XI - Nagios Core Config Manager - Firefox Developer Edition.png

After you generate the text config, please send it our way so that we can look it over.

What version of Oracle Database are you using?

[gdolidze]

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit


###############################################################################
#
# Service configuration file
#
# Created by: Nagios Core Config Manager 2.3.3
# Date: 2015-07-07 10:54:23
# Version: Nagios 3.x config file
#
# --- DO NOT EDIT THIS FILE BY HAND ---
# Nagios CCM will overwrite all manual settings during the next update if you
# would like to edit files manually, place them in the 'static' directory or
# import your configs into the CCM by placing them in the 'import' directory.
#
###############################################################################

define service {
host_name digital.cjh.org
service_description / Disk Usage
use xiwizard_nrpe_service
check_command check_nrpe!check_disk!-a '-w 20% -c 10% -p /'
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}

define service {
host_name digital.cjh.org
service_description /exlibris Disk Usage
use xiwizard_nrpe_service
check_command check_nrpe!check_disk!-a '-w 20% -c 10% -p /exlibris'
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}

define service {
host_name digital.cjh.org
service_description /ke3_1 Disk Usage
use xiwizard_nrpe_service
check_command check_nrpe!check_disk!-a '-w 20% -c 10% -p /ke3_1'
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}

define service {
host_name digital.cjh.org
service_description /storage0 Disk Usage
use xiwizard_nrpe_service
check_command check_nrpe!check_disk!-a '-w 20% -c 10% -p /storage0'
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}

define service {
host_name digital.cjh.org
service_description /storage1 Disk Usage
use xiwizard_nrpe_service
check_command check_nrpe!check_disk!-a '-w 2% -c 1% -p /storage1'
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
notifications_enabled 1
contacts nagiosadmin
_xiwizard linux-server
register 1
}

define service {
host_name digital.cjh.org
service_description /storage2 Disk Usage
use xiwizard_nrpe_service
check_command check_nrpe!check_disk!-a '-w % -c % -p /storage2'
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}

define service {
host_name digital.cjh.org
service_description /storage3 Disk Usage
use xiwizard_nrpe_service
check_command check_nrpe!check_disk!-a '-w % -c % -p /storage3'
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}

define service {
host_name digital.cjh.org
service_description CPU Stats
use xiwizard_nrpe_service
check_command check_nrpe!check_cpu_stats!-a '-w 85 -c 95'
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}

define service {
host_name digital.cjh.org
service_description Cron Scheduling Daemon
use xiwizard_nrpe_service
check_command check_nrpe!check_init_service!-a 'crond'
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}

define service {
host_name digital.cjh.org
service_description digital.cjh.org URL Status
use xiwizard_nrpe_service
check_command check_xi_service_http! -f ok -I 67.111.179.146 -u '/' -p 80!!!!!!!
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}

define service {
host_name digital.cjh.org
service_description dtl1 Connected Users
check_command check_xi_oracleserverspace!--connect '67.111.179.146:1521/dtl1.digital.cjh.org' --username 'dtl_dba' --password 'dtl_dba' --mode connected-users --warning 50 --critical 100!!!!!!!
max_check_attempts 1
check_interval 5
retry_interval 5
check_period xi_timeperiod_24x7
notification_period xi_timeperiod_24x7
register 1
}

define service {
host_name digital.cjh.org
service_description dtl1 Connection Time
check_command check_xi_oracleserverspace!--connect '67.111.179.146:1521/dtl1.digital.cjh.org' --username 'dtl_dba' --password 'dtl_dba' --mode connection-time --warning 1 --critical 5!!!!!!!
max_check_attempts 1
check_interval 5
retry_interval 5
check_period xi_timeperiod_24x7
notification_period xi_timeperiod_24x7
register 1
}

define service {
host_name digital.cjh.org
service_description Load
use xiwizard_nrpe_service
check_command check_nrpe!check_load!-a '-w 15,10,5 -c 30,20,10'
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}

define service {
host_name digital.cjh.org
service_description Memory Usage
use xiwizard_nrpe_service
check_command check_nrpe!check_mem!-a '-w 20 -c 10'
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}

define service {
host_name digital.cjh.org
service_description Open Files
use xiwizard_nrpe_service
check_command check_nrpe!check_open_files!-a '-w 30 -c 50'
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}

define service {
host_name digital.cjh.org
service_description Ping
use xiwizard_linuxserver_ping_service
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}

define service {
host_name digital.cjh.org
service_description Sendmail
use xiwizard_nrpe_service
check_command check_nrpe!check_services!-a 'sendmail'
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}

define service {
host_name digital.cjh.org
service_description SSH Server
use xiwizard_nrpe_service
check_command check_nrpe!check_init_service!-a 'sshd'
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}

define service {
host_name digital.cjh.org
service_description Swap Usage
use xiwizard_nrpe_service
check_command check_nrpe!check_swap!-a '-w 50 -c 20'
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}

define service {
host_name digital.cjh.org
service_description Tablespace Can Allocate Next
use xiwizard_oracletablespace_service
check_command check_xi_oracletablespace!--connect 'digital.cjh.org:1521/dtl1.digital.cjh.org' --username 'dtl_dba' --password 'dtl_dba' --mode tablespace-can-allocate-next --warning 20 --critical 30
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
notifications_enabled 1
contacts nagiosadmin
_xiwizard oracletablespace
register 1
}

define service {
host_name digital.cjh.org
service_description Tablespace Fragmentation
use xiwizard_oracletablespace_service
check_command check_xi_oracletablespace!--connect 'digital.cjh.org:1521/dtl1.digital.cjh.org' --username 'dtl_dba' --password 'dtl_dba' --mode tablespace-fragmentation --warning 30: --critical 20:
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard oracletablespace
register 1
}

define service {
host_name digital.cjh.org
service_description Tablespace Free Space
use xiwizard_oracletablespace_service
check_command check_xi_oracletablespace!--connect 'digital.cjh.org:1521/dtl1.digital.cjh.org' --username 'dtl_dba' --password 'dtl_dba' --mode tablespace-free --warning 5: --critical 2:
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard oracletablespace
register 1
}

define service {
host_name digital.cjh.org
service_description Tablespace IO Balance
use xiwizard_oracletablespace_service
check_command check_xi_oracletablespace!--connect 'digital.cjh.org:1521/dtl1.digital.cjh.org' --username 'dtl_dba' --password 'dtl_dba' --mode tablespace-io-balance --warning 50 --critical 100
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard oracletablespace
register 1
}

define service {
host_name digital.cjh.org
service_description Tablespace Remaining Time
use xiwizard_oracletablespace_service
check_command check_xi_oracletablespace!--connect 'digital.cjh.org:1521/dtl1.digital.cjh.org' --username 'dtl_dba' --password 'dtl_dba' --mode tablespace-remaining-time --warning 10 --critical 20
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard oracletablespace
register 1
}

define service {
host_name digital.cjh.org
service_description Tablespace Usage
use xiwizard_oracletablespace_service
check_command check_xi_oracletablespace!--connect 'digital.cjh.org:1521/dtl1.digital.cjh.org' --username 'dtl_dba' --password 'dtl_dba' --mode tablespace-usage --warning 90 --critical 98
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard oracletablespace
register 1
}

define service {
host_name digital.cjh.org
service_description Total Processes
use xiwizard_nrpe_service
check_command check_nrpe!check_procs!-a '-w 1250 -c 1300'
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
notifications_enabled 1
contacts nagiosadmin
_xiwizard linux-server
register 1
}

define service {
host_name digital.cjh.org
service_description Users
use xiwizard_nrpe_service
check_command check_nrpe!check_users!-a '-w 5 -c 10'
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}

define service {
host_name digital.cjh.org
service_description Yum Updates
use xiwizard_nrpe_service
check_command check_nrpe!check_yum!
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard linux-server
register 1
}

###############################################################################
#
# Service configuration file
#
# END OF FILE
#
###############################################################################

[jolson]

Did you run through the following document? If not, you won't have the appropriate libraries installed to make use of the included oracle plugins.
https://assets.nagios.com/downloads/nag ... ios-XI.pdf

[gdolidze]

We have those plugins already.

We have 2 other oracle server that don't have issues with tablespace this server is only this one.

The 2 server that are working fine are version 11's while the one not working is 10, would this have anything to do with it not working.

[ssax]

You might want to check the DB to make sure that the user is proper and it has the same permissions as the other working DBs.

You can view the DB permissions required here:

Code: Select all

https://labs.consol.de/nagios/check_oracle_health/index.html#preparation-of-the-database