Werk #15559: mk_oracle: Always use TNS_ALIAS when present
|Title||mk_oracle: Always use TNS_ALIAS when present|
|Date||Apr 21, 2023|
|Checkmk Edition||Checkmk Raw (CRE)|
|Checkmk Version||2.3.0b1 2.2.0b5 2.1.0p27|
|Compatibility||Compatible - no manual interaction needed|
This werk may be relevant for you, in case:
- you want to monitor remote instances
- you are using a TNS_ALIAS to reach the remote instance
Previously, a TNS_ALIAS from mk_oracle.cfg was pinged by the plugin with tnsping in order to verify that this alias can be reached. However, this needs the tool tnsping installed with the oracle client, which is not shipped per default.
A failure led to silently ignoring the TNS_ALIAS and falling back to a potentially invalid connection string which is passed to sqlplus. The plugin now assumes that the given TNS_ALIAS can be reached and uses it.