Search found 10 matches

by asytechacd
Tue Oct 06, 2015 1:24 am
Forum: Nagios XI
Topic: help - using the Oracle_Query
Replies: 27
Views: 22810

Re: help - using the Oracle_Query

Try changing the argument to the following and see if it works for you. -connect 10.10.9.8:1521/asywdb --username system --password "manager" --mode sql --name="select count(*) from v$"$"archived_log where applied='NO'" --warning 50 --critical 200 Hi tgriep, At long la...
by asytechacd
Sat Oct 03, 2015 6:47 am
Forum: Nagios XI
Topic: help - using the Oracle_Query
Replies: 27
Views: 22810

Re: help - using the Oracle_Query

Using the "Test" command from within the CCM is not a 100% reliable. It may fail because of escaping issues. It is placed in the CCM for convenience and it is not a substitute for testing from the command line. Try modifying the service by going to Home->Service Detail->Configure->Re-conf...
by asytechacd
Tue Sep 29, 2015 11:28 pm
Forum: Nagios XI
Topic: help - using the Oracle_Query
Replies: 27
Views: 22810

Re: help - using the Oracle_Query

I believe this wiki entry is relevant in escaping the $ in your command https://support.nagios.com/wiki/index.php/Nagios_XI:FAQs#Problems_with_.24_Signs_in_the_Check_Command I believe you may need to change your ARG1 to -connect 10.10.9.8:1521/asywdb --username system --password "manager"...
by asytechacd
Tue Sep 29, 2015 11:18 pm
Forum: Nagios XI
Topic: help - using the Oracle_Query
Replies: 27
Views: 22810

Re: help - using the Oracle_Query

Go to the service in the CCM and copy out the contents of the ARG1 contents, ARG2, however many there are and post them here. Hi tcmdonald, The contents in ARG1 is the same i posted yesterday which I am posting again below: -connect 10.10.9.8:1521/asywdb --username system --password "manager&q...
by asytechacd
Mon Sep 28, 2015 11:03 pm
Forum: Nagios XI
Topic: help - using the Oracle_Query
Replies: 27
Views: 22810

Re: help - using the Oracle_Query

Please post your service configuration so that we can take a look at it. - Go to Configure > Core Config Manager > Services and click the little blue floppy disk icon so that we can see the config details. Thank you Hello ssax, Requested config details are shown below: #############################...
by asytechacd
Sun Sep 27, 2015 6:49 am
Forum: Nagios XI
Topic: help - using the Oracle_Query
Replies: 27
Views: 22810

Re: help - using the Oracle_Query

./check_oracle_health -connect 10.10.9.8:1521/livedb --username system --password 'manager' --mode sql --name='select count(*) from v$archived_log where applied="NO"' --warning 50 --critical 200 Try using the command above (mainly with the double quotes and single quotes changed around an...
by asytechacd
Wed Sep 23, 2015 6:26 am
Forum: Nagios XI
Topic: help - using the Oracle_Query
Replies: 27
Views: 22810

Re: help - using the Oracle_Query

Glad to see it is working at least. Yea, the Test Check Command button is somewhat flawed for reasons that aren't entirely under our control. For security reasons we need to strip out some characters, and PHP interprets things like th $ as language-specific control characters, so it's hard to make ...
by asytechacd
Tue Sep 22, 2015 12:18 am
Forum: Nagios XI
Topic: help - using the Oracle_Query
Replies: 27
Views: 22810

Re: help - using the Oracle_Query

[root@RSRV libexec]# export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib [root@RSRV libexec]# export ORACLE_HOME=/usr/lib/oracle/11.2/client64 [root@RSRV libexec]# ./check_oracle_health -connect 10.10.9.8:1521/livedb --username system --password "manager" --mode sql --name="sele...
by asytechacd
Sat Sep 19, 2015 12:48 am
Forum: Nagios XI
Topic: help - using the Oracle_Query
Replies: 27
Views: 22810

Re: help - using the Oracle_Query

Have you tried running these from the command line? The Test Check Command button is notorious for escaping certain characters. Hi tmcdonald, I tried to run as suggested through the command line. I tried one of the commands which I reported earlier which had reported errors and the result is much t...
by asytechacd
Wed Sep 16, 2015 12:36 am
Forum: Nagios XI
Topic: help - using the Oracle_Query
Replies: 27
Views: 22810

Re: help - using the Oracle_Query

Hello all, Did anyone manage to get any workaround solution on the subject ? I did the same tests as shown in the history and I get the same test results. CASE 1: MY ORIGINAL SELECT STATEMENT ------------------------------------------------- -connect 10.10.9.8:1521/livedb --username system --passwor...