Execute function help

RouterOS The Dude
1

I want to monitor if our Oracle database server has a database running. I found the easiest way to do this was to use the tnsping utility. I have installed the tnsping utility on The Dude server and I can successfully issue the command

'tnsping ofst'

, which comes back with this output of if it’s up.:

TNS Ping Utility for 32-bit Windows: Version 2.3.2.1.0 - Production on 02-MAY-07
11:00:20

Copyright , 1996(c) Oracle Corporation 1995. All rights reserved.

Attempting to contact (ADDRESS=(COMMUNITY=TCP.world)(PROTOCOL=TCP)(Host=172.16.2
4.151)(Port=1526))
OK (10 msec)

I have then tried to create a new probe and tried to set it to a function to execute this utility and to look at the output. This is what I have for the Available box:

execute(tnsping, ofst) = TNS Ping.\r\n\r\n.\r\n\r\n.\r\nOK.

This is using regular expressions that should coincide with the above output. I have tried all sorts of combinations for the Error and Value fields, but due to the lack of documentation on this project, I cannot find anything to help me.

Also, I am configuring this on a Dude client and I cannot find any information on where this function is executed from. Is it from the client or the server? I need it to be from the server. It does not have the “Execute from server” or “Execute from client” option like the notification does.

Can anyone be of assistance?

2

Abertram, I can’t help you with the code sorry, but can tell you that the probes run from the servers perspective and things like the tools are run from the client.

Regards
Paul

3

Thanks for that information. That helps eliminate some problems.