ORA errors monitoring

[RIDS_I2MP]

Hello Team,

We want to monitor the ORA errors using Nagios XI.
Please provide us the plugin details which would be best to monitor the same. I checked the check_ora_db plugin but I am unable to find a download file for it.

https://exchange.nagios.org/directory/P ... g)/details

Please help me with the downloads and also a detailed document to monitor the same.

Thanks in advance!!

[jbrunkow]

https://exchange.nagios.org/components/ ... 4&cf_id=29

Does the above link work for you? I tested it and it worked for me.

For detailed steps about setting it up, please refer to the details page about check_ora_db.
https://exchange.nagios.org/directory/P ... g)/details

[RIDS_I2MP]

Hello,

Thanks for your reply!!

I have referred the details provided by you and worked on it. Nagios user is created on Database end and required permissions are also granted. The DB is up and running fine.

Still we are getting below error:

[nagios@HO1-NAGIOSXI libexec]$ ./check_ora_db --action=alertlogerror --service=SSS03128 --oh=oracle\diag\rdbms\sss03128\sss03128\trace --dbuser=nagios --dbpass=****** --port=1443 --host=EG-SALE-ORBO.chalhoub.org --alertlogerrlist=ORA-04045:1::4,ORA-04098::1:4,ORA-27:::24
[CRITICAL] SSS03128-> database is down!
[nagios@HO1-NAGIOSXI libexec]$


[root@HO1-NAGIOSXI libexec]# ./check_ora_db --action=alertlogerror --service=SSS03128 --oh=oracle\diag\rdbms\sss03128\sss03128\trace --dbuser=nagios --dbpass=****** --port=1521 --host=EG-SALE-ORBO.chalhoub.org --alertlogerrlist=ORA-04045:1::4,ORA-04098::1:4,ORA-27:::24
[CRITICAL] SSS03128-> database is down!
[root@HO1-NAGIOSXI libexec]#


Please help me with the commands and also to understand if anything we have missed that is causing this error.

[jbrunkow]

Unfortunately, I don't see any other plugins on the Exchange that do quite the same thing.

You could use the --help option to see the usage instructions for a given plugin.

Code: Select all

./check_ora_db --help

Sometimes you can even reach out to the people who developed it and work with them to resolve it. They may like to get the feedback about it!

[RIDS_I2MP]

Hello,

Can someone else provide help on the same?

[jbrunkow]

I found the following line in the help text for that plugin. Do you think your system could be reading critical because of another event in the last three hours?

--action=ACTION currently supports:

• alertlogerror - checks alert.log errors; by default checks any ORA- error in the last 24 hours; can be customized with 'alertlogerrlist' option
  By default the following error handling is set-up (can be overwritten):
  • ORA-00600 - triggers CRITICAL for any occurrence during last 3 hours
    ORA-07445 - triggers CRITICAL for any occurrence during last 3 hours

This logic seems a bit strange to me... Is there a reason you included that option in your command?

You have the right methodology for troubleshooting plugins. Keep trying different options in the command line until you find a configuration that works. Unfortunately, I can't do that part for you because I don't have an Oracle database like yours to test the plugin against.

[RIDS_I2MP]

Hello,

Thank you for your suggestions!!

I tried checking 2 different DBs with few other examples. Still getting same error.

[gayatri.rathod@vmaz-nagiosxi libexec]$ ./check_ora_db --action=alertlogerror --service=SSS03128 --oh=oracle\diag\rdbms\sss03128\sss03128\trace --dbuser=nagios --dbpass=Nagi0s123 --port=1521 --alertlogerrlist=ORA-04045:1::4
[CRITICAL] SSS03128-> database is down!


[gayatri.rathod@vmaz-nagiosxi libexec]$ ./check_ora_db --action=lsnrstatus --service=SSS03128 --oh=oracle\diag\rdbms\sss03128\sss03128\trace --lsnrports=orahost:1521,orahost:1542
[CRITICAL] Listener status (Host:Port orahost:1521 - CRITICAL) (Host:Port orahost:1542 - CRITICAL)
[gayatri.rathod@vmaz-nagiosxi libexec]$


[gayatri.rathod@vmaz-nagiosxi libexec]$
[gayatri.rathod@vmaz-nagiosxi libexec]$ ./check_ora_db --action=lastColdBackup --service=SSS03128 --oh=oracle\diag\rdbms\sss03128\sss03128\trace --warning=1 --critical=3 --dbuser=nagios --dbpass=Nagi0s123 --port=1521 --host=EG-SALE-ORBO.chalhoub.org
[CRITICAL] SSS03128-> database is down!


[gayatri.rathod@vmaz-nagiosxi libexec]$ ./check_ora_db --action=lastColdBackup --service=SSS03105 --oh=/usr/lib/oracle/19.6/client64 --warning=1 --critical=3 --dbuser=nagios --dbpass=Nagi0s123 --port=1521 --host=EG-CIT-ORBO.chalhoub.org
[CRITICAL] Oracle error: ORA-12154: TNS:could not resolve the connect identifier specified
[gayatri.rathod@vmaz-nagiosxi libexec]$


[gayatri.rathod@vmaz-nagiosxi libexec]$ ./check_ora_db --action=lastColdBackup --service=SSS03105 --oh=/usr/lib/oracle/19.6/client64 --warning=1 --critical=3 --dbuser=nagios --dbpass=Nagi0s123 --port=1521
[CRITICAL] Oracle error: ORA-12541: TNS:no listener
[gayatri.rathod@vmaz-nagiosxi libexec]$

[jbrunkow]

I think that must mean that this server has raised an ORA error some time in the last 24 hours. Do you know whether that is the case?

You may also want to try the check_logfiles plugin to see if that works better for you.
CHECK_LOGFILES

[RIDS_I2MP]

Hello,

Thanks!!
I will check on it and get back to you.

[jbrunkow]

Sounds good! Let us know if that one works better for you.