Connection to Oracle DataGuard???

Connection to Oracle DataGuard???

Postby Daniel.Kania » Fri 04 Mar 2011 12:32

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
Daniel.Kania
 
Posts: 10
Joined: Wed 10 Mar 2010 13:20

Postby Shalex » Mon 07 Mar 2011 10:35

Usage, advantages, and limitations of Transparent Application Failover (TAF) are described in this article of our documentation: http://www.devart.com/dotconnect/oracle/docs/?Failover.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.
Shalex
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle