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 Not yet released Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME) 1.6.0b1 Not yet released Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME) 1.6.0b1 Not yet released Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME) 1.6.0b1 Not yet released Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME) 1.6.0b1 Not yet released Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME) 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