Page 2 of 2

Re: OracleServerspace most performance graphs not generating

Posted: Fri Apr 17, 2015 2:44 pm
by gsl_ops_practice
Please find below output that you requested.

Code: Select all

[root@localhost nagios]# /usr/local/nagios/libexec/check_oracle_health -V
check_oracle_health (1.7.3)
This nagios plugin comes with ABSOLUTELY NO WARRANTY. You may redistribute
copies of this plugin under the terms of the GNU General Public License.

Code: Select all

[root@localhost nagios]# /usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib ORACLE_HOME=/usr/lib/oracle/11.2/client /usr/local/nagios/libexec/check_oracle_health --connect 'dbserver-1:1537/MYDB' --username 'user' --password 'password' --mode roll-wraps --warning 1 --critical 100
OK - Rollback segment wraps 0.02/sec | rollback_segment_wraps=1;1;100 rollback_segment_wraps_rate=0.02;1;100

Code: Select all

define service {
        host_name                       dbserver-1
        service_description             MYDB Roll Wraps
        use                             xiwizard_oracleserverspace_service
        check_command                   check_xi_oracleserverspace!--connect 'dbserver-1:1537/MYDB' --username 'user' --password 'password' --mode roll-wraps --warning 1 --critical 100
        max_check_attempts              5
        check_interval                  2
        retry_interval                  1
        check_period                    xi_timeperiod_24x7
        notification_interval           60
        notification_period             xi_timeperiod_24x7
        notifications_enabled           0
        contacts                        nagiosadmin
        _xiwizard                       oracleserverspace
        register                        1
        }

Re: OracleServerspace most performance graphs not generating

Posted: Fri Apr 17, 2015 5:21 pm
by Box293
Can you also please show is the command definition for the command:

check_xi_oracleserverspace

Can you tell us the version of the wizard.
Admin > System Extensions > Manage Config Wizards

Re: OracleServerspace most performance graphs not generating

Posted: Fri Apr 17, 2015 6:52 pm
by gsl_ops_practice
Hello,

from /usr/local/nagios/etc/commands.cfg

Code: Select all

define command {
       command_name                             check_xi_oracleserverspace
       command_line                             /usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64 $USER1$/check_oracle_health $ARG1$
}
the Wizard version is 1.5
$786C7B91DABE0DC.jpg
The last character of the password we are using is a dollar sign, not sure if this is relevant, since the first 3 checks work just fine.

Thanks,
Alex

Re: OracleServerspace most performance graphs not generating

Posted: Fri Apr 17, 2015 6:58 pm
by gsl_ops_practice
Ok, on a hunch I changed the oracle password to remove the final character that was a dollar sign. This fixed the issue and the graphs are now generating once I change the password in the service check.

Now I have to go through 5 database servers and modify all the check definitions to change the password...<sigh>

Can you please add this as a bug on your end?

Re: OracleServerspace most performance graphs not generating

Posted: Mon Apr 20, 2015 10:32 am
by lmiltchev
If you want to use a "$" in the password, you will have to probably add a user macro in the "/usr/local/nagios/etc/resource.cfg" file.

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

Re: OracleServerspace most performance graphs not generating

Posted: Tue May 12, 2015 10:14 am
by gsl_ops_practice
This worked, thank you, please close the thread.