Werk #6492: mk_oracle: Add pre- or postfix to TNS alias

Component Checks & agents
Title mk_oracle: Add pre- or postfix to TNS alias
Date Sep 10, 2018
Level Trivial Change
Class New Feature
Compatibility Compatible - no manual interaction needed
Checkmk versions & editions
1.6.0b1 Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)

The SIDs are extracted from the process list via "ps -ef". Some of the extracted SIDs may have a pre- or postfix in tnsnames.ora, eg.
PRE_SID.POST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(Host = HOSTNAME)(Port = PORT)) (CONNECT_DATA = (SID = SID)(GLOBAL_NAME = SID.POSTFIX)) )

The pre- or postfix can be configured in mk_oracle.cfg, eg.
PREFIX='GLOBAL_PRE_' # for all SIDs PREFIX_SID='SPECIFIC_PRE_' # for the specific SID 'SID'
The same works for 'POSTFIX'.

To the list of all Werks