Monitoring oracle service & listener status on nagios

[sh.shekhar89]

Hello Firends,

we want to monitor oracle service and listener status of linux machine on nagios. please let me know how we can monitor.

Thanks

[jolson]

To be clear - you would like to use Nagios to monitor a different linux box. This other linux box is running an Oracle service and is listening on a certain port. Is that true?

[sh.shekhar89]

To be clear - you would like to use Nagios to monitor a different linux box. This other linux box is running an Oracle service and is listening on a certain port. Is that true?

Hi jolson,

Yes i want to monitor oracle services and linstner services of my data base server which is on linux box. i have already added this database server to nagios but now i need is to monitor oracle services.

[jdalrymple]

Have you looked at the following plugin from the exchange to see if it will suit your needs?

http://exchange.nagios.org/directory/Pl ... ed/details

[sh.shekhar89]

Have you looked at the following plugin from the exchange to see if it will suit your needs?

http://exchange.nagios.org/directory/Pl ... ed/details

hi jdalrymple,

I cant see any option to monitor oracle listner status. is there any way if oracle service or listener service got stopped on my data base i will get alert?

[jdalrymple]

Hi sh.shekhar89,

I'll admit I'm a bit of a rookie Oracle admin, knowing little more than how to copy a listener.ora from one machine to the next, however I think this check as a whole will do what you want. I'm fairly certain it will have some output if it cannot connect to the listener. Note that it asks specifically in the command arguments to specify the listener port, which indicates to me if the listener is failed this plugin will report its inability to connect.

If you're looking for something to run remotely and monitor the listener process, that most likely can be done with more of a check processes type command.

Does that make sense?

[sh.shekhar89]

Hi sh.shekhar89,

I'll admit I'm a bit of a rookie Oracle admin, knowing little more than how to copy a listener.ora from one machine to the next, however I think this check as a whole will do what you want. I'm fairly certain it will have some output if it cannot connect to the listener. Note that it asks specifically in the command arguments to specify the listener port, which indicates to me if the listener is failed this plugin will report its inability to connect.

If you're looking for something to run remotely and monitor the listener process, that most likely can be done with more of a check processes type command.

Does that make sense?

Hello jdalrymple, i got your point but we have aproxx more than 100 plus db servers, do i need to copy each servers listener. ora files?? or one will be enough? can you guide me how to check the configure this plugin?

[jdalrymple]

I was just identifying my limited knowledge of configuring an Oracle server when I was mentioning the .ora file. You shouldn't need to copy any .ora files, simply point your check to the appropriate port using the --lsn argument.

Have you attempted to follow the instructions configuring the plugin per the developer? They appear to be fairly complete and well written. I could probably assist, unfortunately I don't have a local environment to do my own prototyping on so it may end up being a long process.

No matter what, I encourage you to at a minimum start by following the developer's very well written instructions found here:
http://exchange.nagios.org/directory/Pl ... ed/details
On a test box. If you run into any part of the process that doesn't work let us know and we'll try to help from there.

[sh.shekhar89]

I was just identifying my limited knowledge of configuring an Oracle server when I was mentioning the .ora file. You shouldn't need to copy any .ora files, simply point your check to the appropriate port using the --lsn argument.

Have you attempted to follow the instructions configuring the plugin per the developer? They appear to be fairly complete and well written. I could probably assist, unfortunately I don't have a local environment to do my own prototyping on so it may end up being a long process.

No matter what, I encourage you to at a minimum start by following the developer's very well written instructions found here:
http://exchange.nagios.org/directory/Pl ... ed/details
On a test box. If you run into any part of the process that doesn't work let us know and we'll try to help from there.

Hello jdalrymple,

Thanks for the help, i am able to monitor listener port through check_tcp, when listener service will be stopped we will get alert.I will try to configure this plugin and check how i can use this.

[jdalrymple]

Were you hoping to instead monitor the listener process on the box hosting Oracle? If so this can be done with NRPE and a check_procs command something like this:

Code: Select all

check_procs -C tnslsnr -c 1:

This would alert CRITICAL if there are no processes running by the name of tnslsnr.