I am using the following shell script to check oracle tables spaces.
http://pastie.org/255164 (note: I'm not sure why the pastie is showing "<
Line 212, the sqlplus command, seems to be the problem. From the command line the TEMP_FILE is created and contains all of the tablespaces in it...and the script then reports back tablespaces that have reached the limits for WARNING and CRITICAL (or "OK" if all is well).
From the app, the TEMP_FILE is empty and giving the error on line 237.
The Service Definition:
# Service definition
The Check Command:
# Tablespaces for 'qdev'
command_line /web/nagios/3.0/libexec/check_oracle_tablespace.sh -s qdev -w 95 -c 98 -d .*
I can copy/paste the check command to the prompt and it works fine. It's running from the web front end that fails.
Can someone shed some light on what's wrong? I feel like I'm staring at a wall now and need some fresh eyes.
Nagios Server - Ubuntu 7.10, Nagios 3.0, Oracle Instant Client 10gr2
Oracle Server - RedHat EL 5, Oracle 10.2.0.3 Database