OracleServerspace most performance graphs not generating

[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
        }

[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

[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

[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?

[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

[gsl_ops_practice]

This worked, thank you, please close the thread.