Oracle plugin on windows custom sqls

[ricardof]

Hello everyone,

I’m not sure if this belongs to this category or if it’s troubleshooting. So forgive me if posting in the wrong category.

This is regarding the oracle plugin on windows, mk_oracle.ps1
I’ve set up some Custom SQLs when running Oracle dbs on linux. And I managed to do that thanks to the documentation and some good forum posts.
But now when I look to do the same on windows hosts with oracle dbs, I realize that the “Custom SQLs” section isn’t available in the oracle plugin.
Is that correct? That the Custom SQL only works on linux?
If yes, is there any other way to do that in a windows environment?
If no, how should I config it? I haven’t found any documentation regarding that.

Thanks in advance,

/r

[aeckstein (Andre Eckstein)]

Hi,

a little bit late, but according to the documentation this is unfortunately not possible:

…

Important: It is only possible to query own SQL queries under Linux, AIX and Solaris. Under Windows this option is not available.

Monitoring Oracle databases

[ricardof]

Hi,
I missed that line in the documentation. Thanks for pointing to the source!

/r

[foobar]

Hi @ricardof

As not really using Oracle under Windows I can’t give you the answer, but I would like to ask you about this sidenote:

@ricardof

And I managed to do that thanks to the documentation and some good forum posts.

Could you clarify what was missing in the original documentation? And which particular forum posts helped you to solve - As I guess many others stumble across it too.

Cheers

[ricardof]

@foobar

@ricardof

And I managed to do that thanks to the documentation and some good forum posts.
Hi,

Could you clarify what was missing in the original documentation? And which particular forum posts helped you to solve - As I guess many others stumble across it too.

Yes, of course.
The post I refered to is

Mk_oracle and custom SQL

I am very happy to were able to unblock you Thank you for the PL/SQL Examples. I think they are very helpful for other users trying to get Custom SQL running.

And the documentation was only this line that @aeckstein wrote that I had missed. The answer was right there. “I didn’t see the tree because of the forest of words”!

@aeckstein

Important: It is only possible to query own SQL queries under Linux, AIX and Solaris. Under Windows this option is not available.

Thank you all for your input.

/r

[burgeau (Mark Burgess)]

Faced a similar problem monitoring Oracle on Windows. Ended up running remote checks from the CMK server to the Oracle DB on Windows. When running remote you are using the Linux Oracle plugin which will allow for custom SQL.

The config of the /etc/check_mk/mk_oracle.cfg can get complex but it does tend to work quite well.

[ricardof]

Hi,

@burgeau

Faced a similar problem monitoring Oracle on Windows. Ended up running remote checks from the

CMK server to the Oracle DB on Windows. When running remote you are using the Linux Oracle plugin which will allow for custom SQL.

The config of the /etc/check_mk/mk_oracle.cfg can get complex but it does tend to work quite well.

And to do that you follow the guideline regarding “monitoring remote databases”? Monitoring Oracle databases

r

[burgeau (Mark Burgess)]

Yes correct. If you configure the Oracle Instant Client, make the required config with tnsnames etc it should work well. The agent on the CMK host will piggyback the Oracle plugin data and attach to the target monitored host.

We opted for a combination of agent plugin checks (most of the sync checks) and remote checks (sync + async). Some of the new memory monitoring checks available in 19c do not seem to have made it into the Windows Oracle plugin yet.

Depending on your config and how many databases being monitored - additional remote Oracle checks will push up the CPU util on your CMK host.

[ricardof]

Great. Thank you for the info. I will try that solution