[Nagiosplug-devel] [ nagiosplug-Patches-1873649 ] check_oracle.sh oracle 8

[SourceForge.net]

Patches item #1873649, was opened at 2008-01-17 14:00
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=397599&aid=1873649&group_id=29880

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Bugfix
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Roland Halder (rolandhalder)
Assigned to: Nobody/Anonymous (nobody)
Summary: check_oracle.sh oracle 8

Initial Comment:
check_oracle v1.1 (nagios-plugins 1.4.11)

Problem:
When we used this plugin and queried an ORACLE 8 Server we got this error:

ORA-00933: SQL command not properly ended

Cause:
In Oracle 8 the join statement does not exist.

Solution:
Modified the statement using the old syntax with

WHERE ... (+)= ... AND

Checked the new Version successfully against both:

Oracle Database 10g Release 10.2.0.1.0 - 64bit Production

and the formerly failed

Oracle8i Release 8.1.7.4.1 - Production


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

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