Oracle Failover String

[ZehEmEe]

Hi Folks,

we currently testing Zabbix with an oracle database backend. Here we have an oracle 11g cluster (rac-1.domain.tld) with an oracle 11g standby cluster (rac-2.domain.tld.
So we use in other application (servers) a failoverstring like this:

(description_list=(load_balance=off)(failover=on)( description=(connect_timeout=3)(retry_count=2)(add ress_list=(load_balance=on)(address=(protocol=tcp) (host=rac-1.domain.tld)(port=1540)))(connect_data=(service_n ame= zbxserv)))(description=(connect_timeout=3)(retry_c ount=2)(address_list=(load_balance=on)(address=(pr otocol=tcp)(host=rac-2.domain.tld)(port=1540)))(connect_data=(service_n ame= zbxserv))))

How i can connect this way to an oracle system. An automatic connect after a database failover will be great.

Cheers

Chris

[bcrespog]

a) Put the failover string in the tnsnames.ora file and use the connection name as connection string in zabbix.

b) Use the new scan name in the listener.

[ZehEmEe]

a) Put the failover string in the tnsnames.ora file and use the connection name as connection string in zabbix.

Where we have to place tnsnames.ora file?

b) Use the new scan name in the listener.

Where we have to place the scan name from tnsnames.ora? DBHost?