Page 1 of 1

GUI NagiosXI oracle services all get status 'Unknown'

Posted: Mon Mar 25, 2019 6:56 am
by 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.

Re: GUI NagiosXI oracle services all get status 'Unknown'

Posted: Mon Mar 25, 2019 10:37 am
by 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

Re: GUI NagiosXI oracle services all get status 'Unknown'

Posted: Thu Mar 28, 2019 2:40 am
by Timothy
cdienger wrote: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.

Re: GUI NagiosXI oracle services all get status 'Unknown'

Posted: Thu Mar 28, 2019 9:09 am
by 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