We have DR oracle databases and would like to read from active database.

Our tnsnames.ora have two connection string inside conn1 and conn2

dbdummy=
  (DESCRIPTION_LIST=(LOAD_BALANCE=off)(FAILOVER=on)
    (DESCRIPTION=(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)
      (ADDRESS=(PROTOCOL=TCP)(HOST=conn1)(PORT=1521))
      (CONNECT_DATA=(SERVICE_NAME=dbmp.dbmdr))
    )
    (DESCRIPTION=(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)
      (ADDRESS=(PROTOCOL=TCP)(HOST=conn2)(PORT=1521))
      (CONNECT_DATA=(SERVICE_NAME=dbservice))
    )
  )

We would like have possibility to specify

either

dbdummy to {$ORACLE.CONNSTRING} and recognize connections from HOST vars conn1 and conn2

or

multiple strings - example {$ORACLE.CONNSTRING}=tcp://conn1:1521,tcp://conn2:1521

The reason is that DR DB is not mounted due to licenses and currently and we use two templates with same sql script with two macros

TMPL1

{$ORACLE.CONNSTRING}=conn1

ITEM_KEY: oracle.custom.query[{$ORACLE.CONNSTRING},{$ORACLE.USER},{$ORACLE.PASSWORD},{$ORACLE.SERVICE},sqlquery]

TMPL2

{$ORACLE.CONNSTRING.DR}=conn2

ITEM_KEY:

oracle.custom.query[{$ORACLE.CONNSTRING.DR},{$ORACLE.USER},{$ORACLE.PASSWORD},{$ORACLE.SERVICE},sqlquery]

Always we get data only from one item and the main problem is that zabbix is writing traces to /tmp/oradiag_zabbix/diag/clients/user_zabbix/host_3747817513_110/alert/log.xml and filling /tmp filesystem

It’s workaround to turn off logging for oracle instant client but we would like to avoid unsuccessful connections to standby DB

Interval for our check is 15sec and con not be changed