help on check_oracle_health getting an UNKNOWN
Posted: Wed May 15, 2013 3:47 pm
Hello All,
I am receiving an unknown error in my Nagios XI GUI when I try to query my oracle database, but when i enter the command in the command line it works. Can you tell me why it doesn't work in the GUI but works in the commandline.
This is the unknown error below:
UNKNOWN - got no valid response for select count(*) from v where status = 'ACTIVE' - ORA-04044: procedure, function, package, or type is not allowed here (DBD ERROR: error possibly near <*> indicator at char 21 in 'select count(*) from <*>v where status
This is what i have in my $ARG1$ in the service management.
When i test it in the command line it works fine and I am using the exact command in the command line as i did i had in my $ARG1$
I am receiving an unknown error in my Nagios XI GUI when I try to query my oracle database, but when i enter the command in the command line it works. Can you tell me why it doesn't work in the GUI but works in the commandline.
This is the unknown error below:
UNKNOWN - got no valid response for select count(*) from v where status = 'ACTIVE' - ORA-04044: procedure, function, package, or type is not allowed here (DBD ERROR: error possibly near <*> indicator at char 21 in 'select count(*) from <*>v where status
This is what i have in my $ARG1$ in the service management.
Code: Select all
-connect "64.143.xxx.xxx:1522/cdtbd6.db.att.com" --username usr --password "pwd" --mode sql --name="select count(*) from v\$session where status = 'ACTIVE' " --warning 50 --critical 200Code: Select all
[root@oravm2 libexec]# ./check_oracle_health -connect 64.143.xxx.xxx:1522/cdtbd2 --username usr --password "pwd" --mode sql --name="select count(*) from v\$session where status = 'ACTIVE'" --warning 50 --critical 200
OK - select count(*) from v$session where status = 'active': 22 | 'select'=22;50;200
[root@oravm2 libexec]#