Page 1 of 1

Connection to Oracle DataGuard???

Posted: Fri 04 Mar 2011 12:32
by Daniel.Kania
Hello,
we have x-databases over Oracle DataGuard.

The oracle documentation says, at failover scenario, clients must know on which hosts these databases reside. Therfore TNS Entries must have a Connection_List section containing all hosts participating in the DataGuard configuration. But my connections running over direct mode. How must i set the direct mode connection string?

TNS-Names-Entry:

V1110 = (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PRUTSER)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = EL5)(PORT = 1521))
(CONNECT_DATA = (SERVICE_NAME = V1110)))


Thank you, Daniel

Posted: Mon 07 Mar 2011 10:35
by Shalex
Usage, advantages, and limitations of Transparent Application Failover (TAF) are described in this article of our documentation: http://www.devart.com/dotconnect/oracle ... lover.html. Please note that this feature is available only in the OCI mode (connection via Oracle Client).

The Direct mode doesn't support TAF. You can connect to only one database instance in this mode.