Search found 10 matches
- 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...
- 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...
- 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"...
- 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...
- 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: #############################...
- 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...
- 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 ...
- 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...
- 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...
- 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...