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 |
Checkmk Edition | Checkmk Raw (CRE) |
Checkmk Version | 1.6.0b1 |
Level | Trivial Change |
Class | New Feature |
Compatibility | Compatible - no manual interaction needed |
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'.