#!/bin/sh # # check if ORACLE database instance is still reacting to ping requests # # # name of the instance (must be defined in tnsnames.ora) # DATABASE=$1 # # check the state: # tnsping returns 0 on success, otherise the return value is 1 # tnsping $DATABASE > /dev/null 2>&1 result=$? if [ $result -ne 0 ] then # # obviously there is no system error code for this # so we have to create our own (system codes are > 0): -2. # note that -1 means reboot # result=-2 fi exit $result