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…

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. [image] Monitoring Oracle databases With the plug-in for W…

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

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: [image] 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 documentat…

[image] foobar: [image] 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. Y…

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 …

Hi, [image] 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 c…

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 check…

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

Oracle plugin on windows custom sqls

General

ricardof June 1, 2023, 2:11pm 5

Yes, of course.
The post I refered to is

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”!

Thank you all for your input.