Building an Oracle Management Pack for OpsMgr Cross-Platform Agents, Part 2
March 18, 2010 5 Comments
In the first of my posts regarding development of an UNIX/Linux Cross-Platform management pack for monitoring of Oracle, I described the creation of two custom probe action modules for WSMan Invoke Action and Shell Command Execution operations. In this post, I will describe the creation of a third custom Probe Action for executing SQL queries locally with sqlplus. It was a bit of a challenge to get this probe action functioning the way I had intended, but after some trial and error, it does seem to work quite nicely. The SQL Query probe action is really just a convenient wrapper for the previously discussed ShellCommand probe action.
It accepts as configuration parameters:
