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