GUI NagiosXI oracle services all get status 'Unknown'

[Timothy]

In my GUI NagiosXI, my oracle serverspace services are all getting status 'unknown'.

When I run the commands from CCM for each service, it runs successfully. Can you tell me why it doesn't work in the GUI but works in the command line? I need to fix this so as to add my Oracle servers and services.

Code: Select all

[root@localhost ~]# /usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib ORACLE_HOME=/usr/lib/oracle/12.2/client64 /usr/local/nagios/libexec/check_oracle_health --connect '10.x.x.x:1521/uatdb' --username 'xxxNAGIOS' --password 'EXM$abcde#01' --mode soft-parse-ratio --warning 98: --critical 90:
OK - Soft parse ratio 98.36% | soft_parse_ratio=98.36%;98:;90:
Segmentation fault
You have new mail in /var/spool/mail/root

My version is:
* VM installed, version is Nagios XI 5.4.13.

[cdienger]

The command line isn't completely successful in that it's causing a segmentation fault which will cause the 'unknown' in the gui. Try running the command with the "--method sqlplus" option:

https://support.nagios.com/forum/viewto ... wn#p269488

[Timothy]

The command line isn't completely successful in that it's causing a segmentation fault which will cause the 'unknown' in the gui. Try running the command with the "--method sqlplus" option:

https://support.nagios.com/forum/viewto ... wn#p269488

Could you please show me how to add the '--method sqlplus' option? I am still new to this.

[cdienger]

Here you go:

/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib ORACLE_HOME=/usr/lib/oracle/12.2/client64 /usr/local/nagios/libexec/check_oracle_health --connect '10.x.x.x:1521/uatdb' --username 'xxxNAGIOS' --password 'EXM$abcde#01' --mode soft-parse-ratio --warning 98: --critical 90: --method sqlplus