Connection to Oracle DataGuard???

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Daniel.Kania
Posts: 10
Joined: Wed 10 Mar 2010 13:20

Connection to Oracle DataGuard???

Post by 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

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Post by 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 ... 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.

Post Reply