We are currently using check_mk (cee 2.0.0p4) as we have saved passwords in the mk_oracle.cfg file.
It looks like:
DBUSER_one=‘sys:pass:sysdba:ip_addr:port’
DBUSER_two=‘sys:pass:sysdba:ip_addr:port’
DBUSER_three=‘sys:pass:sysdba:ip_addr:port’
We want to switch to a wallet configuration.
To existing oracle wallet we added new credentials:
mkstore -wrl wallet_path -createCredential SYS_ONE SYS PASS
mkstore -wrl wallet_path -createCredential SYS_TWO SYS PASS
mkstore -wrl wallet_path -createCredential SYS_THREE SYS PASS
We also have appropriate entries in sqlnet.ora and tnsnames.ora
sqlnet.ora
SQLNET.WALLET_OVERRIDE = TRUE
WALLET_LOCATION=(
SOURCE=(METHOD=FILE)
(METHOD_DATA=(DIRECTORY=wallet_path))
)
tnsnames.ora
SYS_ONE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip_addr)(PORT = port))
)
(CONNECT_DATA =
(SERVICE_NAME=one)
)
)
SYS_TWO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip_addr)(PORT = port))
)
(CONNECT_DATA =
(SERVICE_NAME=two)
)
)
SYS_THREE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip_addr)(PORT = port))
)
(CONNECT_DATA =
(SERVICE_NAME=three)
)
)
What is the correct syntax in mk_oracle.cfg to use the sys user as a sysdba, whose user and password are retrieved from the wallet and there are many instances on the server?