Connection to Oracle DataGuard???
Posted: 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
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