/usr/share/doc/watchdog/examples/dbcheck.sh is in watchdog 5.15-2.
This file is owned by root:root, with mode 0o755.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 | #!/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 255 (-1 as unsigned 8-bit) means reboot
# and 254 (-2) means hard reset.
#
result=254
fi
exit $result
|