[Nagiosplug-devel] [ nagiosplug-Patches-755456 ] check_oracle fix if Oracle-Error is reported

[SourceForge.net]

Patches item #755456, was opened at 2003-06-16 18:57
Message generated for change (Comment added) made by tonvoon
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=397599&aid=755456&group_id=29880

Category: Bugfix
Group: None
>Status: Closed
>Resolution: Fixed
Priority: 5
Submitted By: Sven Meyer (scm)
>Assigned to: Ton Voon (tonvoon)
Summary: check_oracle fix if Oracle-Error is reported

Initial Comment:
I frequently stumble into corrupted database, which
typically causes an ORA-12500 to be reported to any
connection request. I found that "check_oracle
--tablespace" (admittedly the only one tested) then
reports no error, but a tablespace size of 0, usage 0.
I'd like a nice error description, so that I can treat
these problem immediately.

Adding the following patch to check_oracle (taken from
Plugins Release 1.3.0)

31a32
> . /etc/profile.d/oracle.sh
254a256,260
>     if [ -n "`echo $result | grep ORA-`" ] ; then
>       echo $result
>       exit $STATE_UNKNOWN
>     fi
>

will report an UNKNOWN-State an reissue to problem as
status information.

"ERROR: ORA-12500: TNS:listener failed to start a
dedicated server process Invalid option. Usage: CONNECT
 [AS SYSDBA ..."


----------------------------------------------------------------------

>Comment By: Ton Voon (tonvoon)
Date: 2003-07-02 17:23

Message:
Logged In: YES 
user_id=664364

Thanks very much for the patch. Applied to r1_3_0 and 
HEAD.

Have changed to STATE_CRITICAL instead of 
STATE_UNKNOWN, as should know about these failures.

Ton

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=397599&aid=755456&group_id=29880