Session Failover TAF tnsnames.ora vs config via srvctl
Hi,
i have configured the TAF Session failover in tnsnames.ora (used successfully for a long time) and tried recently configuring it centrally on the RAC database server.
Both approaches work and do what they should and are somewhat redundant.
Are there any specific advantages for having a central configuration via srvctl over a decentral approach with tnsnames.ora?
tnames Config Sample:
SAP_TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX1-vip)(PORT = 1530))
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX2-vip)(PORT = 1530))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sap_test)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 25)
(DELAY = 5)
)
)
)
Central Config:
i have configured the TAF Session failover in tnsnames.ora (used successfully for a long time) and tried recently configuring it centrally on the RAC database server.
Both approaches work and do what they should and are somewhat redundant.
Are there any specific advantages for having a central configuration via srvctl over a decentral approach with tnsnames.ora?
tnames Config Sample:
SAP_TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX1-vip)(PORT = 1530))
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX2-vip)(PORT = 1530))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sap_test)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 25)
(DELAY = 5)
)
)
)
Central Config:
0