Mk_oracle.ps1 fails with "Exception 'Failed to compare two elements in the array.'"

FYI

CMK version: 2.2
OS version: Windows Server 2019

Error message:
ORA <SID> Instance - CRIT - Exception ‘Failed to compare two elements in the array.’ during check ‘c:\oracle\product\19.0.0.0\dbhome_1\bin\sqlplus.exe’ - Execution is blocked because you try to run unsafe binary as an administrator. Please, disable ‘Write’, ‘Modify’ and ‘Full control’ access to the the file by non-admin users. Alternatively, you can try to adjust the settings in ‘ORACLE databases (Linux, Solaris, AIX, Windows)’.

However, neither was there any change to the permissions of the binary nor did the mk_oracle.ps1 config change.

On further inspection/google research we stumbled over https://www.reddit.com/r/PowerShell/comments/1b1kj0h/getlocalgroupmember_on_entra_joined_device/ as the error ‘Failed to compare two elements in the array.’ seems to be pretty specific to the powershell cmd-let Get-LocalGroupMember.

And it turns out, that indeed, there was a local Admin group on the windows server that had a member user who was deleted but remained an orphaned entry in the group member list:
the entry is pretty much ineffective and only shown with the S-ID and mk_oracle.ps1 continued to work right after removing the orphaned user.
image

already solved, so this is just in case someone else stumbles over this :wink:

@marcel.arentz or @SergejKipnis FYI - when mk_oracle is moved to Rust, this is probably irrelevant, but just in case you guys ever run into this.

4 Likes

Hey @gstolz,
thank you very much for the heads up! I will see how we can improve the error message or provide help at another place to guide a user to the solution.

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed. Contact an admin if you think this should be re-opened.