CMK version: 2.2.0p24 OS version: RHEL8 / Windows Server Error message: service : [ORA XXX Instance] → A safe execution of d:\oracle\xxxx\bin\sqlplus cannot be guaranteed. Either you need to run the Checkmk agent as non-system user (by using the rule ‘Run plugins and local checks using non-system…

Hi @JPH , We will try to have a remote session with you to clarify and resolve the issue and will then post it public here. I fear my hint in the error message was not precise enough :frowning: Regards Timi

Hi! We have the same issue. What was the solution? Our output: A safe execution of d:\oracle\product\12.1.0\dbhome_1\bin\sqlplus cannot be guaranteed. Either you need to run the checkmk agent as non-system user (by using the rule ‘Run plugins and local checks using non-system account’ or disallow…

[image] [Hotfix] mk_oracle for 2.2.0p24 and 2.1.0p41 Announcements [Latest Update from 10th of April, 14:45] mk_oracle_220-1.0.14.mkp (38.7 KB) mk_oracle_210-1.0.14.mkp (36.9 KB) Hi all, we have now two mkps ready (2.2 and 2.1) which include the following f…

Hi @Ettnamn , for the windows part, we don’t have a mkp ready (yet) but it is expected to be available soon. Regards Timi

Hey @Timi , Same problem here. Or could you already tell us what we need to change to get this check working again? :slight_smile: I tried the rule “Run plugins and local checks using non-system account” with a local user with read-only rights on the system, but I get “Missing monitoring data for…

Regarding the windows part (mk_oracle.ps1), we don’t have any fix public (yet) but @SergejKipnis may could give you a heads-up.

We are also preparing a Windows solution. Currently, I recommend using the old PowerShell script from 2.2p23. With the upcoming new patch for versions 2.1, 2.2, 2.3, you will need to implement one of the following(to monitor Oracle): Remove Write/Full Control/Modify permissions from non-admin us…

Hello all We’ve now running 2.2.0p25 and with these rules the plugin is running in our environment: Bakery Rules: Rule 1: Run plugins and local checks using non-system account ==> Script pattern:mk_oracle.ps1; Local group name: Administrators Rule 2: ORACLE databases (Linux, Solaris, AIX, Window…

We have also added a correspoding KB article. https://checkmk.atlassian.net/wiki/spaces/KB/pages/70582273/Troubleshooting+mk+oracle+for+Windows+and+Linux

2.2.0p24 Oracle Security: mk_oracle.ps1?

Troubleshooting

aeckstein (Andre Eckstein) April 9, 2024, 12:31pm 4