Nagios Support Forum

Code: Select all

[nagios@nagiosxi-test ~]$ env
HOSTNAME=nagiosxi-test.ber.mytoys.de
SHELL=/bin/bash
TERM=xterm
HISTSIZE=1000
PERL5LIB=/usr/local/nagios/perl/lib
QTDIR=/usr/lib64/qt-3.3
QTINC=/usr/lib64/qt-3.3/include
USER=nagios
LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib/
TNS_ADMIN=/usr/lib/oracle/12.1/client64/lib/network/admin/
MAIL=/var/spool/mail/nagios
PATH=/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/usr/local/nagios/bin:/usr/lib/oracle/12.1/client64//bin
PWD=/usr/local/nagios
LANG=en_US.UTF-8
HISTCONTROL=ignoredups
SHLVL=1
HOME=/usr/local/nagios
LOGNAME=nagios
QTLIB=/usr/lib64/qt-3.3/lib
CVS_RSH=ssh
LESSOPEN=|/usr/bin/lesspipe.sh %s
ORACLE_HOME=/usr/lib/oracle/12.1/client64/
G_BROKEN_FILENAMES=1
_=/bin/env

Code: Select all

[nagios@nagiosxi-test ~]$ tail -50f /var/tmp/db.log 
TERM=linux
LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib
PATH=/sbin:/usr/sbin:/bin:/usr/bin
TNS_ADMIN=/usr/lib/oracle/12.1/client64/lib/network/admin/
runlevel=3
RUNLEVEL=3
LANGSH_SOURCED=1
PWD=/tmp
LANG=en_US.UTF-8
previous=N
PREVLEVEL=N
CONSOLETYPE=vt
SHLVL=3
UPSTART_INSTANCE=
UPSTART_EVENTS=runlevel
UPSTART_JOB=rc
ORACLE_HOME=/usr/lib/oracle/12.1/client64/
_=/bin/env

Code: Select all

ERROR: ORA-12154: TNS:could not resolve the connect identifier specified SP2-0306: Invalid option. Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM}] [edition=value]] where <logon> ::= <username>[/<password>][@<connect_identifier>] <proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>] SP2-0306: Invalid option. Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM}] [edition=value]] where <logon> ::= <username>[/<password>][@<connect_identifier>] <proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>] SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

Code: Select all

[nagios@nagiosxi-test ~]$ cat /etc/sysconfig/nagios
export LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib
export TNS_ADMIN=/usr/lib/oracle/12.1/client64/lib/network/admin/
export ORACLE_HOME=/usr/lib/oracle/12.1/client64/
export PATH=$PATH:$ORACLE_HOME/bin

Code: Select all

define service{
        use                             generic-service         ; Name of service template to use
        host_name                       xxxxxx
        service_description             ORACLE DB ALIVE 
        is_volatile                     0
        check_period                    24x7
        max_check_attempts              3
        normal_check_interval           5
        retry_check_interval            1
        contact_groups                  admins_betrieb, dba_pager, pager, dwh_email
        notification_interval           120
        notification_period             24x7
        notification_options            w,u,c,r
        check_command                   check_ext_db_alive!test!test
}

Code: Select all

define command{
        command_name    check_ext_db_alive
        command_line    $USER1$/check_database_alive.sh $USER3$ $USER4$ $ARG1$ $ARG2$
}

Code: Select all

. /usr/local/nagios/libexec/utils.sh

if [ $# -ne 4 ]
then
  echo "Use: ./check_database_alive.sh user passwd DB-Name"
  echo "Example: ./check_database_alive2.sh nagios *** KRIMI"
  echo 
  echo "Fehler bei der Parameteruebergabe!"
  exit $STATE_UNKOWN
else
  USER=$1
  PASSWORD=$2
  DATABASE=$3
  DATABASE_COMP=$4
fi

env > /var/tmp/db.log

# Hier fragen wir mal die DB ab.
STATUS=`sqlplus -s ${USER}/${PASSWORD}@${DATABASE} << EOF
set head off
select name from v\\$database;
exit;
EOF`

echo $STATUS >> /var/tmp/db.log

TEST_VALUE=""
TEST_VALUE=`echo "$STATUS" | grep $DATABASE_COMP`

if [ "$TEST_VALUE" != "$DATABASE_COMP" ]
then
  echo "CRITICAL: Fehler bei sqlplus-Abfrage der Datenbank $3!"
  exit $STATE_CRITICAL
else
  echo "OK: Erfolgreiche sqlplus-Abfrage der Datenbank $3."
  exit $STATE_OK
fi