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 |
|
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'.