Mk_oracle plugin on aix fails after upgrade to 2.2.0p24

Troubleshooting
, ,
1

CMK version: 2.2.0p24
OS version: aix 7300-01-03-2346

Error message:
<<<oracle_asm_diskgroup>>>
/usr/lib/check_mk_agent/plugins/mk_oracle: line 597: /etc/oracle/olr.loc: The file access permissions do not allow the specified action.
/usr/lib/check_mk_agent/plugins/mk_oracle: line 625: : A file or directory in the path name does not exist.
/usr/lib/check_mk_agent/plugins/mk_oracle: line 597: /etc/oracle/olr.loc: The file access permissions do not allow the specified action.
stat: cannot stat '/bin/crsctl': A file or directory in the path name does not exist.
stat: cannot stat '/bin/crsctl': A file or directory in the path name does not exist.
stat: cannot stat '/bin/crsctl': A file or directory in the path name does not exist.
stat: cannot stat '/bin/crsctl': A file or directory in the path name does not exist.
sh: /bin/crsctl:  not found.
/usr/lib/check_mk_agent/plugins/mk_oracle: line 625: : A file or directory in the path name does not exist.
---

Problem seems to be in the new parsing of the /etc/oracle/olr.loc file.
I can see the new plugin uses a function call to do this: get_crs_home_from_olrloc()
When I remove the file /etc/oracle/olr.loc on the oracle host, the plugin skips this function and does an alternative way of fecthing the oracle homes.
This hack works, and the oracle checks run fine. But it is not a workaround that we can use, because we cant really remove the /etc/oracle/olr.loc file from the system.

2

Hi tblok,

im not 100% sure, as the problem was only mentioned for windows and linux, but there was a fix for a security issue in the mk_oracle plugin that lead to an unusable mk_oracle :

In the download section you can see :

Please note that 2.2.0p24 has an issue with Oracle monitoring affecting windows and linux databases. An exploitable vulnerability was closed leading to a non-functional monitoring of Oracle databases. We are working on a fix and expect a new version to be released in calendar week 14.

3

When I remove the file /etc/oracle/olr.loc on the oracle host, the plugin skips this function and does an alternative way of fecthing the oracle homes.

You should not delete the file as its too dangerous. The parsing is a bug in our mk_oracle agent plugin. As mentioned in the download section we are working on a fix and expect a new version to be released soon.

4

To add to @chauhan_sudhir 's reply, I would suggest following this topic: