CustomSQL queries oracle Windows

General
1

Hi Folks,
and thanks in advance for your contribution.

We are currently monitoring about 20 Oracle databases on Linux, including custom sql queries. As a little but important detail this happens via the orcale plugin at the customersite (to which we dont have direct network access) as a matter of fact there are only agents installed.

I know that this is not possible at the moment with windows oracle monitoring.

  1. Can someone please explain to me why not ?
  2. Is there a different solution, pluging etc.

Thanks - and everbody have a nice day. !

2

Hi Miha,

not sure about the reasoning, and afaik the oracle plugin is on the todo list of the checkmk devs but since it is probably one of, if not the most complicated (I didn’t say ‘hated’, but might as well have :D) to develop, its not an easy task.

Mk_oracle and remote custom queries - #13 by ricardof found a workaround to use the linux agent plugin to connect to another windows host and run custom sql queries, would that work for you?

Gerd

3

@gstolz @Miha

This is the approach we adopted to monitor Oracle on Windows and use the custom SQL option.

  • Setup your Oracle plugin on Windows as you normally would.

  • Deploy and configure the Oracle Linux plugin on the Checkmk host.

  • Exclude all the services in the Oracle Linux plugin config that are performed by the Oracle on Windows agent plugin.

In the mk_oracle.cfg file on the Checkmk host make sure to set the piggyback host column to match the host for the Oracle DB being monitored. The config file will have this format:

'USER:PASSWORD:ROLE:HOST:PORT:PIGGYBACKHOST:SID:VERSION:TNSALIAS'

ie:

REMOTE_INSTANCE_<<ORA_DB_NAME>>='check_mk:<<password>>::<<db_hostname>>:<<db_port>>:<<piggyback_hostname>>:<<DB_SID>>:<<DB_VERSION>>:<<TNS_ALIAS'

Once running correctly you should see the output from the Checkmk agent on the Linux host for the custom SQL wrapped inside the correct piggyback hostname format <<<>>>.

1 Like
4

Thanks - for your answers, will try and let you know the results. :wink: