Three Oracle db status need to be monitor ...

[slansing]

I don't think this has been covered yet, but have you ran through:

http://assets.nagios.com/downloads/nagi ... lation.pdf

I'd suggest making another pass so nothing is missed. Please point out if you run into any issues however small they may be.

[xpertech]

It seems that the environment variable not being set properly, but we had followed that document, still can not go through?! same error message. wondering what and where the environment variable to be setup?

for time savings, could we open a case to find out what the problem is?

[sreinhardt]

You can always send in an email to [email protected] however since you are testing via cli the escaping and $user9$ will not work. According to the error, you are missing some of the so files.

Code: Select all

ll /usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so
locate Oracle.so
locate libocci.so

[abrist]

NECRO ALERT!

I resolved a similar problem in a remote today. The solution is to url encode sql mode queries with special characters (the plugin supports url encoding). So the following query:

Code: Select all

--name="select count(*) from v\$session where status = 'active'"

Actually needs to be (remove the wrapping double quotes and encode):

Code: Select all

--name=select%20count(*)%20from%20v%24session%20where%20status%20%3D%20%27active%27 

I just thought I would necro this thread for future forum goers and google site searchers.

[xpertech]

There are two point should be noted ...

1. When using cli command in querying Oracle DB from NagiosXI, you should add environment variables in front of script, e.g.

/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64 /usr/local/nagios/libexec/check_oracle_health --connect 192.168.1.107:1521/test01 --username system --password Passw0rd --mode sql --name="select count(*) from v\$session where status='ACTIVE'" --warning 30 --critical 100

note the two place marked red,
** you should add Oracle service port 1521 and DB name.
** you should use single Backslash(v\$session) and single quote and upper case(depend on Oracle's command).

2. When using GUI in querying Oracle DB from NagiosXI, the above example should use double Backslash(v\\$session).

[slansing]

xpertech,

Are you saying that you resolved this using the above method?

[xpertech]

xpertech,

Are you saying that you resolved this using the above method?

Yes!