Getting UNKNOWN status after upgrading Nagios

[inas.labib]

Hi Team,

After upgrading the Nagios version from 5.2.2 to 5.5.9 we are getting Segmentation fault (core dumped) error for the command check_oracle_health and the exit code it is showing as 139.The os version is RHEL6

below is the command running and the output we are getting,

/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64 /usr/local/nagios/libexec/check_oracle_health_backup --connect 'IP:portno/dbname' --username 'USER' --password 'user1234' --mode flash-recovery-area-usage --warning 70 --critical 75

OK - flra (+APP) usage is 0.00% | 'flra_usage_pct'=0.00%;70;75 'flra_usage'=0MB;14336;15360;0;20480
Segmentation fault (core dumped)


In Nagios GUI it is showing status as unknown,Please help on this.

Best Regards

[cdienger]

Add "--method sqlplus" to the command:

https://support.nagios.com/forum/viewto ... it=+oracle

[inas.labib]

Hi

Can you please provide the full command what i need to run.

Thanks

[cdienger]

Try:

/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64 /usr/local/nagios/libexec/check_oracle_health_backup --connect 'IP:portno/dbname' --username 'USER' --password 'user1234' --mode flash-recovery-area-usage --warning 70 --critical 75 --method sqlplus

[inas.labib]

It is working fine Thanks.

[scottwilkerson]

It is working fine Thanks.

May we mark this issue as resolved?