I am unable to add an oracle high availability string with load balance and fail over clauses etc. as an oracle data source; something like:
(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=OFF)(FAILOVER=ON)
(ADDRESS=(PROTOCOL=TCP)(HOST=tst-db1.myco.com)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=tst-db2.myco.com)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=some.service.name)(SERVER=DEDICATED)))
I thought maybe defining it in a tnsnames.ora and making it visible to the environment via tns_admin would allow it to forgo the direct host/port field requirements and just rely on the tns entry but it doesn’t seem to be working. Is it just not supported or am I missing something obvious?
Any help is appreciated