[Nagiosplug-devel] [ nagiosplug-Patches-650970 ] check_oracle with dummy login

[noreply at sourceforge.net]

Patches item #650970, was opened at 2002-12-09 17:07
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=397599&aid=650970&group_id=29880

Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Ton Voon (tonvoon)
Assigned to: Nobody/Anonymous (nobody)
Summary: check_oracle with dummy login

Initial Comment:
This is a patch to the check_oracle script so there is a --
login check. This is better than a --db and a --tns check 
because it makes a connection to the database, uses a 
dummy id, and then checks that there was a ORA-01017: 
invalid username/password.

For example, this picks up a ORA-01033: ORACLE 
initialization or shutdown in progress which the standard 
check_oracle tests will miss. Will also get Oracle's ORA- 
error message in the returned output.

It does not require a valid userid/password.

Also moved the --help and --version higher up so that these 
messages will be seen before the script complains about an 
the ORACLE_HOME variable.

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

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