check_oracle.sh

Überprüfund ob Oracle läuft

Überprüfund ob Oracle läuft

#!/bin/bash

APP=$1
PHP=`su - digicol -c "which php" 2>/dev/nul`
CREDENTIALS=`su - digicol -c "$PHP /dot/dc/system/bin/dc_dblogin.php --app $APP" 2>/dev/nul`
SQLPLUS=`echo "exit ;" | su - digicol -c "sqlplus $CREDENTIALS" 2>/dev/null | grep "Connected to" | awk  '{print $1}'`
SQLPLUS2=`echo "exit ;" | su - digicol -c "sqlplus $CREDENTIALS" 2>/dev/null | grep "ERROR" | sed 's/(.*).$/1/'`

 if [ "$SQLPLUS" = Connected ]; then
        echo "OK - Database connections work"
 elif [ "$SQLPLUS2" = ERROR ]; then
        echo "CRITICAL - Database connections don´t work"
 else
        echo "CRITICAL - Database connections don´t work"
 fi