Is there a way to use the failover clause of the tnsname ?
i.e. a way to implement the automatic use of a failover server in case the first one is off ?
db=
(description=
(load_balance=on)
(failover=on)
(address=(protocol=tcp)(host=host1)(port=1521))
(address=(protocol=tcp)(host=host2)(port=1521))
(connect_data=
(service_name=db)))
Moreover, the use of tns facilitate the configuration management.
The server we use for Talend has the oracle client and the dba push a new tnsnames.ora to the server.
If we use a configuration file or a table to store those data, we have to change it too.
Thanks